Skip navigation
Contact Us
3918 Views 1 Reply Latest reply: Nov 29, 2012 2:34 AM by Joe . RSS
Joe . Novice 21 posts since
Nov 20, 2012
Currently Being Moderated

Nov 22, 2012 10:56 PM

Informatica connectivity using ODBC Drivers without installation of oracle client.

Dear All,

 

I want to make an ODBC connection and use want Informatica to use the same. The only restriction is that I do not want to install oracle client as it is bulky (as I cannot expect the all end users to install oracle client for the ODBC driver)

 

Approach:

 

Designer>Source Analyzer>Sources>Import from databases>select odbc data source>Datadirect 5.2 oracle wire protocol

 

The same can be accessed by running the odbcad32.exe file in the system32

 

I'm getting a system error 126 as the following driver is searched for

 

C:\Informatica\9.1.0\clients\tools\ODBC6.1\dwora25.dll

 

and the informatica client installation at my system does not have the ODBC6.1 created.

 

(the above path is defined at registery for HKEY_LOCAL_MACHINE>SOFTWARE>ODBC>ODBCINST.INI>Datadirect 6.1 Oracle Wire Protocol...driver and setup)

 

 

Problem Statement:

 

How do I install ODBC driver for Informatica.

 

The Informatica client and Informatica servers are on different machines. In either case I do not want to install the entire oracle client s/w , I need only the drivers,

 

 

Please help answering the same.

Regards,

Joe.

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points