One Star

How to connect to Oracle Database using datasource

How to connect to Oracle Database using datasource - Any sample screen shot will help.
What control in talend that will help to connect to oracle database using datasource and how to configure it.
Thanks
6 REPLIES
One Star

Re: How to connect to Oracle Database using datasource

Any Help Appreciated............thanks

Re: How to connect to Oracle Database using datasource

One Star

Re: How to connect to Oracle Database using datasource

Thanks for your reply.
I am looking for Database lookup (datasource) rather than providing url , userid and password.
Note : datasoruce already configured on server, Is there a way in talend to lookup?
Thanks

Re: How to connect to Oracle Database using datasource

you can use a TNS file.... Not sure what you mean by "datasource"
One Star

Re: How to connect to Oracle Database using datasource

Thanks John,
My point is datasource (ex; DBConnect) is configure on server with DB url's, userid and password.
how to do lookup (JNDI call) of that datasource using talend job which is deployed/running on that server.
For example my talend application is deployed as part of server (ex;tomcat), I need to get the database connection using lookup in talend job and used that connect to run DB queries.
Thanks

Re: How to connect to Oracle Database using datasource

ahh.
Youll have to deploy your job as a webservice, and then in a tOracleConnection set the "Use or register a shared DB Connection" and define your JNDI datasource there.