Federation Server

IBM® InfoSphere® Federation Server creates a consolidated view of your data to support key business processes and decisions which means you can access and integrate diverse data and content sources as if they were a single resource – regardless of where the information resides.

What Does It Do?

  • IFS is IBM’s market-leading data federation tool which allows you to 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
  • Extend your data visualization solution, when connected to InfoSphere Information Services Director, by adding to provide reusable services for Information as a Service and SOA
  • 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 combining data replication and data federation. Frequently used data is replicated into the warehouse. The warehouse’s reach is then extended with data federation
  • Extend DB2 pureScale to be a federated database server. This lets all data sharing members process federated SQL

How Does It Do It?

  • 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 allow 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

Why Is That Useful?

  • It means you gain virtualised 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