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
  • Tag: How To

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

Difference between two dates (SQL, SSIS and Jav...

May 4, 2020 Written by Thomas

When I work with contracts, accruals, forecasts etc, I often have to calculate the duration of the contract, or in general the difference between two dates. I have been using an ordinary datediff in Months, as this is the fastest way, to get the duration of a contract in months.

CRM, How-to, JavaScript, SQL, SSIS
Read More Leave a Comment

Easy way to fetch row count for all tables in a...

February 4, 2020 Written by Thomas

This is just a quick post for, with a old method for fetching the row count for a entire database – for future reference (Works in Azure – doesn’t require stored proc)

Azure, How-to, SQL
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

SSIS Basics: Merge join

January 20, 2020 Written by Thomas

For this small how-to, I’ll go through how to use the Merge Join in SSIS. The Merge Join is used for joining data into the a single row from two different datastreams. A basic example, where the MergeJoin can be used, is where you have a flat file with emails, and you need to locate […]

CRM, How-to, SSIS
Read More Leave a Comment

Open dashboards in a new window

August 12, 2019 Written by Thomas

It can sometimes be a requirement, to open a dashboard in a seperat window using a URL – but what does the link look like, and where can you find the info you need? The URL is a static one, where you only need to replace the GUID for the given dashboard, you wish to […]

CRM, How-to
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