Data integration is a fundamental -- yet deceptively challenging -- part of any business intelligence (BI) system. BI is commonly used to support key decision-making processes and can be a surprisingly high-profile endeavor. Additionally, integrating data from disparate sources across an organization has unique challenges. Luckily, best practices and techniques for BI-data integration are rapidly evolving. Now, organizations have many more choices than just extract, transform and load (ETL) or hand-coded approaches. There are plenty of new methods and tools on the market, each with their own benefits and drawbacks -- and some work better than others, depending on your organization's requirements and budget.
In this 12-minute podcast, appropriate for IT and BI professionals, consultant Rick Sherman discusses the various data integration methods used for BI today.
- Find out the pros and cons of the top data integration techniques for BI and learn how data integration choices can make or break a BI program
- Hear common mistakes that organizations often make when it comes to designing data integration for BI systems
- Learn more about new methods for BI data integration, such as the emerging real-time techniques and tools
- Get expert advice for designing or optimizing a BI-data integration strategy
Download for later:
- Internet Explorer: Right Click > Save Target As
- Firefox: Right Click > Save Link As
About the speaker: Rick Sherman is the founder of Athena IT Solutions, a Boston-based consulting firm that provides data warehouse and business intelligence consulting, training and vendor services. Sherman has almost 20 years of data warehousing and decision support systems experience, having built his first data warehouse and data mart in 1987. He has been designing and implementing relational database for decision support systems for years and has worked on over 50 data warehouse and data mart implementations across many industry groups, sourcing data from a variety of business applications. Sherman writes about data management topics for a variety of publications, speaks at industry events and serves as a judge for industry awards. He is a frequent contributor and data management expert at SearchDataManagement.com. He can be found blogging at The Data Doghouse and can be reached at email@example.com. Read all of Sherman's contributions to SearchDataManagement.com here.
For more on business intelligence and data integration:
Read about the top three methods for real time data integration
Learn more about business intelligence, in the SearchDataManagement.com business intelligence All-In-One-Guide, featuring case studies, articles, advice and more
Email SearchBusinessAnalytics.com editors with your story ideas, comments or questions
This was first published in April 2008