Skip navigation
Contact Us
10358 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)




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




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.



More Like This

  • Retrieving data ...

Bookmarked By (0)


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