Enterprise Mainframe Systems House Vast Amounts of Data, Perfectly Positioned to Take Advantage of Powerful and Innovative, Cloud-based Services

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

Treehouse Software has been helping enterprises since 1982, and our extensive experience, deep knowledge, and wide-ranging capabilities in mainframe technologies makes us a valued partner and a trusted advisor to customers worldwide. In recent years, we have begun developing a strong presence in the emerging Cloud market space relating to mainframe data migration.

BinaryWave

Cloud providers are aware that most large enterprises use mainframe systems housing vast amounts of data encompassing historical, customer, logistics, etc., and they are helping us bring our tcVISION Mainframe-to-Cloud data replication and migration solution to the Cloud marketplace. Sales leaders within various verticals at Cloud companies and systems integrators are also engaging with Treehouse Software to take advantage of our unique skills and solution to help them tap into this potential goldmine of data that needs to be moved to the Cloud.

tcVISION_Overall_Diagram_General_Cloud

With tcVISION, customers can replicate mission critical data to the Cloud, and immediately take advantage of the broadest and deepest set of capabilities, including artificial intelligence (AI), machine learning, Internet of things (IoT), predictive data analytics, high performance and security, high availability across global regions, scalability, and innovation. Imagine being able to spin up a functional and secure databases anywhere in the world — in minutes! Also imagine having the most advanced technologies available for data processing, interactive analytics, real-time analytics, operational analytics, dashboards, and data warehousing at your fingertips!

Where is your mission critical data residing?

Most larger industry verticals recognize the need to tie together many disparate data sources within their IT environment, including their long-standing mainframe data.  Treehouse Software’s tcVISION solution focuses on changed data capture (CDC) when transferring information between mainframe data sources and target databases and applications. Through an innovative technology, changes occurring in any mainframe application data are tracked and captured, and then published to a variety of targets. tcVISION provides the means for customers to easily replicate relevant data from most mainframe data sources (IBM Db2, IBM VSAM, IBM IMS/DB, Software AG Adabas, CA IDMS, CA Datacom, or even sequential files) to Cloud targets, including AWS, Microsoft Azure, Oracle Cloud, as well as many more seen here… 

___tcVISION_Sources_Targets

tcVISION’s Control Board is a Windows Graphical User Interface (GUI) that allows users to configure the replication stream between the mainframe and various Cloud platforms. Using the Control Board and built-in wizards, users can define the metadata and mappings between the mainframe and a Cloud database target.

tcVISION automatically defines the mappings between the source and target. tcVISION’s Metadata Import Wizard creates a default mapping that handles data type conversion issues, such as EBCDIC to ASCII, Endianness conversion, codepages, redefines datatypes, and more. See mapping example below:

Maintaining_tcV_Repository

CDC replication is initiated from the tcVISION Control Board, and the mainframe communicates to the Cloud-based tcVISION replication manager. The tcVISION Control Board shows a graphical representation of the replication, seen in the example below:

CDC_tcV_Control_Board

Video: Walkthrough of tcVISION Mainframe Data Replication to Cloud and Open Systems in 90 Seconds…


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

___tcVISION_AWS_HA_Architecture

AWS recently published a blog about tcVISION’s Mainframe-to-Cloud data replication capabilities:

AWS Partner Network (APN) Blog: Real-Time Mainframe Data Replication to AWS with tcVISION from Treehouse Software.


__tsi_logo_400x200

Contact Treehouse Software 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 is Helping to Put the Automotive Industry’s Mainframe Data on a Fast Track to the Cloud

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

__AWS_Automotive

The digital transformation happening in the automotive industry is resonating throughout all divisions, products, and services, with many manufacturers looking for ways to benefit from the vast amounts of data stored on multiple mainframe systems. This extremely valuable data encompasses information on customers, warranties, parts, service, logistics, and much more, so moving it to the Cloud for access by the latest and most powerful analytics and artificial intelligence (AI) services has become a strategic imperative.

Using the most advanced Cloud technologies, companies can unlock actionable insights to help build customer relationships, enable the most immersive and undistracted driving experience possible, and improve global manufacturing and supply chain operational efficiency.

