InfoSphere Federation Server

IBM® InfoSphere® Federation Server creates a consolidated view of your data to support key business processes and decisions.

Access and integrate diverse data and content sources as if they were a single resource - regardless of where the information resides.

• Combine data from disparate sources such as DB2, Oracle, and SQL Server into a single virtual view
• Access, join, and manipulate data of different formats such as relational, mainframe, and XML from the same interface
• Interface with standard SQL tools, development environments, portals and other standard IT infrastructure components
• Incorporate data from multiple sources such as up-to-the-minute inventory, sales, and customer information into reports and analytics with a single query
• Insert, delete, or update multiple data sources simultaneously no matter where the information is located
• Implement security policies throughout the unified view of the enterprise.
• Enable hybrid data warehousing by collating up-to-date information from production systems with historical information from enterprise data warehouses

View features and benefits

Learn more

• More product details (US)

Buy InfoSphere Federation Server

MoreLess

• Gain virtualized real-time access to disparate data sources

• Speed time to market for new projects

• Access more data sources like IBM Netezza Data Warehouse Appliances. This means less data needs to be returned to InfoSphere Federation Server from IBM Netezza appliances and more functions can be performed directly by IBM Netezza appliances instead of InfoSphere Federation Server

• Extend your warehouse or mart with remote data

• Build holistic, unified financial, customer, or product views

• Federated two-phase commit - enables you to maintain data integrity and accuracy by allowing the update of multiple data sources simultaneously within a distributed system

• Federated stored procedures - allows you to avoid redundant and unnecessary development costs by leveraging previously developed procedures for heterogeneous data sources

• Cost-based distributed query optimization - dynamically enhances queries for high performance

• Federation Server set up and maintenance - is reduced because nicknames do not need to be created when three-part name syntax compatible with Oracle dblinks is used

• XML support - enables transparent integration of XML data, from DB2 TrueXML and XML files, with SQL data from data sources allowing users to create simpler view of their information infrastructure, reduce programming costs and quickly deliver information to end users

• Power security strategies - implemented throughout the unified view of the enterprise for secure federated query and federated updates processing

• SQL-based access paradigm - enables federation across a wide range of data and content sources

• Application program interface (API) - addresses the business needs of companies that require federated access to unstructured data sources

• Easier integration of data source clients : greatly simplifies the process of configuring InfoSphere Federation Server for use with data source clients

• Supports IBM Netezza data sources and IBM InfoSphere BigInsights

• Learn about the benefits of a hybrid data warehousing environment for maximum flexibility using IBM InfoSphere Federation Server

• V9.7
• V9.5