To create a relational source definition, use the Source Analyzer to import source metadata. In regard to your configuration, you need to have the following: Enter a database user name and password to connect to the database. Turn on more accessible mode. Turn on more accessible mode. Skip to main content.

Uploader: Tarisar
Date Added: 19 December 2008
File Size: 52.74 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 69221
Price: Free* [*Free Regsitration Required]

I have the same question Show 0 Likes 0. You can hold down the Shift key to select a block of sources within one folder or hold down the Ctrl key to make non-consecutive selections within a folder.

Signing in to Informatica Network

If no table names appear, or if the table you want to import infrmatica not appear, click All. The setup was rather simple. Please enable scripts and reload this page.

This content has been marked as final. Edit the existing odbc. This tool uses JavaScript and much of it will not work correctly without it enabled. Select the new ODBC data source.


Configuring MYSQL connection for Source

You will also find over mapping samples and many other useful tools on the same website. It seems to be mjsql settings are already id there. Glad to have been of some help. In Workflow Manager add a relational connection.

Informatica Network Knowledge Base. You may need to specify the owner name for database objects you want to use as sources.

It is configured perfectly. Informatica Network Knowledge Base. I didnt get exactly.

Please enter your message and try again. Thanks for the information.

unixODBC Driver Manager

The driver name and location depends on the version of DataDirect ODBC drivers being informatifa, the operating system they are installed on and the directory they are installed in. While importing in Designer by following the sreeman. Skip to main content. Toggle navigation Network Home Informatica.

Installing JDBC and ODBC Drivers for MySQL Conn

I got this error. Did this KB document help you?


Feedback Did this KB document help you? This content has been marked as final. First of all, you need to create an ODBC connection on your server. You don’t have JavaScript enabled.

Need an exepert help who know this connection very well. Please enter a title. I can even contact you by phone if you dont mine. Hi, i’m new to PowerCenter and i got a requirement where i should connect to a database MySql from powercenter. Please turn JavaScript back on and reload this page. We placed the connection entry in OBBC.