Data Source Name (DSN) Configuration
The CData ODBC Driver for Dynamics CRM 2015 can be configured using the ODBC Data Source Administrator. Once the driver is installed, you will see the CData Dynamics CRM and the CData Dynamics CRM x64 data source names listed under the User DSN tab of the ODBC Data Source Administrator. Select a DSN and click the Configure button to set connection properties in the driver configuration window (shown below).
The connection string options for the driver meet the authentication and connection requirements of different Dynamics CRM instances. To connect to your instance, set the User and Password properties, under the Authentication section, to valid Dynamics CRM user credentials and set the Url to a valid Dynamics CRM server organization root. Additionally, set the CRMVersion property: Supported versions are CRM Online Office 365, CRM 4.0, CRM 2011, CRM 2013, CRM 2015. IFD configurations are supported as well.
Additionally, you can provide the security token service (STS) or AD FS endpoint in the STSURL property. Office 365 users can connect to the default STS URL by simply setting CRMVersion.