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,
HL
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.
Highlighted
Moderator

Re: Talend Connection Using Generic ODBC

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

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

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch