Hi,
Is there any way that I can connect to DB2 databases without cataloging it in system just like how it works in the Oracle connector where even though you do not have a tnsentry but you will be able to connect to Oracle database.
Thanks
Rajan
DB2 CONNECTOR - Without Cataloging
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 1
- Joined: Mon Apr 23, 2012 12:20 pm
You could use the ODBC Connector stage with the ODBC DB2 wire protocol driver. It does not require a DB2 client to be installed, but it does require an ODBC data source to be defined in the .odbc.ini file.
I have heard that newer releases, such as DataStage 11.3.x, also allow for using JDBC connections. That may be another option, if true, although I'm not sure which stage type you may have to use with it.
I have heard that newer releases, such as DataStage 11.3.x, also allow for using JDBC connections. That may be another option, if true, although I'm not sure which stage type you may have to use with it.
Choose a job you love, and you will never have to work a day in your life. - Confucius
-
- Participant
- Posts: 32
- Joined: Fri Nov 07, 2014 11:18 am
Re: DB2 CONNECTOR - Without Cataloging
what is stopping you in doing cataloging ? its pretty simple and there is no way you can connect to db2 with out using odbc or db2 catalogging.smile8work wrote:Hi,
Is there any way that I can connect to DB2 databases without cataloging it in system just like how it works in the Oracle connector where even though you do not have a tnsentry but you will be able to connect to Oracle database.
Thanks
Rajan
A Kumar
Re: DB2 CONNECTOR - Without Cataloging
what is stopping you in doing cataloging ? its pretty simple and there is no way you can connect to db2 with out using odbc or db2 catalogging.smile8work wrote:Hi,
Is there any way that I can connect to DB2 databases without cataloging it in system just like how it works in the Oracle connector where even though you do not have a tnsentry but you will be able to connect to Oracle database.
Thanks
Rajan
A Kumar