DataFlux® Federation Server
Creates a virtual data layer for easy data access, administration, security and improved performance
Growing data sources and data management problems are issues that all industries must deal with. Data federation should be considered for any organization with data warehousing, data virtualization or data governance initiatives. Through the use of federation, organizations can achieve better, faster and consolidated data access without having to worry about data movement. DataFlux Federation Server is designed for those looking to centralize and streamline their data presentation strategy with minimal disruption to existing data and business operations.
If your organization has a large number of data sources and is manually employing a data integration strategy, federation provides a more astute option because it reduces administration and provides a modular approach to data management. It also offers faster, more centralized access to data that is needed for business analysis and reporting.
Benefits
- Provide consistent access to multiple data sources.
- Ease data maintenance and administration.
- Parse security to different users through different sources.
- Retrieve data quickly from all underlying data sources.
Features
- Unification of data sources to provide a single data virtualization layer
- Centralized administration, configuration and monitoring
- Improved performance for data access
- Granular data security settings and centralized auditability
How SAS® Is Different
- Centralized data administration and configuration. Customers do not have to deal with numerous permutations and combinations of user access and privileges to information located throughout an organization.
- Provides a federated view of data sources. With DataFlux Federation Server, users have the ability to access multiple data sources in the same connection. Data from heterogeneous data sources can be accessed and combined in a single virtual layer, and presented with minimal impact on the underlying data sources.
- Granular and role-based data security settings. With DataFlux Federation Server, data architects can easily define access permissions for a user or group of users. This allows for a nuanced security model.
- Broad application access support. With support for JDBC and ODBC third-party application access and support for additional data sources, including Aster, Greenplum, IBM Netezza, Sybase IQ and any ODBC driver, you can include all your data sources in a single federated view and provide users with the most current information.
Benefits
- Provide consistent access to multiple data sources. DataFlux Federation Server provides a virtual data layer that helps improve access to multiple data sources. It provides a unified view of various data sources through a single connection and eliminates the need to create an access strategy for each data source. This helps reduce performance bottlenecks that can lead to information latency.
- Ease data maintenance and administration. DataFlux Federation Server provides a Web-based console that makes it easy to graphically administer, monitor and maintain connections and data caches. Without it, administrators typically have an administration console for each system that maintains users' details, but the different systems cannot interact with each other at any level.
- Parse security to different users through different sources. With granular security and centralized auditability capabilities, role-based access to sensitive data can be provided to different types of users throughout an organization.
- Retrieve data quickly from all underlying data sources. The ability to create cached data queries that can be used to prepopulate widely used data in specified intervals ensures data freshness without latency and prevents performance hits to source systems during peak times.
Features
- Unification of data sources to provide a single data virtualization layer
-
- Create federated data source names (DSNs), which allow users to access multiple data sources in the same connection.
- Access third-party applications in a federated environment using JDBC and ODBC drivers.
- Centralized administration, configuration and monitoring
-
- Use the Federation Server Manager, a Web-based console for easy maintenance of user access privileges.
- Easily create materialized views with a GUI query builder.
- Manage and schedule data cache refreshes with a specialized scheduler.
- Easily enable or disable data caches.
- Monitor the current and historical status of all sessions connected to DataFlux Federation Server.
- Improved performance for data access
-
- Support data caching of materialized views to improve application query performance.
- Pool connections between the DataFlux Federation Server and source data systems.
- Use statement pooling from the DataFlux Federation Server JDBC driver.
- Granular data security settings and centralized auditability
-
- Define access permissions for a user or group at the catalog, schema, table, column and row level.
- Provides support for definer's rights views.
- Provides support for user and group functions.
Screenshots
Timed and ad hoc cache refreshes keep data in the virtual layer current.
Timed and ad hoc refreshes of caches keep the data in the virtual layer current and up to date.
Parse out row-level security using filters and viewing rights for a robust security model.
DataFlux Federation Server can parse out row-level security using filters and viewing rights for user groups, creating a robust security model for sensitive data within your organization.
Easily maintain and build virtual tables from different sources with the SQL Console.
The SQL Console within the DataFlux Federation Server can help easily maintain and build virtual tables from connections to different sources.
System Requirements
Host Platforms
- HP/UX on Itanium: 11iv3 (11.31 update 5 and above)
- IBM AIX on POWER architectures: 6.1 and 7.1
- Linux x64 (64-bit): Novell SuSE 10 Service Pack 3 or higher; Red Hat Enterprise Linux 5 and 6
- Microsoft Windows (32-bit): Windows XP Professional, Windows Vista*, Windows Server 2003 family, Windows Server 2008 family
- Microsoft Windows on x64 (64-bit): Windows XP Professional for x64, Windows Vista* for x64, Windows Server 2003 family for x64, Windows Server 2008 family for x64
- Solaris on x64 (x64-86): Version 10 or higher
* NOTE: Windows Vista supported editions are: Enterprise, Ultimate and Business.
Ready to learn more?
Call us at 1-800-727-0025 (US and Canada) or request more information.
