Search results

This IBM Redbook describes how to create and implement a federated data management environment. That environment can enable access to, and use of, multiple heterogeneous data sources as if they were all resident in the same data management system. We use Informix Dynamic Server (IDS) and DB2 as the primary data sources, along with Informix Extended Parallel Server (XPS), Red Brick Warehouse, Oracle9i, and Microsoft Excel as data sources. We also use data management tools, such as IBM DB2 Information Integrator and Informix Enterprise Gateway Manager, to provide the data federation. For data access tools, we use DB2 Command Center, Server Studio JE for Informix, and Brio Explorer to show data federation in action. With the combined functionality of the Informix and DB2 database management systems and the DB2 Information Integrator, you can implement a very powerful federated data management environment. Informix customers will be well positioned to take advantage of the expanded capabilities for integration through data federation, as well as future enhancements.