Setting up multiple database connections for use in Data Integration Studio

Reply
Occasional Contributor
Posts: 9

Setting up multiple database connections for use in Data Integration Studio

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.

Esteemed Advisor
Posts: 5,198

Re: Setting up multiple database connections for use in Data Integration Studio

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
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 125 views
  • 0 likes
  • 2 in conversation