Connecting Informatica PowerCenter to Dynamics 365 Business Central via ODBC Driver

You can connect Informatica PowerCenter to Dynamics 365 Business Central through an ODBC driver on Windows to unify and manage data across these systems.

Prerequisites

• Configure the Informatica services.
• Install the PowerCenter Client tools.
• Create a repository folder in PowerCenter Repository Manager.
• Install Devart ODBC Driver for Dynamics 365 Business Central. For instructions, see Installation.
• Configure a data source name (DSN). For instructions, see Windows DSN Configuration.

Add a data source in Informatica PowerCenter

Before you proceed, make sure PowerCenter Designer isn't running.

1. Open the C:\Informatica\10.4.1\clients\PowerCenterClient\client\bin\powrmart.ini file in a text editor.
2. In the [ODBCDLL] section, add Dynamics 365 Business Central=EXTODBC.DLL, then save the changes.
3. Open PowerCenter Designer.
4. Double-click the repository name (in this example, PCRS), enter your Informatica credentials, then click Connect.

5. Double-click the repository folder (in this example, ODBC connections), then select Sources > Import from Database.
   
   The Import Tables dialog opens.
6. From the ODBC data source menu, select the needed DSN.
7. In the Username and Password fields, enter your Dynamics 365 Business Central credentials.
8. Under Show owners, select All.
9. Click Connect.

10. In the Select tables section, expand the tree and select the tables you want to import.
11. Click OK.

The table schemas appear in the Source Analyzer, and the data source is added to the Sources subfolder of the repository folder. You can now create mappings and work with Dynamics 365 Business Central data in Informatica PowerCenter.