Oct 30, 2017 - Xrm.Sdk.Client; namespace Microsoft.Crm.Sdk.Samples { /// /// This sample shows how to define an import. EntityLogicalName, // Relate this column mapping with the data map ImportMapId = new EntityReference(ImportMap. Schemas used in Dynamics 365 Customization XML reference.

Connecting to Microsoft Dynamics CRM The Sisense Microsoft Dynamics CRM connector is a standalone connector that allows you to import data from Microsoft Dynamics CRM’s API into the ElastiCube Manager. After you have downloaded and installed the connector, you can connect through a connection string you provide Sisense in the ElastiCube Manager. The connection string is used to authenticate users who connect to the Microsoft Dynamics CRM tables. To obtain a connection string, you will need to obtain your credentials from Microsoft Dynamics CRM. Once you have connected to Microsoft Dynamics CRM, you can import a variety of tables from the Microsoft Dynamics CRM API. This page describes how to install the Microsoft Dynamics CRM connector, how to connect to Microsoft Dynamics CRM with a connection string, and what tables you can import into the ElastiCube Manager: • • • • Installing the Microsoft Dynamics CRM Connector Sisense provides the Microsoft Dynamics CRM connector as a standalone connector that you can download and add to your list of default Sisense connectors. To install the Microsoft Dynamics CRM connector: • the Microsoft Dynamics CRM installation file.

• Open the installation file and click Install. • After the installation process is complete, click Close. The Microsoft Dynamics CRM connector is displayed in the ElastiCube Manager under Add Data > Web Services.

Connecting to the Microsoft Dynamics CRM The connection string used to connect to the Microsoft Dynamics CRM connects to various instances you have in the Microsoft Dynamics CRM. By providing your Microsoft Dynamics CRM credentials as values in the connection string, you can add Microsoft Dynamic CRM tables to the ElastiCube. Adding Microsoft Dynamics CRM Tables to your ElastiCube Sisense uses connection strings to connect to Microsoft Dynamics CRM and import data into the ElastiCube Manager. The connection string to connect to Microsoft Dynamics CRM has the following structure: jdbc:dynamicscrm:Property1=Value1;Property2=Value2; The following is an example of a Microsoft Dynamics CRM connection string: jdbc:dynamicscrm:User=xxxxxxxxxx;Password=xxxxxxxxxx;URL=Online Office 365; 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.

Note: To switch between accounts, you need to delete the file OAuthsettings.txt file located at Users xxx AppData Roaming CData Microsoft Dynamics CRM Data Provider or you can add OAuthSettingsLocation to the connection string. See Switching between Accounts for more information. If you have any issues connecting to your data source, see. To add Microsoft Dynamics CRM data: • In ElastiCube Manager, click Add Data and then, Microsoft Dynamics CRM. The Connect to Microsoft Dynamics CRM window is displayed. • In Datasource Connection String, enter your connection string. • Click Connect to Server.