IBM DB2 connection
Does anyone know of a way to pull data into quickbase from a IMB DB2 database? ------------------------------ Carol Mcconnell ------------------------------
Forum Discussion
Hi, what do you need? Update as400 from quickbase, or update quickbase from as400 ? or dobleWay?
------------------------------
Marcelo Benavides
------------------------------
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
------------------------------
