locked
SSIS Odata Source with CRM dynamics online RRS feed

  • Question

  • Hi,

    Does anyone know when the SSIS Odata source will be updated to work with SQL server 2017 and 2019 and With CRM version 9.1?

    There are a number of issues that make the SSIS odata useless when loading CRM data.

    1. Odata does not support multi picklist which were introduced with CRM 9.0?

    2. When you use any combination of CRM 9.0 or later and SQL server 2017 or later neither the preview nor the loading works. The error mostly revolves around unexpected data types with Date/Datetime.  If you use Sql server 2016 or later with CRM version 8.1 you can preview and load data, but as soon as you change to 9.1 in the Odata connection string, everything starts failing.

    Thanks

    Scott

    Wednesday, October 23, 2019 9:35 AM

All replies

  • Just another note.  The CRM Dynamics connector in ADF linked services cannot see certain columns and thus you can not load data from those columns, but using the Odata connector in PowerBI can see more columns with data. Why are the Odata connectors for SSIS, PowerBI and ADF not aligned and work the same for an out of box Microsoft product - CRM Dynamics?
    Wednesday, October 23, 2019 9:41 AM
  • Hi Dakotakeith,

    There is no good solution so far, maybe you can go to this website to make some comments.

    Check SQL Server.

    Regards,

    Zoe



    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Thursday, October 24, 2019 6:12 AM
  • Hi Scott,

    I would recommend you check the commercial COZYROC Dynamics CRM adapters. They will work properly for you.


    SSIS Tasks Components Scripts Services | http://wwww.cozyroc.com/

    Thursday, October 24, 2019 12:32 PM