Solved! Go to Solution.
I tried to create the connection in repository but without any success.
Did you get "no ocijdbc11 in java.library.path" error message?(I cannot see the error "java.sql.SQLException: ??" ) If so, when you use the oracle oci to conntect remote oracle database , you need install Oracle Client on your computer.
See the related document TalendHelpCenter: Setting up a DB connection
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables