## Overview

The Lyftron Provider for Dynamics CRM offers the most natural way to access Dynamics CRM data from Lyftron with ease and also enables to connect with BI, MDM & ML tools, Data warehouses, Databases and other SAAS based applications with zero code and zero infrastructure requirements. The provider wraps the complexity of accessing Dynamics CRM data into easy-to-integrate relational fully managed ANSI Sql format. Make faster and better business decisions with Lyftron’s Dynamics CRM data provider and automatically build your data migration pipelines in minutes, not months

The provider hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.

## Key Features

- Comprehensive Delta load mechanism.
- Real-time access to Dynamics CRM.
- Comprehensive full support of ANSI Sql to query data with ease.
- Collaborative query processing.

## Prerequisites

The user must have credentials for Dynamics CRM, Lyftron and your destination data warehouse, lake or database to perform the data pipeline operation with Lyftron

## Establishing a Connection with Lyftron's Quickstart Steps

Create your Dynamics CRM connection with Lyftron by following the 5 easy steps show below:

## Step1. Add your connection

Click on **Connect** section on the left panel → Click on **Add Connection** button

## Step2. Select your connector

In the connector selection panel, search and click **Dynamics CRM** for your connection

## Step3. Enter your connection details

In the **Connection String** section enter the values of the below parameters. The following connection string is required to establish Dynamics CRM connection with Lyftron.

Key |
Value |
Field |

Connection Name | Enter your connection details | Required |

User | Your Dynamics CRM user account | Required |

Password | Your Dynamics CRM password | Required |

URL | Your Company Dynamics CRM URL | Required |

CRM Version | CRM Online | Required |

Logfile** | Use the logfile option to debug your job and provide your connection name to generate the log file. [ConnectionConfigurationPath]\Connection_name_log.tx | Optional |

Verbosity** | Choose verbosity 1-5 based on the severity of debugging | Optional |

**** **For more information, check the

**Lyftron logging and debugging**

**section**

**.**

If you want more detailed information about how to establish a connection with Lyftron, click on** **Lyftron Connection Quick Start guide.

## Step4. Test your connection

Once you are done entering your connection details, simply click on the Test Connection button to test the connectivity. In case your connection fails, add **Logfile** and **Verbosity** parameters and check the Lyftron logging and debugging section, to debug the error.

## Step5. Save your connection

Hurray! Now you have successfully connected with the Lyftron Dynamics CRM connector and can utilize the connector to Extract, Warehouse, Analyze, Visualize** **and** **Share your data.

## Data Model

The provider models the data in Dynamics CRM into a list of tables that can be queried using standard SQL statements.

Generally, querying Dynamics CRM tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns.

Name |
Type |
Description |

Account | Tables | Create, update, delete, and query Account entities in Dynamics CRM. |

ActivityMimeAttachment | Tables | Create, update, delete, and query ActivityMimeAttachment entities in Dynamics CRM. |

ActivityParty | Tables | Create, update, delete, and query ActivityParty entities in Dynamics CRM. |

ActivityPointer | Tables | Create, update, delete, and query ActivityPointer entities in Dynamics CRM. |

Annotation | Tables | Create, update, delete, and query Annotation entities in Dynamics CRM. |

AnnualFiscalCalendar | Tables | Create, update, delete, and query annual fiscal calendar entities in Dynamics CRM. |

ApplicationFile | Tables | Create, update, delete, and query ApplicationFile entities in Dynamics CRM. |

Appointment | Tables | Create, update, delete, and query Appointment entities in Dynamics CRM. |

AsyncOperation | Tables | Create, update, delete, and query AsyncOperation entities in Dynamics CRM. |

Attachment | Tables | Create, update, delete, and query Attachment entities in Dynamics CRM. |

AttributeMap | Tables | Create, update, delete, and query AttributeMap entities in Dynamics CRM. |

