Dynamics CRM Connection Manager
 PreviousNext

SSIS Dynamics CRM Connection Manager can be used with Dynamics CRM Source, Dynamics CRM Destination, to read/write Microsoft Dynamics CRM data.

Download SSIS PowerPack

Content

Video Tutorial

Coming soon...

Step-By-Step

In this tutorial we will learn how to create Dynamic CRM Connection. You can create multiple connection(Used with Dynamics CRM Source, Dynamics CRM Destination).
  1. In order to connect to DynamicsCRM Storage from SSIS you will need Credentials. You can create account click here. and get credentials.
  2. Now, You need to Download and Install SSIS ZappySys PowerPack.
  3. Once you finished above steps, Open Visual Studio and Create New SSIS Package Project.
  4. Right click in the Connection Manager panel and click on New Connection.
    SSIS Create New Connection
  5. Select ZS-DYNAMICS-CRM Connection Manager from the Connection Managers list and Click on Add Button.
    SSIS DynamicsCRM Connection Manager - ADD
  6. In the connection manager UI, set Authentication type to CRM Online (Office 365), enter user name and password. Select organization.
    SSIS Dynamics CRM Connection Manager UI (Used with Dynamics CRM Source, Dynamics CRM Destination)
  7. Click on Test Connection to check configure correct or not.
  8. Click on OK button to save DynamicsCRM Connection Manager configure setting UI.
  9. Once you finished, you will see DynamicsCRM connection in Connection Manager panel.
    SSIS DynamicsCRM Connection Manager - Success

Properties

Property Name Description
OrganizationId Prefix for Service Url
ServiceUrl Organization Service Url
DiscoveryUrl
Timeout Request timeout in seconds
UserName
Password
ConnectionString
UseProxy Enable custom proxy settings (If this is not set then system default proxy will be used. To disable proxy totally uncheck this option and check DoNotUseDefaultProxy option if available)
ProxyUrl Web URL of Proxy server (including port  if necessary). [e.g. http://myproxyserver:8080/]
DoNotUseDefaultProxy Do not use system default proxy (This setting is ignored if UseProxy=true)
ProxyUseCreds Enable passing userid and password to proxy server
ProxyPassword Proxy password
ProxyUserName Proxy username

Setting UI

SSIS DynamicsCRM Connection - Setting UI

See Also

References

Copyrights reserved. ZappySys LLC.