MyDataFlux Portal
The DataFlux Approach|The Data Roundtable|News & Events|About Us|Contact

DataFlux Federation Server

Fast, on-demand data access and data integration

DataFlux provides integrated views of data located in multiple repositories without the need to physically consolidate the data. This virtual integration enables powerful querying capabilities, as well as improved source data management. Data federation efficiently joins data from many heterogeneous sources, without moving or copying the data. The result is improved performance and speed, while reducing costly and labor-intensive data movement and consolidation.

An Integrated View from Multiple Data Sources

DataFlux Federation Server enables organizations to view data from multiple sources through an integrated, virtual data view. While the data remains stored in its source application, multiple users can see integrated data – without physically moving or changing data. The data appears as if it were physically integrated in one place, either as a table, file or web call.

Federated data capabilities available in DataFlux Federation Server include:

  • A central location for setup and maintenance of database connections
  • Access to common database systems, including Oracle, DB2, Teradata, SQL Server and MySQL
  • TCP/IP server access
  • ODBC and native drivers to connect to data sources
  • Access permission that allows only specific users to access and control data
  • Ability to reference data from disparate data sources with a single query; DataFlux Federation Server also includes its own SQL syntax to provide consistent functionality – independent of the underlying data source
  • Creation of a layer of abstraction over physical data that can be stored in any data source
 

Benefits

Information-driven organizations need to access and query data from multiple sources, and provide users with a single view as necessary. By creating a virtual data layer, the resulting view serves as a single data store for management and analysis. A federated data view enables demand-driven access to operational data, transactional data, data warehouses and other sources of information.

  • Reduce IT costs with support for various database vendors, web service standards and other sources
  • Lower development and maintenance costs by developing the integrated view once – and using that view many times from a single location
  • Gain real-time access to operational data
  • Reduce analyst time by interfacing with a single virtual store without the need to make infrastructure changes
  • Query data that exists in multiple systems, without requiring cumbersome and costly data movement or replication
  • Optimize query response time as a result of the improved workload management
  • Create a single and uniform data view within DataFlux Data Management Platform
 


Customer

Success

Global Oil and Gas Company Standardizes Product Data to Fuel Global Data Warehouse

With DataFlux, this company achieved a more accurate view of corporate information that could help them make better decisions.

White Paper

Data Profiling, Data Integration and Data Quality: The Pillars of Master Data Management

This white paper by David Loshin, published in association with the Business Intelligence Network, shows how data profiling, data integration, and data quality can build a stable framework for master data management.

Customer

Success

International Resort Company Chooses DataFlux to Standardize, Cleanse and Integrate Customer Data

An international resort company that handles millions of customer reservations annually used DataFlux technology to improve data quality and household customer information.

White Paper

Data Migration Handbook for Business Leaders

This guidebook by Dylan Jones provides simple, tried and tested techniques that will help business leaders fully understand their pivotal part in delivering a successful data migration project.