This blog takes a look at how Treehouse Software’s mature and automated mainframe data replication product, tcVISION can help automotive companies move data quickly to Amazon Web Services (AWS). Treehouse Software stands ready to show companies how they can tap into decades worth of valuable data by using tcVISION and our deep mainframe knowledge and experience.

When a company uses tcVISION to replicate mission critical data to the AWS Cloud, they can immediately take advantage of the broadest and deepest set of capabilities, including:

  • AI/ML, IoT, HPC, and predictive data analytics
  • The highest performance and security
  • The largest customer and partner community
  • High availability across global regions
  • Scalability   
  • A relentless pace of innovation

AWS for Automotive…

With AWS, a Data Lake can be easily built and tailored, allowing companies to securely store, categorize, and analyze all of their replicated mainframe data in one, centralized repository. Additionally, companies can access the most comprehensive and advanced set of Industrial IoT, Data Lake, analytics, and machine learning solutions available to connect and manage machines and systems across the global supply chain and generate actionable insights with real-time and predictive analytics capabilities to improve quality and operational efficiency while reducing downtime and cost.

Mainframe-to-AWS Real-time and Bi-directional Data Replication with tcVISION…

tcVISION_Overall_Diagram

The Automotive industry recognizes the need to tie together many desperate data sources within their IT environment, including their long-standing mainframe data residing on IBM Db2, IBM VSAM, IBM IMS/DB, Software AG Adabas, CA IDMS, CA Datacom, or even sequential files.  Treehouse Software’s tcVISION product provides the means for mainframe customers to easily replicate relevant data to AWS. 

The tcVISION solution focuses on changed data capture (CDC) when transferring information between mainframe data sources and AWS databases and applications. Through an innovative technology, changes occurring in any mainframe application data are tracked and captured, and then published to a variety of AWS targets.


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

___tcVISION_AWS_HA_Architecture

Treehouse Software is an AWS Technology Partner, and with AWS and Treehouse Software as their strategic partners, leading automotive manufacturers can become empowered with the knowledge, capabilities, agility, and speed they require to thrive in the new era of mobility.

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.


__tsi_logo_400x200

Contact Treehouse Software Today…

Treehouse Software has been helping mainframe enterprises since 1982, and our extensive experience, deep knowledge, and wide-ranging capabilities in mainframe technologies makes us a valued partner and a trusted advisor to customers.

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 Move Data to 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…

___AWS_RedShift_Architecture

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…

___tcVISION_AWS_HA_Architecture

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.


__tsi_logo_400x200

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.

tcVISION_Overall_Diagram

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’s Differentiator: We’ve Been Helping Enterprise Mainframe Sites Since 1982

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

Treehoue_Mainframe_Experience

This blog explores Treehouse Software‘s decades worth of experience in helping mainframe customers with innovative tools, services, and training. 

When Treehouse Software began in 1982, the business focused on software that was complementary to the Software AG mainframe product line (Adabas database management system and Natural programming language) in the areas of security, control, auditing, performance enhancement, etc.

In more recent years, Treehouse Software has become a global leader in providing solutions for real-time and bi-directional data replication between a variety of mainframe and non-mainframe sources, including (Mainframe): VSAM, IMS, Db2, CA Datacom, Adabas, and CA IDMS; and (Non-mainframe): Amazon Web Services (AWS), PostgreSQL, Oracle, Microsoft Azure, Microsoft SQL Server, IBM Db2 LUW and Db2 BLU, IBM Informix, Kafka, MongoDB, Hadoop, SAP Hana, and many more. Here is our list of supported data sources and targets.

Decades Worth of Mainframe Knowledge…

When asked by prospective customers, “What are your primary differentiators?”, we can be tempted to first talk about superior product features and capabilities, but it is Treehouse Software’s depth of knowledge and experience in the mainframe world that is the real game changer.

Most mainframe users face critical data management challenges due to the complexity and proprietary nature of deeply entrenched databases on the platform. Our extensive experience, deep knowledge, and wide-ranging capabilities in mainframe technologies make the company a valued partner for third-party solution providers and a trusted advisor to customers.

