Learn more

Data Transformation and Integration with BI & Analytics

Model9 makes it easy to transform and integrate mainframe data with your data lake and cloud-based BI & analytics applications.

Model9 transfers mainframe data to object storage in the cloud and then transforms it into open formats for use in cloud applications. It is the only solution that eliminates proprietary data silos without consuming mainframe CPU or requiring changes to your mainframe applications.
Model9 | Diagram | Data Transformation & Integration for BI & Analytics
Integrate your Data with Cloud-Native BI Applications

Model9’s ability to quickly transfer, transform, and integrate your mainframe data allows you to add it to your data lake and use it in BI/ML/AI cloud applications. Eliminate performance bottlenecks and put your data to work at the rhythm of your business, instead of the other way around.

Use ELT to Process Data Faster, at Scale

Traditional ETL-dependent processes required picking data sets one at a time. Model9 uses zIIP to queue data for transfer over TCP/IP into the cloud. This speeds data extraction and transformation, making the processes highly scalable.

Transformation is Done in the Cloud - Without Consuming Mainframe MIPS

Model9 uses ELT (extract, load, transform) architecture to deliver mainframe formatted data to object storage in the cloud, and then transform it via the target platform. In contrast, the antiquated ETL (extract, transform, load) approach uses mainframe CPU processing to transform data into open formats first, and then moves it into the cloud.

Get Huge Performance Gains over Change Data Capture Tools

Change Data Capture (CDC) tools focus on replicating updates primarily in databases. Model9 does not impact online or batch windows, and directly delivers and transforms both live data from disk and historical data on tape in the cloud.

Mainframe data sources include:
DB2 image copy, VSAM data sets, Sequential data sets, Partitioned data sets, Extended format data sets

Target cloud formats and services include:
JSON, CSV, XML file formats, Amazon Athena, Aurora, QuickSight and Redshift, Microsoft Azure HDInsight and SQL Data Warehouse, Google BigQuery and BigTable, Snowflake, Apache Spark, Hadoop, Splunk

Solution Benefits
Monetize unlocked mainframe data by integrating it with cloud-based BI and analytics
Accelerate and scale mainframe data transformation projects
Reduce mainframe MIPS charges with modern ELT methods
Improve on CDC tools
Register for a Demo