Audit | Tables | Create, update, delete, and query Audit entities in Dynamics CRM. |

BulkDeleteFailure | Tables | Create, update, delete, and query BulkDeleteFailure entities in Dynamics CRM. |

BulkDeleteOperation | Tables | Create, update, delete, and query BulkDeleteOperation entities in Dynamics CRM. |

BulkOperation | Tables | Create, update, delete, and query BulkOperation entities in Dynamics CRM. |

BulkOperationLog | Tables | This is a table representing the BulkOperationLog entities in Dynamics CRM. |

BusinessUnit | Tables | This is a table representing the BusinessUnit entities in Dynamics CRM. |

BusinessUnitMap | Tables | This is a table representing the BusinessUnitMap entities in Dynamics CRM. |

BusinessUnitNewsArticle | Tables | This is a table representing the BusinessUnitNewsArticle entities in Dynamics CRM. |

Calendar | Tables | This is a table representing the Calendar entities in Dynamics CRM. |

CalendarRule | Tables | This is a table representing the CalendarRule entities in Dynamics CRM. |

Campaign | Tables | This is a table representing the Campaign entities in Dynamics CRM. |

CampaignActivity | Tables | This is a table representing the CampaignActivity entities in Dynamics CRM. |

CampaignActivityItem | Tables | This is a table representing the CampaignActivityItem entities in Dynamics CRM. |

CampaignItem | Tables | This is a table representing the CampaignItem entities in Dynamics CRM. |

CampaignResponse | Tables | This is a table representing the CampaignResponse entities in Dynamics CRM. |

ClientUpdate | Tables | This is a table representing the ClientUpdate entities in Dynamics CRM. |

ColumnMapping | Tables | This is a table representing the ColumnMapping entities in Dynamics CRM. |

Commitment | Tables | This is a table representing the Commitment entities in Dynamics CRM. |

Competitor | Tables | This is a table representing the Competitor entities in Dynamics CRM. |

CompetitorAddress | Tables | This is a table representing the CompetitorAddress entities in Dynamics CRM. |

CompetitorProduct | Tables | This is a table representing the CompetitorProduct entities in Dynamics CRM. |

CompetitorSalesLiterature | Tables | This is a table representing the CompetitorSalesLiterature entities in Dynamics CRM. |

Connection | Tables | This is a table representing the Connection entities in Dynamics CRM. |

ConnectionRole | Tables | This is a table representing the ConnectionRole entities in Dynamics CRM. |

ConnectionRoleAssociation | Tables | This is a table representing the ConnectionRoleAssociation entities in Dynamics CRM. |

ConnectionRoleObjectTypeCode | Tables | This is a table representing the ConnectionRoleObjectTypeCode entities in Dynamics CRM. |

ConstraintBasedGroup | Tables | This is a table representing the ConstraintBasedGroup entities in Dynamics CRM. |

Contact | Tables | This is a table representing the Contact entities in Dynamics CRM. |

ContactInvoices | Tables | This is a table representing the ContactInvoices entities in Dynamics CRM. |

ContactLeads | Tables | This is a table representing the ContactLeads entities in Dynamics CRM. |

ContactOrders | Tables | This is a table representing the ContactOrders entities in Dynamics CRM. |

ContactQuotes | Tables | This is a table representing the ContactQuotes entities in Dynamics CRM. |

Contract | Tables | This is a table representing the Contract entities in Dynamics CRM. |

ContractDetail | Tables | This is a table representing the ContractDetail entities in Dynamics CRM. |

ContractTemplate | Tables | This is a table representing the ContractTemplate entities in Dynamics CRM. |

CustomerAddress | Tables | This is a table representing the CustomerAddress entities in Dynamics CRM. |

CustomerOpportunityRole | Tables | This is a table representing the CustomerOpportunityRole entities in Dynamics CRM. |

CustomerRelationship | Tables | This is a table representing the CustomerRelationship entities in Dynamics CRM. |

