Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
HLeyes
Contributor III
Contributor III

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,
HL
Labels (2)
2 Replies
Anonymous
Not applicable

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: "jdbc 0683p000009MA5A.pngdbc:<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.
Anonymous
Not applicable

Hi,
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
Sabrina