5 ETL - the data migration process
It's far from trivial to load data into an archive system. In a lucky case, a software vendor provides a connector of a business software A to an archive system B, but this is the rare case. Most of the time we're on our own.
Let's look into the details, what needs to be done here. ETL stands for extract, transform, load: