AWS Services Provide Advanced Monitoring and Analytics of tcVISION’s Mainframe CDC Processing

by Joseph Brady, Director of Business Development and Cloud Alliance Leader at Treehouse Software, Inc.

Many Treehouse Software mainframe modernization customers have requirements for continuous near-real-time replication of mainframe data in order to keep a copy of the data synchronized on the Cloud. These customers are using tcVISION from Treehouse Software for changed data capture (CDC) for this synchronization, which allows changes occurring in any mainframe application data to be tracked and captured, and then published to a variety of AWS targets, including Amazon Simple Storage Service (S3). Some of these customers are also now asking us to recommend the best Cloud-based tools and methods to monitor and gain insights to these complex data processes. Coincidentally, while working with a current tcVISION customer, our technicians are testing out two particularly good, fully managed AWS services that can work hand-in-hand to address this need:

Amazon Athena

Since tcVISION supports Amazon S3 as a target, customers modernizing their mainframe systems on AWS can use Amazon Athena for monitoring and analysis of CDC processing from an S3 bucket.

Amazon Athena is a serverless, interactive analytics service built on open-source frameworks, supporting open-table and file formats. Athena provides a simplified, flexible way to analyze data from an S3 Bucket, as well as many other data sources, including on-premises data sources or other Cloud systems. Athena is built on open-source Trino and Presto engines and Apache Spark frameworks, with no provisioning or configuration effort required.

Figure 1: Example of an Athena query showing bulk-load statistics per table

Amazon QuickSight

Once Athena is setup for monitoring an S3 Bucket, users can easily view their CDC processing and analytics with Amazon QuickSight. QuickSight utilizes advanced machine learning-powered insights and intuitive dashboards, so end users can make the best and quickest data-driven business decisions.

Figure 2: Example of Amazon QuickSight monitoring the throughput of our data to Snowflake

Figure 3: Example of Amazon QuickSight pie chart showing the resulting rows loaded for each Snowflake table:

Figure 4: Example of Amazon QuickSight chart showing statistics for our data bulk-load into Snowflake:

Figure 5: Example of Amazon QuickSight chart showing our load time into Snowflake per table:

View the Amazon QuickSite video here…

---

Interested in seeing a live, online demo of tcVISION?

Just fill out the Treehouse Software tcVISION Demonstration Request Form and a Treehouse representative will contact you to set up a time for your online tcVISION demonstration.

---

Enterprises with Vast Amounts of Data on Mainframe Systems are Perfectly Positioned to Take Advantage of Advanced Cloud-based Machine Learning and AI Technology

by Joseph Brady, Director of Business Development and Cloud Alliance Leader at Treehouse Software, Inc.

Machine learning and artificial intelligence (AI) are not only revolutionizing the computing and business worlds, but the value proposition for Treehouse Software’s customer base who are replicating large amounts of mainframe data on the Cloud can be profound. Machine learning is proving to be a powerful force in improving customer experience, optimizing business operations, and accelerating innovation. This powerful, predictive technology helps improve customer engagement and conversion by creating personalized web experiences that are based on individual customer preferences and behaviors. Intelligent machine learning search services also boost business productivity and customer satisfaction by delivering accurate and useful information faster from various information sources across the organization. Additionally, business forecasting machine learning and AI tools can accurately predict demand and streamline supply-demand decisions by combining historical time series data with additional variables, such as product features, pricing, and holiday demand.

Treehouse Software is partnered with AWS, Google Cloud, and Microsoft, and has been in the mainframe market space since 1982. Our tcVISION product helps customers replicate their mainframe data, in real-time and bi-directionally, between a vast array of source databases and Cloud technologies. As soon as their mainframe data is made available within Cloud-based data stores, customers can use the wide variety of available machine learning and AI technologies.

Machine Learning and AI technologies are available at your fingertips… 

The dominant Cloud platforms are making incredible leaps in creating the most sophisticated AI tools available today — all literally at one’s fingertips. Never before has such powerful and useful technology been so easily available to so many, bringing the deepest set of machine learning services and supporting Cloud infrastructures instantly into the hands of developers, data scientists, etc. The following are a few examples of today’s most popular Cloud-based tools…

Some examples of leading machine learning and AI product available on AWS:

• Amazon SageMaker – A fully managed service that provides every developer and data scientist with the ability to build, train, and deploy ML models at scale.
• AWS pre-trained AI Services – Provide ready-made intelligence for your applications and workflows.
• More information on AWS AI and Machine Learning products

