Talend 6 - Using JDBC Instead of ODBC

Six Stars

Talend 6 - Using JDBC Instead of ODBC


In Talend 5x, I was able to use the Generic ODBC connection to connect to an ODBC source (QuickBooks QODBC) - see above screenshot.  I was able to read and extract data fine from QuickBooks.
I see that Talend 6 doesn't have that ability to connect to Generic ODBC any longer. Can someone suggest a workaround or alternative to be able to connect to an ODBC source?  I see the JDBC connection - is there an example somewhere I can see if it will do the same thing?
Thanks in advance,
HL
Seventeen Stars

Re: Talend 6 - Using JDBC Instead of ODBC

Talend 6.x supports Java 8 and with Java 8 the ODBC bridge is gone. Thats why Talend cannot support ODBC anymore because java does not support ODBC. I highly appreciate this because ODBC was always a mess.
There are some commercial vendors providing JDBC drivers for databases which does not have a db vendor supported driver.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch