ETL

Building Microsoft MEAP: Adapters

by

In this second article on building Microsoft MEAP, I’ll focus on implementing Gartner’s Enterprise Application Integration Tools critical capability using SQL Server Integration Services (SSIS) to connect to back end systems. As I mentioned in the Introduction article, one of the top priorities for CIOs today is extending critical data from their backend systems out to the wireless … Read more

Human Extract, Transform, and Load

by

HETL (Human Extract, Transform, and Load) Definition:  When an employee in the field captures data with a pen or pencil & paper, drives back to the office at the end of the workday, and manually transcribes the data into a back-end computer system. You’re probably thinking this is an antiquated phenomenon that disappeared decades ago with the advent of … Read more