IRI software helps you rapidly and affordably manipulate, and synchronize data from heterogeneous data sources so you can use regular, fresh copies of data for testing, reporting, or other applications.
Replicate huge amounts of relational database, mainframe datasets, flat files, and other sequential data sources in real-time, or in batch, using software in the IRI Workbench GUI, built on Eclipse™.
Whatever data replication method you choose with IRI, it will be:
- scalable in volume (via multi-threading and task and I/O consolidation)
- database- and platform-agnostic
- reliable in terms of data (and referential) integrity
- functionally flexible
- less expensive and easier-to-use than replication software like GoldenGate
Do you have a single source of data to re-cast in another format? To copy the data in a non-relational COBOL index file to a CSV file for Excel or other relational target, use IRI NextForm to convert the file format. See this basic example.
Do you have a simple replication set, or database subset you need to acquire and transmit to other users? Use IRI CoSort or IRI FieldShield (or the larger IRI Voracitiy platform) to do that, and mask personally identifiable information (PII) at the same time.*
To replicate multiple sources (like relational or NoSQL DB tables) at once, output to multiple schemas or other targets, perform manipulations along the way, such as,
- de-duplication and selection
- splitting, merging data elements
- cleansing, enrichment and validation
- change data capture
- normalizing or de-normalizing
- sorting, joining, and aggregation
- data masking, encryption, and so on
use traditional ETL patterns in the IRI Voracity data integration and management platform. Add and combine these transformations during data replication. Insert event-driven triggers ahead of the jobs, or filter on timestamp or ID column values to replicate and refresh only the newer rows (clone).
Design, run, and manage the mappings in (and versions of) these projects. Deploy the resulting, self-documenting job scripts on any platform. Send the results directly to your targets, federation sources, or a replication server.
You can even use the output mappings you create to auto-define new table metadata and load utility configuration files to populate your targets with pre-sorted data.
*To provide test data in any format without accessing or replicating production data, use IRI RowGen.