Data Federation / Virtualization
Get information from different sources immediately
Data Federation virtualizes and integrates disparate data sources to create immediate, fit-for-purpose views of information. Data Federation bypasses the normal ETL overhead of physical data consolidation, replication, and relational database population.
„If users simply need unified, near real-time on-demand access to data originating from many source applications, then data federation is an attractive alternative. Information and Knowledge Management (IKM) professionals should also consider data federation as a complementary approach that can extend and enrich their current EDW environment.“
Forrester Research
IRI's philosophy of simplification and cost-efficiency is clearly evident in its approach to Data Federation. Without requiring complicated infrastructures, users can quickly access and process heterogeneous data. Whether through SQL queries or tactical scripting, the system's flexibility enables a wide range of use cases. With integration into the Eclipse-based IRI Workbench, a seamless and intuitive user experience is ensured. Data Federation The platform particularly optimizes the federated processing and analysis of data. Functions like „what-if“ analyses provide useful insights in real-time without the need to tie up memory resources. Data Federation also enables flexible data transformation and cleansing, thereby maximizing data quality and usability. These capabilities make it an indispensable tool for modern businesses, especially for those that need to make fast and precise data-driven decisions. With IRI's solutions, organizations benefit from high efficiency and user-friendliness. The ability to integrate and analyze both structured and unstructured data sources makes this approach a versatile and future-proof choice for companies of all sizes.
IRI's approach to abstraction and utilization of heterogeneous sources is unconventional, simple, and very affordable. There are no additional costs for the IRI Voracity platform or the users of IRI Data Management Suite, to create ad hoc information from isolated data sources. And if you have the lite version of IRI NextForm The software to create an ad-hoc data view from flat files is free. Affordable versions of NextForm and IRI CoSort also support database connections.
Instead of creating new middleware, a federated database, or an application layer, data federation occurs in the same place that ETL and BI do – in the IRI Workbench GUI, which is based on Eclipse™.
Get discrete solutions and generate immediate information through SQL queries, or create custom CoSort SortCL programs, to filter, merge, standardize, and report from disparate DB and flat file sources. Define new schemas, master data values, format masks (composite data types), and custom report destinations in multiple SortCL outputs simultaneously. Send results to the console or temporary tables to perform unsaved „what-if" analyses.
IRI's data federation approach also supports:
Simple detection of table and file data, with automatic metadata creation
An agile query environment that enables „what-if analyses“ and iterations.
Fast results through tactical scripting and big data movement power
· Useful BI through cross-calculation, functions, and derived fields
· Protection of source or abstracted data through field masking, encryption, etc.
Data quality through enrichment, cleansing, and third-party libraries
· Standard and complex field-level data transformations
„Data-less“ test data generation with original or federated metadata
· Ad-hoc data contributions to ETL tools and analytics platforms
· Population of federated data to data services (in development)
Unification of processing and information
Read the B herelog

Click here to see an example of how you can quickly and easily merge data in the IRI Workbench with one of the backend engines mentioned above.