IBM DB2 connection
Does anyone know of a way to pull data into quickbase from a IMB DB2 database? ------------------------------ Carol Mcconnell ------------------------------
Forum Discussion
I don't want to write to the DB2, I just want QB to be able to pull from the DB2. I can download the information I want and import it into quickbase but I was wondering if there was a way for QB to query the DB2?
------------------------------
Carol Mcconnell
------------------------------
As far as I have been able to investigate, it is not possible, there are odbc tools that allow you to write in Quickbase but that affects the API count, which after an annual amount can generate monetary charges. If this is a one-time thing, downloading and importing is the best option, if this is something recurring and online, I suggest you rely on loading data for quickbase via JSON - APIrest (In this I have had a very good experience with codepage development )
------------------------------
Marcelo Benavides
------------------------------
If the direction of the integration is from DB2 to QB and you're only writing to QB then there is no count to your API costs. Quickbase cares about Reads, if you're pulling from DB2 and then loading to QB that wouldn't count or incur charges so certainly a viable option to use ODBC and pull data.
------------------------------
Chayce Duncan
------------------------------My suggestion is talk with your account manager. My account manager said me: "all actions or calls from external software( ex. odbc, juice, etc) will be count in the year cuotes".
Thank you
Marcelo Benavides Torres
------------------------------
Marcelo Benavides
------------------------------I agree with Chayce, integration READS are what Quickbase charges for. Adds and Edits are not considered integration reads and are not charged for. I'm basing this off their documentation and discussions with Quickbase.
from their help site:
https://helpv2.quickbase.com/hc/en-us/articles/4570419347476-Quickbase-Pricing-Frequently-Asked-Questions-snippet from that link...
An Integration Read is NOT:
- An API Call or Pipeline Step Run that…
- Creates of Edits Quickbase Data
- Builds or Improves Quickbase Applications
- Manages or Administrates the Quickbase Platform
- Receive data from external systems.
-
API Calls from Quickbase Sync, Quickbase Automations, and Quickbase Webhooks
Another Technical Integration Read link:
https://helpv2.quickbase.com/hc/en-us/articles/4570366542484-Technical-summary-of-User-and-Integration-Reads-So using the ODBC connector or another tool that Don Larson has should not impact your api charges unless you are reading data from Quickbase. If you are importing data into Quickbase it should be ok.
And yes, its always best to consult your Quickbase account executive to confirm pricing impact before starting an integration project like this.
------------------------------
Keith Jusas
------------------------------- An API Call or Pipeline Step Run that…
