Data Integration: ETL or ELT?

Data integration: ETL vs ELTModern enterprises gather data from many disparate sources, including social media, websites, customer databases (CRM systems, sales records etc), customer support systems, and HR software.

Merely collecting lots of data isn't useful in itself—it's the insights you get from such data that can drive more informed business decisions. This post aims to teach you about the bedrock processes required for obtaining insights from your data—ETL and ELT.

We'll begin by discussing data integration, before moving on to two vital forms of data integration—ETL and ELT. When you're finished reading, you'll fully understand what ETL and ELT are, and which process is better suited to your business in terms of getting actionable insights from different data sources..  

Informatica Releases First-Ever Book On Lean Integration

Informatica Corporation, the world’s number one independent provider of enterprise data integration software, today announced the release of the industry’s first book about applying lean principles to the challenges of enterprise data and process integration, entitled Lean Integration: An Integration Factory Approach to Business Agility. Authored by noted data integration experts and Informatica executives John G. Schmidt and David Lyle, Lean Integration describes why the integration factory will be the dominant new “wave” of middleware for the next decade. It provides detailed best practices for implementing a lean integration strategy to align functions, eliminate waste and drive continuous improvements across vital data integration activities.