Hello all, im new to informatica and i want to load data from oracle DB to Mysql DB. the probleme is : when i try to create a relationnal connection to MySQL DB, it dose'nt work.
here it is the log :
INFO 13/03/2012 11:04:50 Reader: Source IS [C182CFR], user [user12] INFO 13/03/2012 11:04:50 Source DATABASE connection [oracle_S] code page: [MS Windows Latin 1 (ANSI), superset of Latin1] INFO 13/03/2012 11:04:51 Initialization completed successfully. INFO 13/03/2012 11:04:51 Writer: Target IS DATABASE [localhost], user [root], bulk mode [N/A] ERROR 13/03/2012 11:04:51 Error connecting TO DATABASE... WRT_8001 [Session s_session_MySQL Username root DB Error -1805 [DataDirect][ODBC lib] DATA source name NOT found AND no DEFAULT driver specified DATABASE driver error... FUNCTION Name : Connect DATABASE driver error... FUNCTION Name : Connect DATABASE Error: Failed TO connect TO DATABASE USING user [root] AND connection string [localhost].]
have you any solution please.
You should test your ODBC connection outside the PowerCenter Workflow / session first. Why don't you try following free Utility from Informatica and see if that helps?
In addition to this, you will also find many other useful Informatica tools and over 100 mapping samples on Informatica Marketplace website.