How Can I integrate my form with Oracle database?

  • Profile Image
    javeriamahveen
    Asked on January 22, 2018 at 06:01 AM

    Can I use Oracle database?



    This is a re-post of a comment on How to send Submissions to Your MySQL Database Using PHP

  • Profile Image
    TREVON
    Answered on January 22, 2018 at 09:48 AM

    You can use the Oracle export widget which will allow you to export your form data in Oracle format.

    https://apps.jotform.com/app/oracle_export

    Kindly do let us know if you need further assistance.


  • Profile Image
    javeriamahveen
    Answered on January 23, 2018 at 12:16 AM

    I actually want the other way that means data from Oracle database to be populated in the form.

  • Profile Image
    BJoanna
    Answered on January 23, 2018 at 05:18 AM

    Unfortunately, it is not possible to pre-populate a standalone form from the external database. The currently available functionality is the other way around - that is exporting or pushing the data to your database.

    If you have the programming resource, you can create a custom program using server side programming like PHP to create an interface/connection to pull data from your database to the form fields. You will also need to embed your form using the full source code. A similar undertaking had been done on this thread

    You can pre-populate the form manually using our Pre-populate app: http://prepopulate.jotform.io/ 

    We also have the Spreadsheet to Form Widget. This widget allows you to upload a spreadsheet to your form and use the values you have on the spreadsheet to pre-populate the form. Inside of this guide you can find how to use this widget:

    How to Use the Spreadsheet to Form Widget