Three Legacy System Conversion Scenarios You are most Likely to Encounter

Let's dive right in...
The project I am currently working on will require among many other things, the assimilation of a variety of source systems into a single system.  Many of the systems that are scheduled for conversion are owned by our organization. Some others are owned by a "third party." How to address each of them will vary. The next few paragraphs try to relate some of those thoughts. Perhaps you might find some merit in that or chip in you own?

Automating ETL to do OLTP to OLTP - Part 2

Let's see where did we end up last time... Ah yes! We were talking about the "T" in the ETL process, otherwise known as "Transformation."

If you are picking up this topic out of order, I encourage you to go hop over to our first blog on it. You may get there quicker by following this link.

Automating ETL to do OLTP to OLTP - Part 1

ETL: Extraction, Transformation, and Loading


Traditionally, ETL refers to performing tasks to extract, transform and load data from an OLTP system to an OLAP system or environment. In this particular context, we are concerned with performing ETL tasks between a source OLTP system and a different destination OLTP system. This is the typical scenario when you are asked to convert data from an old system to a new one, where both source and target systems are main-line operational systems.