User:KellyFitzpatrick/Real-time ETL

Real-time extract, transform and load (ETL) is a process that extracts data from outside sources, transforms the data to support an organization’s requirements, and loads the data into the end target (e.g. database, data warehouse).

Historically, ETL was updated on a batch-processing basis. This created bottlenecks and operational constraints that did not support 24/7 operations and the batch windows became too large and unmanageable. Real-time ETL surmounts these challenges.

Real-time ETL employs data connectors to extract data from any source in any system, on any platform. The data is then converted and streamed into a dynamic networking environment. These dynamic environments are tailored to specific organizational requirements, allowing associations to be made across the previously disparate data sources.

The dynamic networking environment can be continually updated. This updating process can be done real-time or on a scheduled basis.