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.

Have more questions? Submit a request

0 Comments

Article is closed for comments.