Post reply

using ADF to extract Dynamics 365 data

  • July 25, 2023 at 1:19 pm

    #4244120

    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

  • July 26, 2023 at 2:10 pm

    #4245115

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

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

  • July 27, 2023 at 2:12 pm

    #4246022

    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:
    http://www.sqlservercentral.com/articles/61537/

  • August 21, 2023 at 4:48 pm

    #4267312

    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