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

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.