Some examples of leading machine learning and AI product available on Google Cloud:

• Vertex AI – Build, deploy, and scale machine learning models faster, with pre-trained and custom tooling within a unified AI platform.
• Recommendations AI – Deliver highly personalized product recommendations at scale.
• More information on Google Cloud AI and Machine Learning products

Some examples of leading machine learning and AI product available on Microsoft Azure:

• Automated machine learning – Automatically build machine learning models with speed and scale.
• Machine learning operations (MLOps) – Azure Machine Learning capabilities that automate and accelerate the machine learning lifecycle.
• More information on Microsoft Azure AI and Machine Learning products

---

The Journey Begins with Treehouse Software

Treehouse Software is here to help enterprise mainframe customers accelerate digital transformation and successfully leverage Hybrid Cloud initiatives on the IBM Z platform, storing sensitive data on a private cloud or local data center and simultaneously leveraging robust machine learning and AI resources on a managed public cloud.

tcVISION supports a vast array of integration scenarios throughout the enterprise, providing easy and fast data replication for mainframe application modernization projects. This innovative technology offers comprehensive abilities to identify and capture changes occurring in mainframe and relational databases, then publish the required information to an impressive variety of targets, both Cloud and on-premises.

Just fill out the Treehouse Software Product Demonstration Request Form and a Treehouse representative will contact you to set up a time for your online tcVISION demonstration.

---

Further reading: tcVISION Mainframe-to-AWS data replication is featured on the AWS Partner Network Blog…

The AWS Partner blog talks about tcVISION’s Mainframe-to-AWS data replication capabilities, including a technical overview, security, high availability, scalability, and a step-by-step example of the creation of tcVISION metadata and scripts for replicating mainframe Db2 z/OS data on Amazon Aurora. Read the blog here: AWS Partner Network (APN) Blog: Real-Time Mainframe Data Replication to AWS with tcVISION from Treehouse Software.

Treehouse Software helps Mainframe Customers Replicate Data on the World’s Fastest Cloud Data Warehouse — Amazon Redshift

by Joseph Brady, Director of Business Development / AWS and Cloud Alliance Lead at Treehouse Software, Inc.

Treehouse Software is an AWS Technology Partner, and has been a mainframe software company since 1982, and in the data replication and migration market space since the mid-1990s. Today, Treehouse Software is helping enterprise mainframe customers successfully move their data to the Cloud in order to utilize all of the most advanced Cloud services and tools available. Our tcVISION product can help customers replicate their mainframe data, in real-time and bi-directionally, between a vast array of source databases and many AWS Cloud technologies, including Amazon Redshift, the world’s fastest cloud data warehouse today.

Highly concurrent workloads? Not a problem. Redshift can handle virtually unlimited concurrency. Amazon Redshift’s hybrid architecture enables unmatched performance…

Shared storage provides the ability to scale to unlimited concurrency, while Redshift’s on-instance storage provides low latency access to data that can’t be achieved any other way. The unique combination of both strategies provides Redshift’s best-in-class performance today and leaves room for continued performance improvements tomorrow.

Scale quickly and automatically to handle unpredictable workloads…

Start small at $0.25 per hour and scale up to terabytes or petabytes for under $1,000 per terabyte per year. Pay only for what you use and know how much you’ll spend with predictable monthly costs. That’s 75% less expensive than the #2 cloud data warehouse provider.

---

Further reading: tcVISION Mainframe-to-AWS data replication is featured on the AWS Partner Network Blog…

AWS recently published a blog about tcVISION’s Mainframe-to-AWS data replication capabilities, including a technical overview, security, high availability, scalability, and a step-by-step example of the creation of tcVISION metadata and scripts for replicating mainframe Db2 z/OS data to Amazon Aurora. Read the blog here: AWS Partner Network (APN) Blog: Real-Time Mainframe Data Replication to AWS with tcVISION from Treehouse Software.

---

Contact Treehouse Software for a Demo Today…

No matter where you want your mainframe data to go – the cloud, open systems, or any LUW target – tcVISION from Treehouse Software is your answer.

Just fill out the Treehouse Software Product Demonstration Request Form and a Treehouse representative will contact you to set up a time for your online tcVISION demonstration.

Treehouse Software Helps Mainframe Customers Easily Access the Most Advanced AWS Machine Learning and AI Tools