Treehouse Software’s visionary leadership in this market has included pioneering Adabas-to-RDBMS ETL and CDC with tRelational/DPS in the mid-1990s.  Today, Treehouse Software stands alone in its product maturity, and capability, including expanded capabilities with the tcVISION product, which enables migration and synchronization of virtually any mainframe or non-mainframe database or data source.

Despite the rapid pace of change in the IT landscape, Treehouse Software’s customer base can be assured that there remains a strong commitment to providing continued support and upgrades for the product suite.

Treehouse Software provides tools and expertise for the riskiest and most-often overlooked parts of modernization and integration projects – data migration and integration.   Tapping into the vast experience of Treehouse’s technicians, and using proven products and services eliminates reliance on end-customer programming staff to write and maintain data extracts and middleware. Treehouse Software’s know-how reduces cost and mitigates risk in legacy modernization initiatives, where data migration and integration complexity is often underestimated, yet critical to success.

Our Mainframe Experts are Our Best Assets

We are fortunate to have a staff with a wealth of knowledge and skills that span not only Mainframe, but Cloud, LUW, and Open Systems technologies. Whether a customer wants to move data from their mainframe platform to other on-premises open systems or LUW databases, or to the Cloud (e.g., AWS, Azure, etc.), Treehouse Software has the technical expertise and support needed to ensure successful project completion.

Treehouse Software‘s technicians have installed products and trained end-users in some of the largest mainframe sites around the world.  Mature, robust, and reliable, these products are also backed by our highly-rated 24X7 technical support.

The Treehouse Team Approach

TechniciansConnectivity

Treehouse Software has proven its ability to partner and work effectively as part of a larger team to solve client problems.  AWS, Microsoft, Oracle, Accenture, and other large vendors have selected our technology, services, and training for their mainframe data migration and application modernization practices.


__tsi_logo_400x200

Contact Treehouse Software for a Product Demo Today…

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 product demonstration.

Treehouse Software TREETIP: Data Replication for a Mainframe Database that has no Primary Key, using tcVISION

by Joseph Brady, Director of Business Development / AWS and Cloud Alliance Lead at Treehouse Software, Inc. and Chris Rudolph, Senior Technical Representative at Treehouse Software, Inc.

This blog takes a look at tcVISION’s support for a mainframe database that has no primary key at the source (a mainframe primary key is a column, or set of columns that uniquely identifies one row of a table). 

In situations where the source database does not contain any unique values, Treehouse technicians discuss with the customer how the application currently works and their expectations for how the data should be treated when planning replication/migration to a new target environment. Depending on the application, Journal Replication or Data Warehouse Replication may be a better fit than a “normal” RDBMS table definition.

tcVISION‘s Key ID management can be used to create a column to use as the key on the target table. Another option would be to use a SQL Lookup to query another table. Either way, target column(s) that contain unique values will need to be identified. Once these columns are identified, they can be marked with the key identifier, using the tcVISION repository editor, or Key ID Management can be used to create a new unique column, then those columns are used within the wizard.

For example, this source table does not contain a primary key:

___tcV_NoKey01

Analysis of the target data shows the columns FIRST_NAME, LAST_NAME and MIDDLE_NAME together will provide a unique value. These fields can be marked in the tcVISION repository as being members of a key:

___tcV_NoKey02

As mentioned earlier, the tcVISION Key ID Management wizard can also be used to create a new unique target column:

___tcV_NoKey03

Specify the key name:

___tcV_NoKey04

Specify the key value creation:

___tcV_NoKey05

Various options are available: 

___tcV_NoKey06


__tsi_logo_400x200

Contact Treehouse Software for a Demo Today…

tcVISION_Overall_Diagram

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.


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

___tcVISION_AWS_HA_Architecture

AWS recently published a blog about tcVISION’s Mainframe 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.

Treehouse Software Customer Success: Data Replication from Mainframe Adabas to PostgreSQL using tcVISION

BMF_Building

