I have an Oracle database installed on my local system (64 bit) and am trying to use Informatica as an ETL tool.
My problem is that my database is working fine (I am able to connect to it via SQL*Plus and all and run queries), also I was able to configure a domain for Informatica, but I am not able to import sources from my database as I am not able to configure System DSN for my installed database.
The entry that's supposed to show (Oracle in
Oradb11g_home1) doesn't show up.
However I was able to find it when I tried to configure it through my system's ODBC options. It just isn't available in the Informatica ODBC options.
Any idea how to configure this?