MDM Import Manager - Oracle Client Issues

[Former Member]

Hello,

I'm trying to use the import manager to retrieve data from an oracle database. The issue I have is that i'm unable to establish a connection. As I have multiple oracle client versions installed on my PC, i was wondering what determines which client MDM will be using ? This does not seem to be configurable nor specified in any MDM-ini file. I assume that some settings are used from the windows registry, but not sure which. Any ideas?

[former_member278106 · Accepted solution]

Hi Dirk,

The registry string is: HKLM\Software\Oracle\ALL_HOMES\DEFAULT_HOME.

Additionally: system and/or user environment variable Path should include C:\oracle\ora92\bin, if your default client is ora92.

Regards, Lev