using ADF to extract Dynamics 365 data

  • Hello, we a migrating from on premises CRM to cloud D365 and need to ETL data into on-premises sql server/data warehouse.

    I have come across 2 options...

    1. KingswaySoft SSIS Integration Toolkit for Microsoft Dynamics 365 / SSIS Productivity Pack
    2. Azure Data Factory.

    We are a company that uses Microsoft products and services and already have AAD, Power BI and would like continue using MS over third party tools.

    Looking for advice / things to consider when opting for ADF

    • Cost / licensing
    • How ADF connects with D365 and On-Prem SQL Server
    • Anything else to consider

    Thank you

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • Go with Kingsway.  It works very well.  Been there, done that.

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:

  • I can't say anything about kingsoft, but can comment that ADF is absolutely horrible. If you are doing the transforms in something else like DBT, ADF is fine for orchestration but otherwise I wouldn't touch it with a 10 foot pole.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply