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)
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.
ok as a temporary approach we shall be installing the oracle client on the informatica server machine to get the oracle drivers.
Similarly , incase we might use a teradata source ,we shall be installing teradata on server machine for it's respective drivers.
The question though , still remains open.
****Correct Answer**-- make a system DSN connection on the server machine. At the client machine make an ODBC connection and the connection string will be the system DSN Datadirect connection made at the server machine side. No need to install the oracle client software.