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.