IRI Data Manager
The IRI Data Manager suite bundles the tools you need for faster data manipulation and movement:
1) CoSort makes light work of big data processing "heavy lifts" in DW ETL, BI/analytics, DB loads, sort/merge offload, etc.
2) FACT dumps very large database (VLDB) tables in parallel to flat files for ETL, DB migration, reorg, and archive.
3) NextForm performs and speeds file and table conversion, remapping, DB replication, data re-formatting, and federation.
4) RowGen subsets DBs or synthesizes structurally and referentially correct test data in tables, files, and reports.
These IRI products address data integration and staging (ETL/ELT), big data packaging and provisioning, BI reporting and data wrangling (preparation) and DevOps. Use them alone or in the IRI Voracity platform to: improve data quality; speed sorting and data transformation; migrate and replicate data; replace legacy sorts; and, synthesize (plus virtualize) smart RDB and file test data.
Learn more
Database X-Ray
Database X-Ray is a must-have SQL Server utility that allows the viewing of all database objects in a tabular format, and shows relationships between each object, including objects referenced by a given object, as well as objects that reference that object. This includes Tables, Views, Stored Procedures, Functions, and Triggers, allowing you to see at a glance what will be affected by deleting or changing an object in your database. (You won't get that from a database diagram!) In addition, you can view the DDL (Data Definition Language) or code that created each object, copy it to the clipboard, and use it in any way you like. All you need to get started is a valid connection string to a database that can be accessed from wherever you install Database X-Ray, whether local or remote. Works with Azure SQL Database too!
Learn more
Amazon RDS
Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while automating time-consuming administration tasks such as hardware provisioning, database setup, patching and backups. It frees you to focus on your applications so you can give them the fast performance, high availability, security and compatibility they need. Amazon RDS is available on several database instance types - optimized for memory, performance or I/O - and provides you with six familiar database engines to choose from, including Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle Database, and SQL Server. You can use the AWS Database Migration Service to easily migrate or replicate your existing databases to Amazon RDS.
Learn more
IRI NextForm
IRI NextForm converts and replicates database data and schema, and modernizes file formats and layouts so they can be used in new applications. NextForm also creates federated views to speed insights.
NextForm also gives you the opportunity to cull data as you move it, optimizing I/O and reducing storage. Slash 75% off design and run time with point-and-click field mapping that help you control your data with ease.
NextForm is one of several data management products front-ended in a free Eclipse IDE, and another metadata-compatible spinoff from the SortCL program in IRI CoSort,
NextForm comes in several editions, including a FREE Lite version for converting field data types, record layouts, and many flat-file formats, and for creating basic reports from flat files.
Learn more