Can I import data from an Oracle Database into a form?

  • Profile Image
    DJ 
    Asked on August 23, 2017 at 11:39 AM

    We have a need to integrate forms requiring signature using web hooks into our software.

    We want to do the following:

    Push the details from the Oracle database to the form

    The client receives an email with a link to the form

    The client makes selections using check boxes and radio buttons

    The client signs the form

    The selections are pushed back to the database

    Possible?

    Thanks,

    DJ

  • Profile Image
    aubreybourke
    Answered on August 23, 2017 at 12:38 PM

    Unfortunately I don't think this is possible. We have limited support for exporting submissions to Oracle 

    http://oracle.jotform.io/

     

  • Profile Image
    DJ 
    Answered on August 25, 2017 at 10:52 AM

    As a follow up question. If the data is transformed to csv on both the push and the pull, will that work?

  • Profile Image
    Nik_C
    Answered on August 25, 2017 at 11:59 AM

    You mean to export the CSV file from your submissions and then import it to SQL database?

    If that's the case, then yes, that would work, you just need to make sure that the column names in CSV match the column names in SQL database.

    I just run a quick test and that worked just fine.

    If you experience any difficulty please let us know.

    Thank you!