Microsoft Dynamics CRM to Database

In this ETL example we will create a Data Interface to extract Accounts data from Microsoft Dynamics CRM and load it into a Database. 

Refer to the attached video on the steps involved in setting up data integration between a source and target application.

The JDBC URL in the DB Info activity to configure the Microsoft Dynamics CRM connection uses the following format:

 jdbc:dynamicscrm:User=myuseraccount;Password=mypassword;URL=myOrg.crm.dynamics.com/;CRM Version=CRM Online;

Microsoft Dynamics CRM Driver is already bundled with the product.  Select this driver from the Database Driver drop-down list as shown in the video.