Dependency | Tables | This is a table representing the Dependency entities in Dynamics CRM. |

DependencyNode | Tables | This is a table representing the DependencyNode entities in Dynamics CRM. |

Discount | Tables | This is a table representing the Discount entities in Dynamics CRM. |

DiscountType | Tables | This is a table representing the DiscountType entities in Dynamics CRM. |

DisplayString | Tables | This is a table representing the DisplayString entities in Dynamics CRM. |

DisplayStringMap | Tables | This is a table representing the DisplayStringMap entities in Dynamics CRM. |

DocumentIndex | Tables | This is a table representing the DocumentIndex entities in Dynamics CRM. |

DuplicateRecord | Tables | This is a table representing the DuplicateRecord entities in Dynamics CRM. |

DuplicateRule | Tables | This is a table representing the DuplicateRule entities in Dynamics CRM. |

DuplicateRuleCondition | Tables | This is a table representing the DuplicateRuleCondition entities in Dynamics CRM. |

Tables | This is a table representing the Email entities in Dynamics CRM. | |

EmailHash | Tables | This is a table representing the EmailHash entities in Dynamics CRM. |

EmailSearch | Tables | This is a table representing the EmailSearch entities in Dynamics CRM. |

EntityMap | Tables | This is a table representing the EntityMap entities in Dynamics CRM. |

Equipment | Tables | This is a table representing the Equipment entities in Dynamics CRM. |

Fax | Tables | This is a table representing the Fax entities in Dynamics CRM. |

FieldPermission | Tables | This is a table representing the FieldPermission entities in Dynamics CRM. |

FieldSecurityProfile | Tables | This is a table representing the FieldSecurityProfile entities in Dynamics CRM. |

FilterTemplate | Tables | This is a table representing the FilterTemplate entities in Dynamics CRM. |

FixedMonthlyFiscalCalendar | Tables | This is a table representing the FixedMonthlyFiscalCalendar entities in Dynamics CRM. |

Goal | Tables | This is a table representing the Goal entities in Dynamics CRM. |

GoalRollupQuery | Tables | This is a table representing the GoalRollupQuery entities in Dynamics CRM. |

Import | Tables | This is a table representing the Import entities in Dynamics CRM. |

ImportData | Tables | This is a table representing the ImportData entities in Dynamics CRM. |

ImportEntityMapping | Tables | This is a table representing the ImportEntityMapping entities in Dynamics CRM. |

ImportFile | Tables | This is a table representing the ImportFile entities in Dynamics CRM. |

ImportJob | Tables | This is a table representing the ImportJob entities in Dynamics CRM. |

ImportLog | Tables | This is a table representing the ImportLog entities in Dynamics CRM. |

ImportMap | Tables | This is a table representing the ImportMap entities in Dynamics CRM. |

Incident | Tables | This is a table representing the Incident entities in Dynamics CRM. |

IncidentResolution | Tables | This is a table representing the IncidentResolution entities in Dynamics CRM. |

IntegrationStatus | Tables | This is a table representing the IntegrationStatus entities in Dynamics CRM. |

InternalAddress | Tables | This is a table representing the InternalAddress entities in Dynamics CRM. |

InterProcessLock | Tables | This is a table representing the InterProcessLock entities in Dynamics CRM. |

InvalidDependency | Tables | This is a table representing the InvalidDependency entities in Dynamics CRM. |

Invoice | Tables | This is a table representing the Invoice entities in Dynamics CRM. |

InvoiceDetail | Tables | This is a table representing the InvoiceDetail entities in Dynamics CRM. |

IsvConfig | Tables | This is a table representing the IsvConfig entities in Dynamics CRM. |

KbArticle | Tables | This is a table representing the KbArticle entities in Dynamics CRM. |

KbArticleComment | Tables | This is a table representing the KbArticleComment entities in Dynamics CRM. |

