Which Driver or JAR is used to connect difffernt database dynamically

Which Driver or JAR is used to connect difffernt database dynamically

Dear All,
      I'm very Newer in Talend and may ask small questions
     I tried to connect dynamically different databases in a single job and i know it is possible through tJDBCConnection but which jar/Driver is suitable for dynamic database connectivity and Pls explain me how to connect
   I saw one post, they used "sun.jdbc.odbc.JdbcOdbcDriver" Driver but i cant find this anywhere

Thanks In Advance
Iyappan
   
Moderator

Re: Which Driver or JAR is used to connect difffernt database dynamically

Hi,
Which Database do you want to connect? 
You should enter the driver class related to your connection. For example, enter com.mysql.jdbc.Driver as a driver class to connect to a mysql database.
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.

Re: Which Driver or JAR is used to connect difffernt database dynamically

Hi,
Thanks for Your replay, i need to connect different database like oracle,mssql and mysql dynamically. Is there any Driver to connect those database commonly

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

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog