Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Configuring ODI with the IBM db2

741164Dec 15 2009 — edited Dec 19 2009
Hi all,
I am new to this technology.I want to configure my IBM db2 data base with oracle data integrator.I have installeled IBM db2 & ODI on my machine.I am trying to create repositories but how to do it for IBM db2.
My task is..
1)creating the repository for IBM db2.
2)Configuring it with ODI
3)Exporting the dump data to IBM db2 database



Thanks in advance.

Comments

Cezar Santos
Hi,

In your "Master Repository Creation" there is the DB2 technology to be chosen... and you can test if the connection works fine.

It is very easy to execute it.

Work for you?


Cezar Santos
[www.odiexperts.com]
1 person found this helpful
741164
Hi Cezar,
Thanx for ur reply...
I am trying to connect to repository But I am confused abt< property> & <value> field of the URL Tab.I am not able to understand the description "Connection properties. Refer to the driver's documentation for a list of available properties."
Thanx again..
Cezar Santos
As far as I know you don't need them in a conventional connection.

Quit it from the url!


Cezar Santos
[www.odiexperts.com]
741164
Hi Cezar,

Thanx again for ur reply...
I have done as you said but still getting error as "Connection Failed" as follows

*com.ibm.db2.jcc.am.yn: [jcc][t4][2043][11550][3.57.82] Exception java.net.ConnectException: Error opening socket to server localhost/127.0.0.1 on port 50,000 with message: Connection refused: connect. ERRORCODE=-4499, SQLSTATE=08001*

Regards,
Mandar
Cezar Santos
Are you sure about connect to localhost?

I don't know DB2 messages so well to help you with the error...

Did you google it?

Cezar Santos
[www.odiexperts.com]
721646
Hi Mandar,
Just to confirm what is the operating system installed on your machine?
741164
windows XP
741164
hi cezar,
my issue is soleved.the reason is that i had not created the libraries ie databases where i can host the repositories.Again problem with it was that unlike oracle,you can't create the user at database level in IBM db2.So I created the user at os level granting the access to repository. then created the repositories.
Thanks for ur help.Your odiexpert.com was also helpful
Cezar Santos
Good to know that [odiexperts.com] helped you, but, above that, good to know that you got the problem solved!!!


Cezar Santos
[www.odiexperts.com]
1 - 9
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 16 2010
Added on Dec 15 2009
#business-intelligence-applications, #data-integrator, #odi, #system-management-and-integration
9 comments
2,810 views