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
  • Visual Studio
  • SSIS
  • KingswaySoft

Homemade SSIS load balancer for large data load...

February 9, 2021 Written by Thomas

When you need to import hundreds of thousands records, it can take a long time to import with the KingswaySoft destination. This can be a serious issue, if a large data load is part of a scheduled running job. For this reason, it can make a lot of sense, to balance the load across multiple […]

CRM, How-to, KingswaySoft, SQL, SSIS, Visual Studio
Read More Leave a Comment

Create Application user in Azure for use in Dyn...

January 24, 2020 Written by Thomas

When using multifactor authentication for your Dynamics 365, it tends to cause issues with the KingswaySoft connector, as MFA is not supported by their toolkit. Therefore – as an alternative to disabling the MFA – you can switch to OAuth authentication in the KingswaySoft connection manager and connect with a Azure Application user, and I […]

Azure, CRM, How-to, KingswaySoft, Visual Studio
Read More Leave a Comment

Video guide: Install Visual Studio 2017 and Kin...

May 10, 2019 Written by Thomas
CRM, How-to, KingswaySoft, SSIS, Visual Studio
Read More Leave a Comment

Installing Visual Studio 2017 and KingswaySoft

September 4, 2018 Written by Thomas

I have previously writting about an error I recieved when I attempted to installed SSDT for Visual Studio 2017. But with the new version of SSDT, Microsoft have seemingly fixed the bug, and you can now easily install SSDT with Visual Studio 2017. Firstly, you need the installer for Visual Studio 2017 (community works fine) […]

How-to, KingswaySoft, SSIS, Visual Studio
Read More Leave a Comment

Using KingswaySoft to migrate ClickDimensions

August 1, 2018 Written by Thomas
ClickDimensions Logo

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

CRM, KingswaySoft, SSIS, Visual Studio
Read More 7 Comments

KingswaySoft Spring release v10

May 2, 2018 Written by Thomas
KingswaySoft

KingswaySoft recently released their spring 2018 release marked as version 10. This release introduces numerous awesome changes, which makes data integration and transformation a lot easier and seamless. Some of the changes include: The CRM Source component now includes a SQL to FetchXML converter which allows you to convert SQL script to FetchXML query directly […]

CRM, KingswaySoft, SSIS
Read More Leave a Comment
Older Entries

The author

KingswaySoft MVP & Microsoft certified professional

My name is Thomas and I am a Senior 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

  • Homemade SSIS load balancer for large data loads
  • 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

Useful information

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

Archives

  • February 2021 (1)
  • 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 (31)
  • ERP (2)
  • How-to (15)
  • JavaScript (3)
  • Office (3)
  • Personal (4)
  • SQL (3)
  • Visual Studio (24)
    • SSIS (24)
      • KingswaySoft (15)

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