Next Webinar on Sept. 22: How Nedbank Connected Their Mainframe to the Cloud with Model9 & Microsoft Azure
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.
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.
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.
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