Data Integration Fundamentals

It’s clear that we are living in a data–driven world. Our steady transition toward highly digitized lives is making data a key asset in the modern economy. When we go online to make purchases, consume content, or share on social media, we are generating valuable data. Many of the largest tech companies are now operating on business models that depend on leveraging data. However none of that is possible without data integration. Data integration is the glue that makes it possible to convert raw data into a valuable asset.

In this course, I will focus on three types of data integration: Business–to–Business Integration, Application Integration, and Database Integration. You will learn how businesses exchange data using standard EDI, XML, and APIs. I’ll explain common communication methods like FTP and AS2. You’ll also learn about application integration approaches including SOAP, REST APIs, and Webhooks. And I’ll teach you about database integration technologies involving data warehouses, data lakes, streaming data, extract–transform–load processing, and data propagation techniques like replication.

By the end of the course, you’ll have a solid understanding of how data integration can be used to improve business results. You will be knowledgeable about how these techniques are applied, and will be able to intelligently speak with software vendors, customers, suppliers or your internal IT department about data integration projects.