Page 1 of 1

Fundamental query in Datastage

Posted: Wed Sep 07, 2011 6:57 am
by nishant_ds
Hi folks,
While creating a connection string with domain before carrying out ETL in datastage,system DSN is selected.Why?
In the contrary,User DSN is selected in case of INFORMATICA.
I came to know about the software structure of datastage as follows:

DS2 server or Oracle server
Websphere server
IBM Information server
Datastage client
..Designer
..Administrator
...Director

A person working as developer does not have access to upper servers.Why?

Thanks and regards

Posted: Wed Sep 07, 2011 5:09 pm
by ray.wurlod
Welcome aboard. The short answer is that NO-ONE has access to the metadata repository or services tier. Everything is done through the services exposed by the WebSphere Application Server. The only time these "upper levels" are accessed is during installation. Information Server is implemented using a service-oriented architecture. Even a person working as an administrator works through the services.