Setting up multiple database connections for use in Data Integration Studio

[prenderj]

Hi,

I am having issues having 2 oracle database connections running concurrently in Data Integration Studio.

I had an existing odbc, user group and library for database 1. All worked fine.

I then added a new odbc connection, a new library and a new user group. This database has a different username and password to database 1.

I have 2 jobs in DI, one referring database 1 the other database 2.

If i delete the username and password for the user group database1 and recreate then the job associated with database 2 will work and job 1 will not work. If i then delete the password associated with database 2 and recreate the password then the job associated with database1 will work and job 2 will stop working.

So it appears to be the username and password associated with the first user group created that is maintained.

Am i missing a link somewhere? Is it possible to have jobs looking at multiple schemas?

Where can I locate the log files for DI?

Thanks.

[LinusH]

This is tricky stuff to trouble shoot, especially via a forum.

It should work...

So where do you store the userid/psw? In the user group account (I hope)?

Do you use AUTHDOMAIN= in your library definition?

Logs, it not always obvious which log to look in:

• The DI Studio Log of course. Adding options sastrace=',,,d' sastraceloc=saslog nostsuffix msglevel=i; might give you some more info.
• Metadata server log, holds authentication info
• Even the Object Spawner log might give some clues