Easy

For non-technical users

Fast

Setup in under 5 minutes

Secure

Secure data architecture

Dynamics

Dynamics Integration

One way sync
CRM
OAuth Authentication

Data Objects

Accounts

ActionCardMimeAttachment

ActionCardUserStates

ActionCards

ActivityPart

ActivityPointers

Annotations

AnnualFiscalCalendars

AppModuleRoles

Appointments

Asyncoperations

Attachments

BookableResourceBookingHeaders

BookableResourceBookings

BookableResourceCategories

BookableResourceCategoryAssociations

BookableResourceCharacteristics

BookableResourceGroups

BookingStatuses

BulkDeleteFailures

BulkDeleteOperations

BulkOperationLogs

BulkOperations

BusinessUnitNewsArticles

BusinessUnits

CalendarRules

Calendars

CampaignActivities

CampaignActivityItems

CampaignItems

CampaignResponses

Campaigns

Categories

Characteristics

CompetitorAddresses

Competitors

ComplexControls

ConnectionRoles

Connections

ConstraintBasedGroups

Contacts

ContractDetails

ContractTemplates

Contracts

CustomControlDefaultConfigs

CustomControlResources

CustomControls

CustomerAddresses

DataPerformances

Dependencies

DiscountTypes

Discounts

DocumentTemplates

DuplicateRecords

DuplicateRuleConditions

DuplicateRules

DynamicProperties

DynamicPropertyAssociations

DynamicPropertyInstances

DynamicPropertyOptionSetItems

EmailServerProfiles

Emails

EntitlementChannels

EntitlementTemplateChannels

EntitlementTemplates

Entitlements

Equipments

ExchangeSyncIdMappings

ExpiredProcesses

Faxes

Feedback

FieldPermissions

FieldSecurityProfiles

FixedMonthlyFiscalCalendars

GoalRollUpQueries

Goals

ImportDatasets

ImportEntityMappings

ImportFiles

ImportJobs

ImportLogs

ImportMaps

Imports

IncidentResolutions

Incidents

InteractionForEmails

InvalidDependencies

InvoiceDetails

Invoices

KbArticleComments

KbArticleTemplates

KbArticles

KnowledgeArticleIncidents

KnowledgeArticleViews

KnowledgebaseRecords

KnowlegeArticles

LanguageLocals

LeadAddresses

LeadToOpportunitySalesProcess

Leads

... a flat-out huge number of objects

Flatten Data from Dynamics

Destination: Google Drive +Google Sheets
Every 10 Minutes, Hourly, Daily

Data IntegrationFull Data Objects

Export Dynamics comprehensive data objects to CSV, Excel XLSX or Google Sheets files in Google Drive / Google Sheets on a recurring, automatic basis. Past and present data records are included. All rows and cells are refreshed in-place. Frozen rows, filters and sorts are preserved upon Sheet refresh. Using importrange and vlookup two Sheets can be linked and merged by ID fields.

Connect Dynamics data to Google Data Studio via Google Sheets.


Destination: Microsoft OneDrive +Excel Online
Every 10 Minutes, Hourly, Daily

Data IntegrationFull Data Objects

Export Dynamics comprehensive data objects to CSV or Excel XLSX files in Microsoft OneDrive on a recurring, automatic basis. Past and present data records are included. All rows and cells are refreshed in-place.

Connect Dynamics data to Power BI via OneDrive.


Destination: Microsoft OneDrive for Business +Excel Online
Every 10 Minutes, Hourly, Daily

Data IntegrationFull Data Objects

Export Dynamics comprehensive data objects to CSV or Excel XLSX files in Microsoft OneDrive for Business on a recurring, automatic basis. Past and present data records are included. All rows and cells are refreshed in-place.

Connect Dynamics data to Power BI via OneDrive for Business.


Destination: Dropbox
Every 10 Minutes, Hourly, Daily

Data IntegrationFull Data Objects

Export Dynamics comprehensive data objects to CSV or Excel XLSX files in Dropbox folders on a recurring, automatic basis. Past and present data records are included. All rows and cells are refreshed in-place.


Destination: Box
Every 10 Minutes, Hourly, Daily

Data IntegrationFull Data Objects

Export Dynamics comprehensive data objects to CSV or Excel XLSX files in Box folders on a recurring, automatic basis. Past and present data records are included. All rows and cells are refreshed in-place.


Destination: Microsoft Azure
Every 10 Minutes, Hourly, Daily

Data IntegrationFull Data Objects

Export Dynamics comprehensive data objects to blobs in Microsoft Azure on a recurring, automatic basis. Past and present data records are included. All rows and cells are refreshed in-place.


Destination: Amazon S3
Every 10 Minutes, Hourly, Daily

Data IntegrationFull Data Objects

Export Dynamics comprehensive data objects to buckets in Amazon S3 on a recurring, automatic basis. Past and present data records are included. All rows and cells are refreshed in-place.