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.
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:
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.