Fundamental query in Datastage

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
nishant_ds
Participant
Posts: 2
Joined: Wed Sep 07, 2011 6:31 am

Fundamental query in Datastage

Post 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
Nishant Mathur
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post 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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply