Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Labels (3)
6 Replies
Anonymous
Not applicable
Author

Any Help Appreciated............thanks
Anonymous
Not applicable
Author

Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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

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
Anonymous
Not applicable
Author

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.