topic Re: Talend Connection Using Generic ODBC in Talend Studio

Talend Connection Using Generic ODBC

HLeyes — Tue, 07 Oct 2014 16:23:07 GMT

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

Re: Talend Connection Using Generic ODBC

Anonymous — Wed, 08 Oct 2014 07:04:55 GMT

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 dbc:<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

Anonymous — Wed, 08 Oct 2014 10:37:29 GMT

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