KbArticleTemplate | Tables | This is a table representing the KbArticleTemplate entities in Dynamics CRM. |

Lead | Tables | This is a table representing the Lead entities in Dynamics CRM. |

LeadAddress | Tables | This is a table representing the LeadAddress entities in Dynamics CRM. |

LeadCompetitors | Tables | This is a table representing the LeadCompetitors entities in Dynamics CRM. |

LeadProduct | Tables | This is a table representing the LeadProduct entities in Dynamics CRM. |

Letter | Tables | This is a table representing the Letter entities in Dynamics CRM. |

License | Tables | This is a table representing the License entities in Dynamics CRM. |

List | Tables | This is a table representing the List entities in Dynamics CRM. |

ListMember | Tables | This is a table representing the ListMember entities in Dynamics CRM. |

LookUpMapping | Tables | This is a table representing the LookUpMapping entities in Dynamics CRM. |

MailMergeTemplate | Tables | This is a table representing the MailMergeTemplate entities in Dynamics CRM. |

Metric | Tables | This is a table representing the Metric entities in Dynamics CRM. |

MonthlyFiscalCalendar | Tables | This is a table representing the MonthlyFiscalCalendar entities in Dynamics CRM. |

Notification | Tables | This is a table representing the Notification entities in Dynamics CRM. |

Opportunity | Tables | This is a table representing the Opportunity entities in Dynamics CRM. |

OpportunityClose | Tables | This is a table representing the OpportunityClose entities in Dynamics CRM. |

OpportunityCompetitors | Tables | This is a table representing the OpportunityCompetitors entities in Dynamics CRM. |

OpportunityProduct | Tables | This is a table representing the OpportunityProduct entities in Dynamics CRM. |

OptionSetInfo | Tables | Gets basic information about the OptionSet values available for a given table and displays the mapping of OptionSet string values to OptionSet int values. |

OrderClose | Tables | This is a table representing the OrderClose entities in Dynamics CRM. |

Organization | Tables | This is a table representing the Organization entities in Dynamics CRM. |

OrganizationStatistic | Tables | This is a table representing the OrganizationStatistic entities in Dynamics CRM. |

OrganizationUI | Tables | This is a table representing the OrganizationUI entities in Dynamics CRM. |

Owner | Tables | This is a table representing the Owner entities in Dynamics CRM. |

OwnerMapping | Tables | This is a table representing the OwnerMapping entities in Dynamics CRM. |

PhoneCall | Tables | This is a table representing the PhoneCall entities in Dynamics CRM. |

PickListMapping | Tables | This is a table representing the PickListMapping entities in Dynamics CRM. |

PluginAssembly | Tables | This is a table representing the PluginAssembly entities in Dynamics CRM. |

plug-intype | Tables | This is a table representing the plug-in type entities in Dynamics CRM. |

PluginTypeStatistic | Tables | This is a table representing the PluginTypeStatistic entities in Dynamics CRM. |

PriceLevel | Tables | This is a table representing the PriceLevel entities in Dynamics CRM. |

PrincipalAttributeAccessMap | Tables | This is a table representing the PrincipalAttributeAccessMap entities in Dynamics CRM. |

PrincipalEntityMap | Tables | This is a table representing the PrincipalEntityMap entities in Dynamics CRM. |

PrincipalObjectAccess | Tables | This is a table representing the PrincipalObjectAccess entities in Dynamics CRM. |

PrincipalObjectAttributeAccess | Tables | This is a table representing the PrincipalObjectAttributeAccess entities in Dynamics CRM. |

Privilege | Tables | This is a table representing the Privilege entities in Dynamics CRM. |

PrivilegeObjectTypeCodes | Tables | This is a table representing the PrivilegeObjectTypeCodes entities in Dynamics CRM. |

ProcessSession | Tables | This is a table representing the ProcessSession entities in Dynamics CRM. |

Product | Tables | This is a table representing the Product entities in Dynamics CRM. |

