Talend Connection Using Generic ODBC

Six Stars

Talend Connection Using Generic ODBC

I am attempting to connect TOS to a Sybase SQL Anywhere database using the Generic ODBC DB Type. The SQL Anywhere database has been set up properly in ODBC, as can be seen in the screenshot.  Do I understand that if a data source can be set up in ODBC, it can be connected using the Generic ODBC DB Type in Talend?  I am getting a Connection Failure - You must change the Database Settings message.  Is there another way of accomplishing this?
Thanks in advance,
Seventeen Stars

Re: Talend Connection Using Generic ODBC

A ODBC connection can be established using the Java ODBC bridge. This is a JDBC driver shipped with all Java runtimes and also with Talend.
If you want to create e.g. a connection use a tJDBCConnection component.
Set as 
URL: "jdbcSmiley Surpriseddbc:<your ODBC database name>"
Driver: "sun.jdbc.odbc.JdbcOdbcDriver"
User and password as needed.
At first you have to setup the ODBC connection in Windows.

Re: Talend Connection Using Generic ODBC

Is your ODBC well configured? Did you have the right Driver installed on your computer? This driver installed successfully should be listed in the Odbc Manager of your OS?
Is there any more error info when you click "Details" button?
Best regards
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.



Introduction to Talend Open Studio for Data Integration.


Downloads and Trials

Test drive Talend's enterprise products.