Discussions

Expand all | Collapse all

is there a way that we can export Quickbase data to an Oracle DB.

  • 1.  is there a way that we can export Quickbase data to an Oracle DB.

    Posted 05-12-2017 18:45
    We use Quickbase as a CRM app. Is there a way that we export Quickbase data to Oracle DB? We could export the data to CSV and import into Oracle. But was wondering if there is an automated way to do this? Say have Oracle run a night job to read data from QuickBase.


  • 2.  RE: is there a way that we can export Quickbase data to an Oracle DB.

    Posted 05-15-2017 15:35

    Hi Marco,

    There are different ways to build this cron/scheduled job to pull and store data into oracle DB.  Since you wanted this to be built in oracle, below instructions are one way to achieve this.

    1. Pull Data from Quickbase using HTTP API that gives data in XML format.

    Refer to the NOTES below for Quickbase API information.

    2. Build an oracle stored procedure using PL/SQL, use HTTPURITYPE to consume HTTP GET request and read XML data received using Quickbase HTTP API.  Use below link on how to do this.

    https://sonra.io/2009/03/12/consuming-a-rest-web-service-with-oracle/

    3. Once the stored procedure is ready, schedule it for timely download.  Use below link for setting up scheduler.

    https://docs.oracle.com/cd/E11882_01/server.112/e25494/scheduse.htm

    4. Use XMLTABLE to extract the data received from Quickbase API GET Response.  Follow below link for using this or any other oracle library to read XML response.

    https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions228.htm


    NOTES:

    Quickbase exposes HTTP API to read data, follow the below guide hosted by Quickbase to read data out of it in XML.

    https://help.quickbase.com/api-guide/index.html

    Steps to read Data

    Use API_Authenticate to get ticket which can be used to make

    https://help.quickbase.com/api-guide/index.html#authenticate.html

    Use API_DoQuery

    https://help.quickbase.com/api-guide/index.html#do_query.html

    Let me know if you need any additional information.




  • 3.  RE: is there a way that we can export Quickbase data to an Oracle DB.

    Posted 05-15-2017 15:50
    Good Explanation :)


  • 4.  RE: is there a way that we can export Quickbase data to an Oracle DB.

    Posted 05-16-2017 15:03
    Thank you Gaurav.


  • 5.  RE: is there a way that we can export Quickbase data to an Oracle DB.

    Posted 05-24-2017 15:09
    Try using Restful APIs to pull data from QB and push them to the DB.