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 IDE, 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, whether in batch or real-time
- 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 Voracity data management platform which includes them) to do that, and to mask personally identifiable information (PII) at the same time.*
Replicate multiple sources (like relational or NoSQL DB tables) at once, output to multiple schemas or other targets, or perform manipulations along the way like:
- 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
You can perform and combine the above tasks into one or more jobs defined in fit-for-purpose wizards and ETL workflows in Voracity. Run these transformations jobs on the fly during replication in Voracity, and as data masking scripts that run alongside DB cloning operations in Windocks, Commvault or Actifio, for example.
Use the IRI Ripcurrent real-time facility to refresh MS SQL, MySQL, Oracle, and PostgreSQL when rows are inserted, updated or deleted.
Otherwise, you can also insert event-driven triggers ahead of the jobs, or filter on timestamp or ID column values to replicate only the newer rows, as in that example between Oracle and MongoDB.
Design, run, and manage all these data mappings in in the free IRI Workbench IDE for Voracity et al, built on Eclipse. 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.