1. I am trying to connect Talend to QuickBase via this third party ODBC connector.
2. I'm trying to do this via a JDBC-ODBC bridge driver. The JDBC-ODBC bridge was removed in the latest Java Development Kit (JDK), version 8, so I am trying to enable it with the driver from the previous version 7. I followed the instructions here.
3. Next, I believe I need to do revise the connection string in the code provided in this site to include "QuickBase via QuNect 64 bit" (the DSN source name). I am unsure how to create the jar file once the script is edited, however. Has anyone successfully connected Talend to an ODBC DSN data source or can someone help me? I'm sure there are others who have encountered this challenge.
We have used EasySoft JDBC-ODBC Bridge for some customers for some very old systems. Not sure about the one from QuNect that you are referring here since I have never tried it.
See http://www.easysoft.com/products/data_access/jdbc_odbc_bridge/#section=tab-1 for the one I tried before.
Hope that helps.
I'm trying to do exact same thing and so far have made less progress than you, so am interested to hear if you get it working. I'm considering using a 3rd part ODBC-JDBC bridge rather than older version of java, but if you get that to work I'd love to hear about it. I'm disappointed that Talend doesn't provide their own ODBC driver now that Java does not.
Building a JDBC-ODBC bridge is a complex task. And there are companies like EasySoft who just build these bridges. If there is a jdbc-odbc driver from the open source community, we can easily leverage. We have not found one from the open source community.
This is the same as someone building a Windows Application vs Building Windows Drivers. These are 2 completely different set of skills and R&D team needed
Definitely agree that building one will be great if we have the resources and knowledge to build one :-)
Another approach would be to build connectors specifically for the Quickbase database. They provide an open-source Java SDK here: https://github.com/QuickbaseAdmirer/QuickBase-Java-SDK
I know that's a lot less generic than an ODBC connector, but probably a lot easier to implement too. I don't know how you guys make decisions about how to prioritize which platforms to support, but Quickbase is extremely popular and growing fast, so I could imagine people choosing to use Talend for that reason alone (data integration with Quickbase). I am on the verge of switching to Microsoft SSIS for this reason alone (they support ODBC and Quickbase), but I really prefer to stay with Talend if I can.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.