ProductAssociation | Tables | This is a table representing the ProductAssociation entities in Dynamics CRM. |

ProductPriceLevel | Tables | This is a table representing the ProductPriceLevel entities in Dynamics CRM. |

ProductSalesLiterature | Tables | This is a table representing the ProductSalesLiterature entities in Dynamics CRM. |

ProductSubstitute | Tables | This is a table representing the ProductSubstitute entities in Dynamics CRM. |

Publisher | Tables | This is a table representing the Publisher entities in Dynamics CRM. |

PublisherAddress | Tables | This is a table representing the PublisherAddress entities in Dynamics CRM. |

QuarterlyFiscalCalendar | Tables | This is a table representing the QuarterlyFiscalCalendar entities in Dynamics CRM. |

Queue | Tables | This is a table representing the Queue entities in Dynamics CRM. |

QueueItem | Tables | This is a table representing the QueueItem entities in Dynamics CRM. |

Quote | Tables | This is a table representing the Quote entities in Dynamics CRM. |

QuoteClose | Tables | This is a table representing the QuoteClose entities in Dynamics CRM. |

QuoteDetail | Tables | This is a table representing the QuoteDetail entities in Dynamics CRM. |

RecurrenceRule | Tables | This is a table representing the RecurrenceRule entities in Dynamics CRM. |

RecurringAppointmentMaster | Tables | This is a table representing the RecurringAppointmentMaster entities in Dynamics CRM. |

RelationshipRole | Tables | This is a table representing the RelationshipRole entities in Dynamics CRM. |

RelationshipRoleMap | Tables | This is a table representing the RelationshipRoleMap entities in Dynamics CRM. |

Report | Tables | This is a table representing the Report entities in Dynamics CRM. |

ReportCategory | Tables | This is a table representing the ReportCategory entities in Dynamics CRM. |

ReportEntity | Tables | This is a table representing the ReportEntity entities in Dynamics CRM. |

ReportLink | Tables | This is a table representing the ReportLink entities in Dynamics CRM. |

ReportVisibility | Tables | This is a table representing the ReportVisibility entities in Dynamics CRM. |

Resource | Tables | This is a table representing the Resource entities in Dynamics CRM. |

ResourceGroup | Tables | This is a table representing the ResourceGroup entities in Dynamics CRM. |

ResourceGroupExpansion | Tables | This is a table representing the ResourceGroupExpansion entities in Dynamics CRM. |

ResourceSpec | Tables | This is a table representing the ResourceSpec entities in Dynamics CRM. |

RibbonCommand | Tables | This is a table representing the RibbonCommand entities in Dynamics CRM. |

RibbonContextGroup | Tables | This is a table representing the RibbonContextGroup entities in Dynamics CRM. |

RibbonCustomization | Tables | This is a table representing the RibbonCustomization entities in Dynamics CRM. |

RibbonDiff | Tables | This is a table representing the RibbonDiff entities in Dynamics CRM. |

RibbonRule | Tables | This is a table representing the RibbonRule entities in Dynamics CRM. |

RibbonTabToCommandMap | Tables | This is a table representing the RibbonTabToCommandMap entities in Dynamics CRM. |

Role | Tables | This is a table representing the Role entities in Dynamics CRM. |

RolePrivileges | Tables | This is a table representing the RolePrivileges entities in Dynamics CRM. |

RoleTemplate | Tables | This is a table representing the RoleTemplate entities in Dynamics CRM. |

RoleTemplatePrivileges | Tables | This is a table representing the RoleTemplatePrivileges entities in Dynamics CRM. |

RollupField | Tables | This is a table representing the RollupField entities in Dynamics CRM. |

SalesLiterature | Tables | This is a table representing the SalesLiterature entities in Dynamics CRM. |

SalesLiteratureItem | Tables | This is a table representing the SalesLiteratureItem entities in Dynamics CRM. |

