News Stay informed about the latest enterprise technology news and product updates.

Understanding the top business intelligence data integration techniques

Learn the pros and cons of the top business intelligence data integration methods, find out common challenges and hear expert advice for BI-data integration strategies.

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.

Listeners will:

  • 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
Play now:
Download for later:

Understanding the top business intelligence data integration techniques

  • Internet Explorer: Right Click > Save Target As
  • Firefox: Right Click > Save Link As










Rick Sherman

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 He can be found blogging at The Data Doghouse and can be reached at [email protected] Read all of Sherman's contributions to here.


For more on business intelligence and data integration:

Find out the real deal on data integration for business intelligence

Read about the top three methods for real time data integration

See how Gartner ranked vendors and read advice in coverage of Gartner's Magic Quadrant for data integration software

Download short podcast tutorials about common data integration methods

Learn more about business intelligence, in the business intelligence All-In-One-Guide, featuring case studies, articles, advice and more

Email editors  with your story ideas, comments or questions

Dig Deeper on Business intelligence software