Skip to content

BTWS3 | Get to Know Data Integration for Microsoft Dynamics CRM | 6/29/2016

If you’re thinking of having all of your customer data at the center of your Digital Strategy; then you’re really talking about Data Integration for Microsoft Dynamics CRM…

BTWS - Business Technology Webinar SeriesView the Get to Know Data Integration for Microsoft Dynamics CRM recorded session.  (The Philadelphia CRM User Group met Wednesday, June 29th, and this session was recorded a day later on June 30th.)

Download the Get to Know Data Integration for Microsoft Dynamics CRM presentation deck.

Featuring Microsoft Dynamics CRM Online Spring 2016 Wave, Microsoft SQL Server, eOne Solutions SmartConnect, Scribe Insight, SQL Server Integration Services (SSIS), KingswaySoft, CozyRoc SSIS+, and Scribe Online Replication Services.  This webinar includes demos of the following scenarios:

  • eOne Solutions SmartConnect migration of Accounts from Adventure Works SQL database
  • A two-part typical data migration / upload-to-CRM sequence:
    • Upload Leads marketing list from Excel spreadsheet to SQL Server
    • Migrate same from SQL table to CRM Online using SSIS with KingswaySoft and CozyRoc SSIS+ components
  • Migrate Leads from one CRM Online System to another using Fetch XML as a data source; further running similar SSIS job to run a workflow on those same records to add Leads to a Marketing List
  • Setup and demonstrated a near real-time integration moving any changed Account data from one CRM system to another with Scribe Publisher and MSMQ message queue technology.
  • Replicated an entire CRM Online database to an Azure Database in the cloud; for the purpose of archiving CRM data and also for utilizing database as data warehouse for analytics data source (e.g. Power BI).

Please let me know if you have any questions; you can post discussion items below.

Enjoy and thanks for watching!



Marketing in an All-Digital World.

with ClickDimensions

Lots of great new content and strategies for effective digital marketing.
Thursday - 4/22/2021
Marketing in an All-Digital WorldDigital Marketing w/ ClickDimensions


Small Business Cloud Security - Part I

Email Security

Small businesses are a top target for bad actors, and email is the number attack vector. We'll provide tangible steps to keep intruders out!
Tuesday - 8/24/2021
Small Business Cloud SecurityPart I - Email Security


Small Business Cloud Security - Part II

What's Your Secure Score?

Learn how to quickly discover and fix security vulnerabilities in your Office 365 tenant.
Thursday - 8/26/2021
Small Business Cloud SecurityPart II - What's Your Secure Score?


Dynamics 365 Customer Service

Improve Support to Drive Customer Satisfaction.

Get enterprise class customer support on a small business budget.
Tuesday - 5/25/2021
Dynamics 365 Customer ServiceEnterprise Class Support on a Small Business Budget


How can we help?

Please contact us to let us know if you’d like a same-day quote for any product or service offering; or if there’s anything else we can help you with. Main phone number: 215-310-1750