03-20-2015 04:29 AM
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?
03-20-2015 05:56 AM
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: