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

  • 1
  • 3
  • Question
  • Updated 1 year ago
  • Answered
  • (Edited)
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.
Photo of Marco Pece

Marco Pece

  • 80 Points 75 badge 2x thumb

Posted 2 years ago

  • 1
  • 3

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.


Photo of Gaurav Sharma

Gaurav Sharma

  • 5,746 Points 5k badge 2x thumb
Good Explanation :)
Thank you Gaurav.
Photo of Angel

Angel

  • 724 Points 500 badge 2x thumb
Try using Restful APIs to pull data from QB and push them to the DB.