Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is there a connector I can download for connecting to Dynamics CRM from SS Integration Services?
Solved! Go to Solution.
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
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.
@hxkresl wrote:
Is there a connector I can download for connecting to Dynamics CRM from SS Integration Services?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |