CRM, SSIS & Integrations ...configuring CRM as a non-coder
  • Home
  • Categories
    • Visual Studio
    • KingswaySoft
    • SSIS
    • JavaScript
    • CRM
    • SQL
    • ERP
    • Azure
    • How-to
    • Clubtimiser A/S
    • Office
    • Personal
  • About me
  • Privacy Policy
CRM, SSIS & Integrations
  • Home
  • Categories
    • Visual Studio
    • KingswaySoft
    • SSIS
    • JavaScript
    • CRM
    • SQL
    • ERP
    • Azure
    • How-to
    • Clubtimiser A/S
    • Office
    • Personal
  • About me
  • Privacy Policy
  • Home
  • CRM
  • KingswaySoft
  • SSIS
  • Visual Studio
  • Using KingswaySoft to migrate ClickDimensions

Using KingswaySoft to migrate ClickDimensions

August 1, 2018 7 Comments Written by Thomas

EDIT: Before migrating ClickDimensions records, you should already have migrated contacts and marketinglists, as these records are required by some of the entities from ClickDimensions.

I was tasked with migrating a ClickDimensions solution from one Dynamics 365 to another Dynamics365 (both version 9.0). The only differences were, that it was a different CRM tenant and a newer version of ClickDimensions (v9.4.0 – the old was v9.2.0).

Before starting a migration, which has quite a lot of entities and data, I prefer to make a game plan, and determine how I want to attack the task at hand – and that is where I started here as well.

Due to the amount of entities and relationships in between the different areas of ClickDimensions, I reached out to their support-team, to ask them about a migration-order, so all the entities were migrated correctly with their respective links. I am aware, that I can migrate all the records without unique identifier and update all those fields in a secondary migration after all the records have been created, but I wanted a one-shot migration for this, as there is a lot of data.

When I asked ClickDimensions for the correct migration order, they weren’t able to help me, as they had never been asked that question before – a bit odd. However, after several tries, escalations and support staff-members, we received a correct order for the migration, to minimize the relationship issues. When migrating the entities, some of them will throw plugin-errors, and in that case, you just need to disable the plugins mentions in the error message (often in regard to Create). Remember to reactivate the plugins, after you migrated the records!

This is the list I received (with my own comments):

  • Systemuser
  • Domain (Disable Create plugin)
  • Campaign
  • Email Template
  • Nurture Program (This entity is not present in v9.4 of ClickDimensions)
  • Email Send
  • Sent Email
  • Email Event
  • Excluded Email
  • Bulk Text Message
  • IP Organization
  • Anonymous Visitor
  • ClickDimensions Import
  • Import Log
  • Filter (Disable Create plugin)
  • Form Field
  • Profile
  • Form Capture (Disable Create plugin)
  • Form Capture Field (Disable Create plugin)
  • Event
  • Event Participation
  • Option Mapping (This entity is not present in v9.4 of ClickDimensions)
  • Setting
  • Subscription List
  • Web Content
  • Visit
  • Page View
  • Unsubscribe
  • Send ClickDimensions Email
  • Posted Subscription
  • Posted Survey
  • Run Nurture (This entity is not present in v9.4 of ClickDimensions)
  • Posted Form
  • Posted Field
  • Subscription Preference
  • Survey Question
  • Survey Answer
  • Text Message

This is the package I made for the migration – it is pretty straight forward, as it just migrates each entity one at a time.

Screenshot of ClickDimensions migration

It can be a long migration, depending on how old the ClickDimension installation is. Entities like visitor and page view can have A LOT of records. But following the list above, should make it rather painless.

CRM, KingswaySoft, SSIS, Visual Studio
CRM Online, Dynamics365, How To, KingswaySoft, Solution, SSIS
CRM Theme generator
Split fullName into first- and lastname in SQL, Excel and SSIS

7 Comments

  1. j arkley j arkley
    August 29, 2018    

    This was a help getting familiar with the process so thank you. The sent email is dependent on contacts being available so did you need to also have contacts migrated? Other CRM entities required include Campaigns and marketing list

  2. Thomas Thomas
    August 29, 2018    

    Yes, the contacts were also needed to be migrated – I forgot to mention that 🙂

    Before I started the migration of clickdimensions, I migrated the standard CRM data.

  3. Abdullah Abdullah
    October 25, 2018    

    Can you share with us the SSIS package?

  4. Duchan Duchan
    December 19, 2018    

    Hi Thomas, thanks for the article. Migration target was with same clickdimensions id (licence)? How you handle web content that is stored in a cloud and is unique for every installation? As is written in documentation – you shouldn’t migrate web content (and few other entities) but recreate on the new instance.

  5. Thomas Thomas
    December 19, 2018    

    Hi Duchan, I wasnt involved with the data stored in the ClickDimension cloud. I was just brought on for the data transfer specific for Dynamics 365.

  6. Alice Bai Alice Bai
    January 10, 2020    

    Hi Master,
    could I know how to move web content across different crm environment ?

    Thanks

  7. Thomas Thomas
    January 24, 2020    

    Hi Alice, I didnt do anything special to the entities, when I migrated the data. What kind of problems are you experiencing?

    Image 1image 2

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

The author

KingswaySoft MVP & Microsoft certified professional

My name is Thomas and I am a consultant at a company called netcompany A/S in Denmark. My primary focus is working with SSIS and KingswaySoft, where I perform integrations and datatranformations.

Click for more info

Recent Posts

  • Difference between two dates (SQL, SSIS and JavaScript)
  • Easy way to fetch row count for all tables in a SQL database
  • Create Application user in Azure for use in Dynamics 365
  • SSIS Basics: Merge join
  • Open dashboards in a new window

Useful information

  • Installation guide to KingswaySoft
  • Software download list
  • CRM Object Type Codes
  • CRM State & Status codes
  • Script Repository

Archives

  • May 2020 (1)
  • February 2020 (1)
  • January 2020 (2)
  • August 2019 (1)
  • May 2019 (1)
  • February 2019 (2)
  • January 2019 (2)
  • November 2018 (1)
  • September 2018 (1)
  • August 2018 (3)
  • May 2018 (4)
  • December 2017 (2)
  • August 2017 (1)
  • February 2017 (1)
  • November 2016 (4)
  • October 2016 (1)
  • September 2016 (2)
  • August 2016 (5)
  • June 2016 (4)
  • May 2016 (3)

Useful blogs/links

Henrik Jensen, my good friend and colleague, has a blog regarding EVERYTHING Dynamics crm. He's got 50+ certifications, and he is a force to be reckoned with. Link to his blog (danish): crmblog.dk

KingswaySoft have developed an outstanding piece of software for datamanagement to and from CRM, and I can recommend this toolkit for nearly every situation. Link to their website: kingswaysoft.com

Tag Cloud

Azure Bug CRM 2015 CRM 2016 CRM Online Data Dynamics365 ERP Excel How To JavaScript KingswaySoft Log News Office Outlook Personal Solution SQL SSIS Visual Studio

Categories

  • Azure (2)
  • Clubtimiser A/S (1)
  • CRM (30)
  • ERP (2)
  • How-to (14)
  • JavaScript (3)
  • Office (3)
  • Personal (4)
  • SQL (2)
  • Visual Studio (23)
    • SSIS (23)
      • KingswaySoft (14)

Disclaimer

The information given on the website is tested on a mixture of live production environments and test environments, and therefore I cannot guarantee my information will work for you, if you attempt to follow my steps.
If you experience problems, please feel free to contact me.

@June 7th 2016