ETL with CRM Dynamics 365 in azure

0
votes

We have CRM Dynamics 2015 onsite. The CRM Developer provided us with a proxy we can connect to to insert and extract data to/from CRM, which we connect to via SSIS script component to extract data from this for downstream systems and data warehouses.

There are plans to migrate to Dynamics 365 SAAS. I want to be sure that we have a plan for how to continue inserting/extracting data via ETL into Dynamics 365.

Besides running SSIS in an Azure VM, are there any services or alternatives within Azure that might be a better option for ETL with Dynamics 365?

1
ssisazure-sql-databasemicrosoft-dynamicsdynamics-365
You can have Scribe in Azure VM, Did you explore? – Arun Vinoth - MVP
How does your Proxy Connect to Dynamics CRM? If it use Standard Dynamics API you can leave your ETL Process on Premise. – SGeis

1 Answers

0
votes

Depending on which api your on prem tool is using you could just change the connection string to point to CRM Online. If that doesn't work either use scribe or use Kingswaysoft's SSIS tools to provide that integration.