How to Create ODBC Connection for Oracle with Informatica

preview_player
Показать описание
ODBC connection creation between Oracle and Informatica
Рекомендации по теме
Комментарии
Автор

Hi Adam
I am running informatica 10.1 on windows 10 pro. I have oracle 12c. Mine is 64 bit machine,
Problem is I am trying to import oracle data source in the Powercenter designer.
1. I am not able to see Oracle OraDB12Home 1 connection in 32 bit ODBC Admin ( I guess that's because oracle client I installed is 64 bit. ) But I think informatica can take only 32 bit drivers.
2. I also tried creating DataDirect Oracle wire protocol, but its giving me invalid user name password error where I am able to connect hr/hr SQL plus or SQL Developer
Any thoughts?

vanny
Автор

where i find the user and password because I try with System user and doesnt found!!

sergioesteban