IBM DB2 connection

Question

Does anyone know of a way to pull data into quickbase from a IMB DB2 database?------------------------------Carol Mcconnell------------------------------

donlarson · Answer

Carol,
I can assist with getting data out and into a SQL Compliant DB.&nbsp; Retrieving data from DB2 is bit more complicated.------------------------------Don Larson------------------------------

chayceduncan · Answer

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.&nbsp;------------------------------Chayce Duncan------------------------------

marcelobenavide · Answer

Hi, what do you need?&nbsp;&nbsp;&nbsp; Update as400 from quickbase, or update quickbase from as400 ?&nbsp;&nbsp; or dobleWay?------------------------------Marcelo Benavides------------------------------

carolmcconnell · Answer

I don't want to write to the DB2, I just want QB to be able to pull from the DB2.&nbsp; 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------------------------------

marcelobenavide · Answer

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
------------------------------

Forum Discussion

IBM DB2 connection