DM Radio
Integration Strategies for Pervasive BI
As organizations seek to spread the insights of business intelligence (BI) throughout the enterprise, the challenge to data integrators becomes more difficult. Already working long hours to keep bread and butter extract-transform-load (ETL) processes on time, these professionals must now find creative ways to deliver more data to more systems, both analytical and operational. Augmenting a warehouse or analytical app with an additional dimension or two may not be rocket science, but delivering BI insight to operational systems does require additional effort. Operational and analytical systems were separated years ago for the expressed purpose of preventing analytical queries from disrupting operations. Thanks to advances in integration technology—including message queues and Web services—this type of on-the-fly integration is now possible. Tune into this episode of DM Radio to hear the experts explain the various ways companies can deliver BI insights to the front lines of their organization without having to purchase a whole new set of technologies. Attendees will learn: · Best practices for traditional Extract Transform Load (ETL) processing; · How message queues can be used to refresh data sets; · The benefits and drawbacks of federated data management; · How open-source tools can be used to integrate data; · How replication technology can augment data integration.
For more information on related topics, visit the following:
