accessing a Oracle Database on a differnet server

[Pavan_Yelugula]

hi all
we are trying to access a oracle database loaded on a different unix box.
we have our datastage on a differnt server and oracle database on a different database.

Any pointers how this can be done

Thanx and Regards
Pavan

[davidnemirovsky]

Install the Oracle Client on the Datastage server.

Make sure your "tnsnames.ora" file on the Datastage server has the entry for the Oracle Database on the Oracle DB Server.

[Amos.Rosmarin]

Make sure you can connect ot the desired database from the etl server with sqlplus.
If so there is no reason datastage will not connect.

[Pavan_Yelugula]

we are able to get through with sqlplus.should we be changing something to import the table definitions in datastage manager.

[davidnemirovsky]

You should be using the exact same credentials as you've used for SQL Plus.

Make sure you're using the correct 'Plug-in Metadata Definitions' in the Manager ie. Ora8i for Oracle8i, Ora9i for Oracle9i etc.