Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
hxkresl
Helper V
Helper V

Dynamics CRM connector for SSIS?

Is there a connector I can download for connecting to Dynamics CRM from SS Integration Services?

 

 

1 ACCEPTED SOLUTION
nageshkumarapp
Regular Visitor

If you just want to read the data then you can connect through standard SQL client in SSIS but only connect to the filteredviews.

If you want to to CRM operation like Create/Update/Delete then either you can write SDK code in Script Task or use 3rd part tool like Kingswaysoft or Cozyroc - but these will require additional license.

If you choose to write Script Component then u can refer this : mscrunch.azurewebsites.net/.../setting-up-ssis-script-component-for-crm-connection

For CozyRoc: www.cozyroc.com/.../dynamics-crm-destination

For Kingswaysoft: www.kingswaysoft.com/.../download

Thanks,

Nagesh Kumar

View solution in original post

3 REPLIES 3
nageshkumarapp
Regular Visitor

If you just want to read the data then you can connect through standard SQL client in SSIS but only connect to the filteredviews.

If you want to to CRM operation like Create/Update/Delete then either you can write SDK code in Script Task or use 3rd part tool like Kingswaysoft or Cozyroc - but these will require additional license.

If you choose to write Script Component then u can refer this : mscrunch.azurewebsites.net/.../setting-up-ssis-script-component-for-crm-connection

For CozyRoc: www.cozyroc.com/.../dynamics-crm-destination

For Kingswaysoft: www.kingswaysoft.com/.../download

Thanks,

Nagesh Kumar

Thank you for reply. Since have rolled off project, and am unable to test the script component instructions with username/password, I will refer to this next time.

Eric_Zhang
Microsoft Employee
Microsoft Employee


@hxkresl wrote:

Is there a connector I can download for connecting to Dynamics CRM from SS Integration Services?

 

 


@hxkresl

AFAIK, there's no built-in connector in SSIS for CRM. You'll have to retrieve the data by calling the CRM application API in a script task/component or rely on some other commercial 3rd party connectors.

 

By the way since SSIS is out of the topic of this forum, for better response, I'd suggest you post in the dedicated SSIS forum.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.