SalesOrder | Tables | This is a table representing the SalesOrder entities in Dynamics CRM. |

SalesOrderDetail | Tables | This is a table representing the SalesOrderDetail entities in Dynamics CRM. |

SalesProcessInstance | Tables | This is a table representing the SalesProcessInstance entities in Dynamics CRM. |

SavedQuery | Tables | This is a table representing the SavedQuery entities in Dynamics CRM. |

SavedQueryVisualization | Tables | This is a table representing the SavedQueryVisualization entities in Dynamics CRM. |

SdkMessage | Tables | This is a table representing the SdkMessage entities in Dynamics CRM. |

SdkMessageFilter | Tables | This is a table representing the SdkMessageFilter entities in Dynamics CRM. |

SdkMessagePair | Tables | This is a table representing the SdkMessagePair entities in Dynamics CRM. |

SdkMessageProcessingStep | Tables | This is a table representing the SdkMessageProcessingStep entities in Dynamics CRM. |

SdkMessageProcessingStepImage | Tables | This is a table representing the SdkMessageProcessingStepImage entities in Dynamics CRM. |

SdkMessageProcessingStepSecureConfig | Tables | This is a table representing the SdkMessageProcessingStepSecureConfig entities in Dynamics CRM. |

SdkMessageRequest | Tables | This is a table representing the SdkMessageRequest entities in Dynamics CRM. |

SdkMessageRequestField | Tables | This is a table representing the SdkMessageRequestField entities in Dynamics CRM. |

SdkMessageResponse | Tables | This is a table representing the SdkMessageResponse entities in Dynamics CRM. |

SdkMessageResponseField | Tables | This is a table representing the SdkMessageResponseField entities in Dynamics CRM. |

SemiAnnualFiscalCalendar | Tables | This is a table representing the SemiAnnualFiscalCalendar entities in Dynamics CRM. |

Service | Tables | This is a table representing the Service entities in Dynamics CRM. |

ServiceAppointment | Tables | This is a table representing the ServiceAppointment entities in Dynamics CRM. |

ServiceContractContacts | Tables | This is a table representing the ServiceContractContacts entities in Dynamics CRM. |

ServiceEndpoint | Tables | This is a table representing the ServiceEndpoint entities in Dynamics CRM. |

SharePointDocumentLocation | Tables | This is a table representing the SharePointDocumentLocation entities in Dynamics CRM. |

SharePointSite | Tables | This is a table representing the SharePointSite entities in Dynamics CRM. |

Site | Tables | This is a table representing the Site entities in Dynamics CRM. |

SiteMap | Tables | This is a table representing the SiteMap entities in Dynamics CRM. |

Solution | Tables | This is a table representing the Solution entities in Dynamics CRM. |

SolutionComponent | Tables | This is a table representing the SolutionComponent entities in Dynamics CRM. |

StatusMap | Tables | This is a table representing the StatusMap entities in Dynamics CRM. |

StringMap | Tables | This is a table representing the StringMap entities in Dynamics CRM. |

Subject | Tables | This is a table representing the Subject entities in Dynamics CRM. |

Subscription | Tables | This is a table representing the Subscription entities in Dynamics CRM. |

SubscriptionClients | Tables | This is a table representing the SubscriptionClients entities in Dynamics CRM. |

SubscriptionManuallyTrackedObject | Tables | This is a table representing the SubscriptionManuallyTrackedObject entities in Dynamics CRM. |

SubscriptionSyncInfo | Tables | This is a table representing the SubscriptionSyncInfo entities in Dynamics CRM. |

SubscriptionTrackingDeletedObject | Tables | This is a table representing the SubscriptionTrackingDeletedObject entities in Dynamics CRM. |

SystemForm | Tables | This is a table representing the SystemForm entities in Dynamics CRM. |

SystemUser | Tables | This is a table representing the SystemUser entities in Dynamics CRM. |

