topic Re: How to connect to Oracle Database using datasource in Talend Studio

How to connect to Oracle Database using datasource

Anonymous — Sat, 16 Nov 2024 13:08:29 GMT

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

Re: How to connect to Oracle Database using datasource

Anonymous — Mon, 24 Jan 2011 16:35:13 GMT

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

Re: How to connect to Oracle Database using datasource

Anonymous — Mon, 24 Jan 2011 21:36:34 GMT

Check out the tutorials:
http://www.talendforge.org/tutorials/tutorial.php?language=english&idTuto=4

Re: How to connect to Oracle Database using datasource

Anonymous — Tue, 25 Jan 2011 14:25:02 GMT

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

Anonymous — Tue, 25 Jan 2011 16:14:32 GMT

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

Re: How to connect to Oracle Database using datasource

Anonymous — Tue, 25 Jan 2011 21:32:57 GMT

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

Anonymous — Thu, 27 Jan 2011 14:37:27 GMT

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.