CONNECTION to ORACLE from DataStage AIX 7.5
Posted: Tue Sep 20, 2005 5:23 pm
Hi All,
This question is regarding using Oracle native connection and importing the table defination using "Plug in metadate defination" from the manager.
We added a new entry in tnsnames.ora file and tested if the connection is working fine( by running the job using the new entry), and its does work fine. But the problem is that when we want to import the table definations using the "Plug in metadate definations " from the manager, we don't see the new entry in the drop down box. Although, we see most of the entries which are in tnsnames.ora file, few of them are missing. I'm not sure if thr are some scripts which we have to run before we can see them from the import table definations option.
Any help on where to look at or the actual solution is greatly appreciated
Thanks.
This question is regarding using Oracle native connection and importing the table defination using "Plug in metadate defination" from the manager.
We added a new entry in tnsnames.ora file and tested if the connection is working fine( by running the job using the new entry), and its does work fine. But the problem is that when we want to import the table definations using the "Plug in metadate definations " from the manager, we don't see the new entry in the drop down box. Although, we see most of the entries which are in tnsnames.ora file, few of them are missing. I'm not sure if thr are some scripts which we have to run before we can see them from the import table definations option.
Any help on where to look at or the actual solution is greatly appreciated
Thanks.