Conection Problem Oracle Windows 7

More
11 years 3 months ago #5233 by unifscm
I am using the Enterprise ETL Processor in Windows 7, version 5.3.1.2.
When I use the Oracle connections, configure and test set, works well. (Attachment 1).
At the time that you want to exchange data, either as a package or as a repository using Oracle gives the following error (Attachment 2).
The same configuration of ETL Installed in Windows XP, it works without problems.
As temporary solution I connect to Oracle via ODBC and everything works fine.
The problem is that I need to use Direct Path Loading to upload the data to Oracle using ODBC and I have no such option, then it takes too long to upload the information.

Thank you for your help.
regards,
Jorge
Attachments:

Please Log in or Create an account to join the conversation.

More
11 years 3 months ago #5234 by admin
You have to install Oracle Ole db provider from oracle.

(BTW There is a note in the documentation about that)

Also make sure that you patched Oracle client to the latest version related to the database version.

Eg if you work with oracle 10 patch it to the latest version of oracle 10

John

Mike
ETL Architect

Please Log in or Create an account to join the conversation.