by Joseph Brady, Director of Business Development / AWS and Cloud Alliance Lead at Treehouse Software, Inc.

Wow! Machine Learning and Artificial Intelligence (AI) are not only being “disruptive” to the computing and business worlds, but the value proposition for Treehouse Software’s customer base (those with mainframe systems) who are moving large amounts of data to the Cloud can be profound. The dominant Cloud platform today is AWS, and they are making incredible leaps in making the most sophisticated AI tools available, literally at one’s fingertips. Never before has such powerful and useful technology been so easily available to so many.

We have lots of mission-critical data on our mainframe system, and we want take advantage of the latest in Machine Learning and AI too!

Treehouse Software is an AWS Technology Partner, and has been in the mainframe market space since 1982. We are here to help enterprise mainframe customers successfully move their data to the Cloud in order to utilize all of the most advanced Cloud services and tools available. Our tcVISION product can help customers replicate their mainframe data, in real-time and bi-directionally, between a vast array of source databases and many AWS Cloud technologies for analytics, global database deployment, forecasting, machine learning, security, storage, etc.

Take a look at some of the world-changing AWS Machine Learning and AI technologies that are available once your enterprise data is in the Cloud… 

AWS is focused on solving some of the toughest challenges that hold back machine learning from being in the hands of every developer. Amazon SageMaker provides every developer and data scientist with the ability to build, train, and deploy machine learning models quickly. Amazon SageMaker is a fully-managed service that covers the entire machine learning workflow to label and prepare your data, choose an algorithm, train the model, tune and optimize it for deployment, make predictions, and take action. Your models get to production faster with much less effort and lower cost.

Use your company’s data for time-series forecasting

Based on the same technology used at Amazon.com, Amazon Forecast uses machine learning to combine time series data with additional variables to build forecasts. Amazon Forecast requires no machine learning experience to get started. You only need to provide historical data, plus any additional data that you believe may impact your forecasts.

With Amazon Forecast, you can achieve forecasting accuracy levels that used to take months of engineering in as little as a few hours. You can import time series data and associated data into Amazon Forecast from your Amazon S3 database. From there, Amazon Forecast automatically loads your data, inspects it, and identifies the key attributes needed for forecasting.

---

Further reading: tcVISION Mainframe-to-AWS data replication is featured on the AWS Partner Network Blog…

AWS recently published a blog about tcVISION’s Mainframe-to-AWS data replication capabilities, including a technical overview, security, high availability, scalability, and a step-by-step example of the creation of tcVISION metadata and scripts for replicating mainframe Db2 z/OS data to Amazon Aurora. Read the blog here: AWS Partner Network (APN) Blog: Real-Time Mainframe Data Replication to AWS with tcVISION from Treehouse Software.

---

Contact Treehouse Software for a Demo Today…

No matter where you want your mainframe data to go – the cloud, open systems, or any LUW target – tcVISION from Treehouse Software is your answer.

Just fill out the Treehouse Software Product Demonstration Request Form and a Treehouse representative will contact you to set up a time for your online tcVISION demonstration.

Treehouse Software Technology Partner, Cognistx Brings Cognitive Computing to Screens Around the World

Cognistx is transforming the customer buying experience using cognitive computing, which it claims has the potential to become the most disruptive technology of the next 20 years. Wake Forest Innovation Quarter’s The Hub features the latest from Cognistx. Read the article here.

---

About the Treehouse Software / Cognistx Partnership

Since the mid-1990s, Treehouse Software has provided world-class enterprise data acquisition capabilities, and we now offer the Cognistx cognitive computing capabilities for the most advanced interaction with your customers.

The Cognistx platform complements Treehouse Software’s tcVISION, the comprehensive product that can acquire data in bulk or via change data capture methods, including in real time, from virtually any IBM mainframe data source (Software AG Adabas, IBM DB2, IBM VSAM, IBM IMS/DB, CA IDMS, CA Datacom, even sequential files), and transform and deliver to virtually any target. In addition, the same product can extract and replicate data from a variety of non-mainframe sources, including Adabas LUW, Oracle Database, Microsoft SQL Server, IBM DB2 LUW and DB2 BLU, IBM Informix and PostgreSQL.

If this exciting new technology is of interest to you, we would be happy to have a conversation about your company’s needs, so do not hesitate to contact us if you have questions.  Meanwhile, please visit the Treehouse Software Cognistx Web Page for more information.