Power Platform offers a seriously amazing way of importing data from different sources into CDS. I will try to cover them as i learn them all.
One of the ways of importing data to CDS is something called DataFlow. This tool uses a combination of Power Query, Azure Message Bus and other magic to import data from different sources. One of the connectors Onpremise Data Gateway offers is SQL server. If you combine this connector with a OnPremise Data Gateway you are really kicking some ass!!
Part 1 – The Setup
Part 2 – Sync Account Data to CDS
Part 3 – Connecting Projects to Account
Part 4 – Connecting Customer Lookup
Part 5 – Data Flow Behind The Scenes
SSIS – KingsWaySoft
SSIS is a very robust tool for ETL and data load processes used by many. Within the world of Dynamics it is most commonly used for batch based Migration/Integration with the KingsaySoft component. I will be very careful throwing out a comparison DataFlow VS SSIS, because it would not be fair. I don’t have enough knowledge to fully show what SSIS is capable of.