topic Re: Setting up multiple database connections for use in Data Integration Studio in SAS Programming https://communities.sas.com/t5/SAS-Programming/Setting-up-multiple-database-connections-for-use-in-Data/m-p/206545#M267162 <HTML><HEAD></HEAD><BODY><P>This is tricky stuff to trouble shoot, especially via a forum.</P><P>It should work...</P><P>So where do you store the userid/psw? In the user group account (I hope)?</P><P>Do you use AUTHDOMAIN= in your library definition?</P><P></P><P>Logs, it not always obvious which log to look in:</P><UL><LI>The DI Studio Log of course. Adding options sastrace=',,,d' sastraceloc=saslog nostsuffix msglevel=i; <EM>might</EM> give you some more info.</LI><LI>Metadata server log, holds authentication info</LI><LI>Even the Object Spawner log might give some clues</LI></UL></BODY></HTML> Fri, 20 Mar 2015 09:56:12 GMT LinusH 2015-03-20T09:56:12Z Setting up multiple database connections for use in Data Integration Studio https://communities.sas.com/t5/SAS-Programming/Setting-up-multiple-database-connections-for-use-in-Data/m-p/206544#M267161 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am having issues having 2 oracle database connections running concurrently in Data Integration Studio.</P><P></P><P>I had an existing odbc, user group and library for database 1. All worked fine.</P><P></P><P>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. </P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">I have 2 jobs in DI, one referring database 1 the other database 2.</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">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.</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">So it appears to be the username and password associated with the first user group created that is maintained. </SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Am i missing a link somewhere? Is it possible to have jobs looking at multiple schemas?</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Where can I locate the log files for DI?<BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Thanks.<BR /></SPAN></P></BODY></HTML> Fri, 20 Mar 2015 08:29:42 GMT https://communities.sas.com/t5/SAS-Programming/Setting-up-multiple-database-connections-for-use-in-Data/m-p/206544#M267161 prenderj 2015-03-20T08:29:42Z Re: Setting up multiple database connections for use in Data Integration Studio https://communities.sas.com/t5/SAS-Programming/Setting-up-multiple-database-connections-for-use-in-Data/m-p/206545#M267162 <HTML><HEAD></HEAD><BODY><P>This is tricky stuff to trouble shoot, especially via a forum.</P><P>It should work...</P><P>So where do you store the userid/psw? In the user group account (I hope)?</P><P>Do you use AUTHDOMAIN= in your library definition?</P><P></P><P>Logs, it not always obvious which log to look in:</P><UL><LI>The DI Studio Log of course. Adding options sastrace=',,,d' sastraceloc=saslog nostsuffix msglevel=i; <EM>might</EM> give you some more info.</LI><LI>Metadata server log, holds authentication info</LI><LI>Even the Object Spawner log might give some clues</LI></UL></BODY></HTML> Fri, 20 Mar 2015 09:56:12 GMT https://communities.sas.com/t5/SAS-Programming/Setting-up-multiple-database-connections-for-use-in-Data/m-p/206545#M267162 LinusH 2015-03-20T09:56:12Z