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.
CONNECTION to ORACLE from DataStage AIX 7.5
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That drop-down list is a little "buggy" and won't always show you the tnsname entries correctly, especially if you maintain them by hand.
Simple solution is to type the tnsname you want to use, there's no need to actually pick it from the list.
Simple solution is to type the tnsname you want to use, there's no need to actually pick it from the list.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Thanks Craig... Works perfectly fine as you said.
Thanks for the quick response Craig... Works perfectly fine as you said.