SystemUserBusinessUnitEntityMap | Tables | This is a table representing the SystemUserBusinessUnitEntityMap entities in Dynamics CRM. |

SystemUserLicenses | Tables | This is a table representing the SystemUserLicenses entities in Dynamics CRM. |

SystemUserPrincipals | Tables | This is a table representing the SystemUserPrincipals entities in Dynamics CRM. |

SystemUserProfiles | Tables | This is a table representing the SystemUserProfiles entities in Dynamics CRM. |

SystemUserRoles | Tables | This is a table representing the SystemUserRoles entities in Dynamics CRM. |

Task | Tables | This is a table representing the Task entities in Dynamics CRM. |

Team | Tables | This is a table representing the Team entities in Dynamics CRM. |

TeamMembership | Tables | This is a table representing the TeamMembership entities in Dynamics CRM. |

TeamProfiles | Tables | This is a table representing the TeamProfiles entities in Dynamics CRM. |

TeamRoles | Tables | This is a table representing the TeamRoles entities in Dynamics CRM. |

Template | Tables | This is a table representing the Template entities in Dynamics CRM. |

Territory | Tables | This is a table representing the Territory entities in Dynamics CRM. |

TimeZoneDefinition | Tables | This is a table representing the TimeZoneDefinition entities in Dynamics CRM. |

TimeZoneLocalizedName | Tables | This is a table representing the TimeZoneLocalizedName entities in Dynamics CRM. |

TimeZoneRule | Tables | This is a table representing the TimeZoneRule entities in Dynamics CRM. |

TransactionCurrency | Tables | This is a table representing the TransactionCurrency entities in Dynamics CRM. |

TransformationMapping | Tables | This is a table representing the TransformationMapping entities in Dynamics CRM. |

TransformationParameterMapping | Tables | This is a table representing the TransformationParameterMapping entities in Dynamics CRM. |

UnresolvedAddress | Tables | This is a table representing the UnresolvedAddress entities in Dynamics CRM. |

UoM | Tables | This is a table representing the UoM entities in Dynamics CRM. |

UoMSchedule | Tables | This is a table representing the UoMSchedule entities in Dynamics CRM. |

UserEntityInstanceData | Tables | This is a table representing the UserEntityInstanceData entities in Dynamics CRM. |

UserEntityUISettings | Tables | This is a table representing the UserEntityUISettings entities in Dynamics CRM. |

UserFiscalCalendar | Tables | This is a table representing the UserFiscalCalendar entities in Dynamics CRM. |

UserForm | Tables | This is a table representing the UserForm entities in Dynamics CRM. |

UserQuery | Tables | This is a table representing the UserQuery entities in Dynamics CRM. |

UserQueryVisualization | Tables | This is a table representing the UserQueryVisualization entities in Dynamics CRM. |

UserSettings | Tables | This is a table representing the UserSettings entities in Dynamics CRM. |

WebResource | Tables | This is a table representing the WebResource entities in Dynamics CRM. |

WebWizard | Tables | This is a table representing the WebWizard entities in Dynamics CRM. |

WizardAccessPrivilege | Tables | This is a table representing the WizardAccessPrivilege entities in Dynamics CRM. |

WizardPage | Tables | This is a table representing the WizardPage entities in Dynamics CRM. |

Workflow | Tables | This is a table representing the Workflow entities in Dynamics CRM. |

WorkflowDependency | Tables | This is a table representing the WorkflowDependency entities in Dynamics CRM. |

WorkflowLog | Tables | This is a table representing the WorkflowLog entities in Dynamics CRM. |

WorkflowWaitSubscription | Tables | This is a table representing the WorkflowWaitSubscription entities in Dynamics CRM. |

## Advanced Settings

To view a detailed advanced settings options, go to Dynamics CRM Advanced Settings. Complete list of the parameters you can configure in the connection string can be found by clicking Connection String Parameters.