I am trying to get data from a remote Oracle database and insert it in my local Oracle database. I have created a job with an Oracle Enterprise stage and have selected the Remote Server variable. Now I need to tell Datastage how to access the data so it will need the server name, port and SID for the remote server.
What format should this be in?
Correct format for Remote Server string in Oracle Enterprise
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It would not have made any difference. It's Oracle that needs the entry in tnsnames.ora. If you, as a DataStage developer, had such a GUI, you would still not have permission to put it in to tnsnames.ora where Oracle insists on it being.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.