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

  • 1
  • 3
  • Question
  • Updated 2 years 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.

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

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.


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

Steps to read Data

Use API_Authenticate to get ticket which can be used to make

Use API_DoQuery

Let me know if you need any additional information.

Thank you Gaurav.
Photo of Angel


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