connecting to database by NT Id
Posted: Sat Mar 20, 2010 11:06 pm
Hi All,
Below is the issue:
1) There is a database on SQL server which has access to windows NT id and not to DataStage admin id.
2) Created a DSN with DataStage admin id (as windows NT id does not have access to create DSN) on DataStage server to connect to the above database.
3) Created a simple job with ODBC stage as source and another ODBC as destination(some other database having all the access to all the id's).
3) If we run this job with above DSN in source with windows NT id (used to log in to DataStage) will it work?
4) If we run this job with above DSN in source with DataStage admin id will it work?
5) Is there some other way to fetch the data from above database without getting access to DataStage admin id?
Below is the issue:
1) There is a database on SQL server which has access to windows NT id and not to DataStage admin id.
2) Created a DSN with DataStage admin id (as windows NT id does not have access to create DSN) on DataStage server to connect to the above database.
3) Created a simple job with ODBC stage as source and another ODBC as destination(some other database having all the access to all the id's).
3) If we run this job with above DSN in source with windows NT id (used to log in to DataStage) will it work?
4) If we run this job with above DSN in source with DataStage admin id will it work?
5) Is there some other way to fetch the data from above database without getting access to DataStage admin id?