The Bundesministerium der Finanzen (BMF) is Germany’s Ministry of Finance and establishes sustainable fiscal policy that ensures financial empowerment of the federal budget. From tax policy via development of federal budget, to regulation of national and international financial markets – for these and other fiscal and economic questions of principle, the BMF creates strategies and concepts, and implements them. The Federal Tax Administration is part of BMF, and controls not only the cross-border goods traffic, but acts against illegal employment and other crimes. The tax administration also imposes consumer taxes (e.g., energy and tobacco tax, car tax, etc.). Financial relations between federation, countries, and communities are also coordinated by BMF.

Department II (federal budget) is part of the German government in charge of establishing the budget and financial planning of the federation. Throughout the year, it monitors execution of the budget for eventual intervention (e.g., with a budget freeze, or supplementary budget). After closing the fiscal year, the budget and balance sheet will be presented. The budget is a supplement of the budget act, legally binding.

The central service organization of BMF is the Informationstechnikzentrum Bund – ITZBund (Information technic center).

BUSINESS BACKGROUND

Drawing up the budget is a yearly, highly time consuming, and formalized business process. All departments are involved in nearly every sub-process, and budgeting and financial planning is supported by the application, “Haushaltsaufstellung / Budgetgeneration”. Using the generated reports, various addressees/receivers are supported (e.g., German Federal Government, German Federal Parliament, Federal Council of Germany, finance department in BMF, the employees in the departments, and the public).

Technically, the budget plan of the federation is based on technologies, including the IBM Mainframe with z/OS running Adabas and Natural.

The challenge was to provide an environment for employees in all departments that enables them to do their work quickly, easily, and efficiently. In the BMF, users must have an editorless, end-user driven, and real-time creation of ready-to-print products.
An informative description of the workflow is shown on the website of the BMF.

The federal budget is available as download, or one can directly navigate through the data using the online application.

BUSINESS ISSUE

Some time ago, BMF decided to re-engineer the application for budget planning and port it to Open Source. To guarantee a seamless transition, the first step is propagation of data out of Adabas on z/OS to PostgreSQL, concluding with permanent synchronization.
The difficulties of this task are the complexities of setting up data definitions for the data structures in Natural and the propagation of data from Adabas on z/OS to PostgreSQL.

TECHNOLOGY SOLUTION: tcVISION

tcVISION_Overall_Diagram

After an analysis of the project, Treehouse Software proposed creating an extension to tcVISION’s change data capture (CDC) functionality for integration, so that tcVISION could enable BMF to continue using the implemented data definitions in a format suitable for the RDBMS.

The extension was developed within a few days, and a two-day on premise test demonstrated the solution fit the requirements of BMF.

BMF can now provide its data definitions from Natural LDA to the extension of tcVISION, and after the transformation, onto the PostgreSQL load process for processing. Another advantage of the tcVISION solution is that when needed, other targets can be integrated for propagation of data from the mainframe (e.g., Kafka, which BMF indicated is a future target environment).

Additionally, bi-directional propagation can be added in budget planning when BMF is ready.

Data structures are held in LDA, because this provides the advantages of higher flexibility in development and the adaption of new requirements to the data definitions. If definitions would have to be ported manually, in part, to PostGreSQL, it would have been a much bigger and error-prone effort.

Subsequent changes to Adabas structures can now use tcVISION’s newly developed extension to easily regenerate and load the correct definitions to the RDBMS, and tcVISION completely covers the customer’s requirements for special usage of *PEs and *MUs.

After thorough preparation and extensive testing, the solution was released to selected users first, then made available to all users.

* PEs and MUs are special Adabas formats for definition of tables. PE = Periodic Group, MU = Multiple Value Field.


__tsi_logo_400x200

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.


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

___tcVISION_AWS_HA_Architecture

AWS recently published a blog about tcVISION’s Mainframe 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.

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.

___AI

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!

___Mainframe_To_AWS

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.

___tcVISION_AWS_Overall_Architecture

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…

___tcVISION_AWS_HA_Architecture

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.


__tsi_logo_400x200

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.

tcVISION_Overall_Diagram

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.