Customers are discovering that they can quickly begin replicating their mainframe data to the Cloud during tcVISION Proof of Concepts (POCs)

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

___Data_Flow_Cloud

Modernizing long-standing mainframe systems has become a strategic imperative at many government, education, healthcare, financial, and retail organizations. As a result, these organizations are looking for solutions that allow their legacy environments to continue, while replicating data, in real time, on Cloud-based platforms, such as AWS, Microsoft Azure, Google Cloud, etc. This “data first” approach allows organizations to quickly take advantage of advanced Cloud technologies, such as big data analytics, artificial intelligence (AI), rapid global database deployments, high-level security, etc., while keeping the mainframe and Cloud sides synchronized.

With new IT modernization initiatives in the forefront, Treehouse Software is seeing a significant upswing in requests for online demonstrations and POCs of tcVISION, our Mainframe-to-Cloud data replication product.

You can start moving your mainframe data to the Cloud within days during a tcVISION POC…

tcVISION_Overall_Diagram_General_Cloud

An online tcVISION POC is approximately 5-10 business days, with the customer providing use case and goals for the POC. A Treehouse Software consultant will assist in downloading and installing tcVISION, and conduct a limited-scope implementation of a tcVISION application. This application uses customer data and executes on customer facilities, usually in a non-production environment. A document is provided beforehand that outlines the requirements and agenda for the POC.

By the end of the 10-day POC, customers can begin replicating mainframe data to their Cloud target database.  It can happen that fast!


__TSI_LOGO

Contact Treehouse Software for a tcVISION Demo Today…

Simply fill out our Product Demonstration Request Form and a Treehouse representative will be contacting you to set up a time for your requested demonstration.

High Availability Requirements for Mainframe Data Modernization — Running tcVISION in Global Availability Zones

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

Many customers embarking on Mainframe-to-Cloud data replication projects with Treehouse Software are looking at high availability (HA) as a key consideration in the planning process. The goal with HA is to ensure that systems are always functioning and accessible, with deployments located in various Availability Zones (AZs) worldwide. Having an HA architecture in place protects against data center, availability zone, server, network, and storage subsystem failures to keep businesses running without downtime or human intervention.

In this blog, we will give a high-level overview of tcVISION HA Architecture, using AWS as an example. However, HA basic principles are essentially the same across all Cloud platforms.

Example of the tcVISON HA Architecture on AWS

During tcVISION’s Change Data Capture (CDC) processing for Mainframe-to-Cloud data replication, HA must be maintained in the AWS environment. The Amazon Elastic Compute Cloud (Amazon EC2), which contains the tcVISION Manager, is part of an Auto Scaling Group that is spread across AZs with Amazon EC2 instance(s).

___tcVISION_AWS_HA_Architecture

Upon failure, the replacement Amazon EC2 instance tcVISION Manager is launched and communicates its IP address to the mainframe tcVISION Manager. The mainframe tcVISION Manager then starts communication with the replacement Amazon EC2 tcVISION Manager.

Once the Amazon EC2 tcVISION Manager is restarted, it continues processing at its next logical restart point, using a combination of the LUW and Restart files. LUW files contain committed data transactions not yet applied to the target database. Restart files contain a pointer to the last captured and committed transaction and queued uncommitted CDC data. Both file types are stored on a highly available data store, such as Amazon Elastic File System (EFS).

For production workloads, Treehouse Software recommends turning on Multi-AZ target and metadata databases.

To keep all the dynamic data in an HA architecture, tcVISION uses EFS, which provides a simple, scalable, fully managed elastic file system for use with AWS Cloud services and on-premises resources. It is built to scale on-demand to petabytes without disrupting applications, growing and shrinking automatically as you add and remove files, eliminating the need to provision and manage capacity to accommodate growth.


Treehouse Software can help organizations immediately start moving their mainframe data to the Cloud and take advantage of the most advanced, scalable, secure, and highly available technologies in the world with tcVISION

tcVISION_Overall_Diagram_General_Cloud

tcVISION supports a vast array of integration scenarios throughout the enterprise, providing easy and fast data migration for mainframe application modernization projects and enabling bi-directional data replication between mainframe, Cloud, Open Systems, Linux, Unix, and Windows platforms.

View the Unequalled List of Environments Supported by tcVISION Here


__TSI_LOGO

___AWS_Select_Partner_Badge ___Google_Cloud_Partner_Badge

Contact Treehouse Software for a 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 tcVISION demonstration. This will be a live, on-line demonstration that shows tcVISION replicating data from the mainframe to a Cloud target database.

Now, more than ever, enterprises with mainframes are looking to modernize their legacy systems

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

Rapidly changing global health, economic, and political conditions are making fast access to the most current information more important than ever for official agencies and the public.  As a result, modernizing information systems is taking center stage and top priority, especially for organizations with critical mainframe data residing on a variety of long-standing databases, often still updated by COBOL applications! These databases include Db2, VSAM, IMS/DB, Adabas, IDMS, Datacom, or even sequential files. Unlocking the value of this important data can be difficult, because the data can be utilized by numerous interlinked and dependent programs that have been in place for many years, and sometimes decades.

Many organizations are now looking for modernization solutions that allow their legacy mainframe environments to continue, while replicating data in real time on highly available Cloud-based platforms (AWS, Google Cloud, Microsoft Azure, etc.). With a “data-first” approach, immediate data replication to the Cloud is enabling government, healthcare, supply chain, financial, and a variety of public service organizations to meet spikes in demand for vital information, especially in times of crisis.

Treehouse Software can help organizations immediately start moving their mainframe data to the Cloud and take advantage of the most advanced technologies in the world with tcVISION

tcVISION_Overall_Diagram_General_Cloud

Whether an enterprise needs to take advantage of the latest Cloud services, such as big data analytics, artificial intelligence (AI), rapid global database deployments, high-level security, etc., or move data to a variety of newer Cloud or Open Systems databases, the transition doesn’t have to be a sudden big bang.

A Phased Approach

Treehouse Software has extensive mainframe experience and subject matter experts to help organizations incrementally replicate their mainframe data to the Cloud and other modern systems, while keeping both sides synchronized.

Treehouse Software’s expert technical representatives help customers develop a phased plan that includes installation and implementation of the tcVISION mainframe data modernization product, script customization, data replication mapping, high availability, security, monitoring, training, etc..

After defining the architecture, the production deployment phase begins with incremental sprint-like deployments. Additional files are then deployed into production regularly.

This phased plan enables tcVISION to synchronize critical mainframe data to a Cloud / Open Systems database. Bi-directional, real-time data synchronization allows changes on either platform to be reflected on the other platform (e.g., a change to a PostgreSQL table is reflected back on mainframe). The customer can then modernize their application on the cloud, open systems, etc. without disrupting the existing critical work on the legacy system.

Additionally, tcVISION customers see drastically reduced mainframe MIPS costs, and increased ability to quickly respond to business environment changes.

Enterprise ETL and Real-time and Bi-directional Data Replication Through Change Data Capture with tcVISION

tcVISION uses an intuitive Windows GUI interface for administration, mapping and modeling, script generation, and monitoring. The product focuses on changed data capture (CDC) when transferring information between mainframe data sources and modern 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 – Supported Sources and Targets

tcVISION supports a vast array of integration scenarios throughout the enterprise, providing easy and fast data migration for mainframe application modernization projects and enabling bi-directional data replication between mainframe, Cloud, Open Systems, Linux, Unix, and Windows platforms.

View the Unequalled List of Environments Supported by tcVISION Here


__TSI_LOGO

___AWS_Select_Partner_Badge ___Google_Cloud_Partner_Badge

Contact Treehouse Software for a 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 tcVISION demonstration. This will be a live, on-line demonstration that shows tcVISION replicating data from the mainframe to a Cloud target database.

Treehouse Software, Inc. Collaborates with Google Cloud to Offer Mainframe-to-Google Cloud Data Replication for Enterprise Transformation and Modernization

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

_0_Treehouse_And_Google_Cloud_Logos_H

Treehouse Software, Inc. is pleased to announce an agreement with Google Cloud as a technology partner in the Google Cloud Partner Advantage Program. As a technology partner, Treehouse Software Inc. will now offer enterprise customers a comprehensive Mainframe-to-Google Cloud data replication and migration solution. This relationship provides Google Cloud customers with Treehouse’s combination of decades worth of mainframe systems experience and comprehensive data replication capabilities, with Google Cloud’s platform.

The Google Cloud Enterprise Transformation Practice assists companies in migrating and modernizing workloads on Google Cloud’s global, secure, and reliable platform. Once an enterprise’s data is on Google Cloud, they can immediately take advantage of some of the most advanced artificial intelligence, machine learning, big data analytics, and data warehousing services in the world.

01_tcV_Arch_Google_Cloud

The same technology that supports Google’s global network protects data while meeting rigorous industry-specific compliance standards, and Treehouse Software’s tcVISION product moves or syncs mainframe data with real-time and bi-directional data replication. tcVISION’s GUI modeling and mapping, and ease of migrating data to Google Cloud, makes it an ideal choice for modernizing large mainframe environments.

“Through this exciting new collaboration with Google Cloud, Treehouse Software expands its mature and proven mainframe data delivery capabilities, and customers benefit from modernization of their data on one of the most popular and advanced Cloud platforms in the world”, said Joseph Brady, Director of Business Development and Cloud Alliance Lead at 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.

The New 2020 IBM Z Solutions Directory Features a Wide Selection of Mainframe Tools and Services, Including Treehouse Software’s Data Integration Products

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

2020_IBM_Systems_Solutions_Directory

Enterprises’ investments in IBM Z mainframe technology is significant, and the IBM Z Solutions Directory showcases some of the best hardware, accessories, software products, and services available to help customers maintain and expand the platform.

Treehouse Software encourages mainframe customers to explore the IBM Z Solutions Directory, where they will find neatly organized listings that help them quickly find the products and services they need. We are very pleased to have our products included, side-by-side, with most of the top mainframe solutions in the world in this valuable guide. 


__TSI_LOGO

More About Treehouse Software’s Mature and Proven Mainframe Enterprise Transformation Products…

Treehouse_Products_Diagram_General_Cloud.jpg

Treehouse Software has been developing, marketing, selling, and supporting mainframe software since 1982, and we are committed to helping customers easily access some of the most advanced Cloud and open systems technologies in the world, while maintaining their valuable legacy environments. 

Treehouse Software’s visionary leadership in the mainframe market has included pioneering Adabas-to-RDBMS ETL and CDC with tRelational/DPS in the mid-1990s.  Today, with the tcVISION product, Treehouse Software is a global leader in providing 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), Microsoft Azure, Google Cloud, Oracle Cloud, PostgreSQL, Microsoft SQL Server, IBM Db2 LUW and Db2 BLU, IBM Informix, Kafka, MongoDB, MariaDB, Hadoop, SAP Hana, and many more.

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.

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.

 

The Mainframe-to-Cloud Wave has Arrived, and Treehouse Software is Helping Customers Begin the Ride!

by Joseph Brady, Director of Business Development / AWS and Cloud Alliance Lead at Treehouse Software and Andy Jones, Certified AWS Solutions Architect at Treehouse Software

There are many pioneering organizations with mainframe systems that have already begun their movement to the Cloud, and are now taking advantage of the new and powerful technologies delivering significant business benefits and competitive advantage, including:

Trade Capital Expense for Variable Expense – Instead of having to invest heavily in data centers and servers before you know how you’re going to use them, you can pay only when you consume computing resources, and pay only for how much you consume. https://aws.amazon.com/pricing/

Global Deployments – The AWS Cloud spans 22 geographic regions globally. Enterprises can easily deploy applications in multiple regions around the world with just a few clicks. This means you can provide lower latency and a better experience for your customers at minimal cost. https://aws.amazon.com/about-aws/global-infrastructure/regions_az/

Economies to Scale – By using Cloud computing, you can achieve a lower variable cost than you can get on your own, because usage from hundreds of thousands of customers is aggregated in the Cloud, providers such as AWS can achieve higher economies of scale, which translates into lower pay as-you-go prices. https://aws.amazon.com/economics/

Scale of Services – Amazon Web Services offers a broad set of global Cloud-based products including compute, storage, databases, analytics, networking, mobile, developer tools, management tools, IoT, security, and enterprise applications. These services help organizations move faster, lower IT costs, and scale. https://aws.amazon.com/products/

World Class Security – AWS security compliance is second to none and complies with the most stringent government and private sector requirements. https://aws.amazon.com/compliance/programs/

Extreme High Availability (HA) – The AWS Cloud spans 69 Availability Zones within 22 geographic Regions around the world https://aws.amazon.com/about-aws/global-infrastructure/regions_az/.  By designing your services and applications to be redundant across AWS availability zones or regions, HA is enhanced far beyond a single on premises data center. https://aws.amazon.com/marketplace/solutions/infrastructure-software/high-availability 

Testing at Scale – AWS servers and services can be created and charged on demand for a specific amount of time.  This allows customer to create temporary large-scale test environments prior to deployment that are not practical for on premises environments.  Large scale testing reduces deployment risks and helps to provide a better customer experience. https://aws.amazon.com/  

Auto Scaling and Serverless Deployments – AWS has many serverless and autoscaling options available, allowing for scalable computing capacity as required.  For example, AWS Lambda lets you run code without provisioning or managing servers. You pay only for the compute time you consume – there is no charge when your code is not running. Another example is Amazon Aurora Serverless, which is an on-demand, auto-scaling configuration for Amazon Aurora (MySQL-compatible edition), where the database will automatically start up, shut down, and scale capacity up or down based on your application’s needs. https://aws.amazon.com/serverless/

Customer Agility and Innovation – In a Cloud computing environment, new IT resources are only a click away, which means that you reduce the time to make those resources available to your developers from weeks to just minutes. This results in a dramatic increase in agility for the organization, since the cost and time it takes to experiment and develop is significantly lower. https://aws.amazon.com/architecture/

Infrastructure as Code – AWS CloudFormation provides a common language for you to describe and provision all the infrastructure resources in your Cloud environment. CloudFormation allows you to use programming languages or a simple text file to model and provision, in an automated and secure manner, all the resources needed for your applications across all regions and accounts. This gives you a single source of truth for your AWS resources. https://aws.amazon.com/cloudformation/ 

However, compared to the number of mainframe shops in enterprises that are just beginning to plan their moves to the Cloud, existing adopters’ numbers are still relatively small.

As an example of the current boom in overall Cloud growth, the worldwide public sector Cloud market will be growing to a staggering $331B by 2022 according to Gartner. By the end of 2019, more than 30% of technology providers’ new software investments will shift from Cloud-first to Cloud-only, further reducing license-based software spending and increasing subscription-based Cloud revenue. (Source: Forbes) 

Treehouse Software is a Trusted Partner on Your Mainframe-to-Cloud Journey

Treehouse Software is a well-established company serving mainframe customers since 1982. We are currently developing a strong presence in the emerging Cloud market space related to mainframe data migration, primarily through our partnership with Amazon Web Services (AWS).  AWS is aware that most large enterprises use mainframe systems that are housing vast amounts of data encompassing historical, customer, logistics, etc., and they have helped us bring our tcVISION solution to the AWS Marketplace. tcVISION provides real-time replication between a variety of mainframe and non-mainframe sources, including (Mainframe): VSAM, IMS, Db2, CA Datacom, Adabas, CA IDMS, and Flat Files; and (Non-mainframe): AWS RDS databases, AWS Aurora, AWS S3, AWS Kinesis,  PostgreSQL, MySQL, Kafka, MongoDB, Hadoop, Oracle, Microsoft SQL Server, IBM Db2 LUW and Db2 BLU, IBM Informix, SAP Hana, and many more. 

AWS sales and technical leaders within various verticals (GovCloud, Nonprofit, K12/Higher Ed, Automotive, etc.) are also beginning to engage with Treehouse Software to learn more about our unique skills and solution that can help them tap into this potential goldmine of massive amounts of legacy data that needs to be moved to AWS. 

Treehouse Software Helps Customers Begin Moving Their Mainframe Data to the Cloud Immediately

Treehouse Software specializes in providing data replication for enterprise customers who want a fully developed and automated way to move data from their mainframe systems to the Cloud. Treehouse Software’s tcVISION is a low risk option that allows customers to immediately begin moving data to the Cloud while they work on the sometimes massive complexity of application migration. Our experience has shown that projects can become stalled while the application side is being figured out. For example, Treehouse Software recently became involved in a project with a government agency that was facing the complexity of a “big bang” migration, which is slowing the project. We are now presenting them with our tcVISION data replication solution option, where they can replicate data to AWS while maintaining their current environment for modernization and migration of their applications. 

Additionally, Treehouse Software’s decades of experience developing software and working in the IBM mainframe environment, in addition to selling and supporting a comprehensive automated data replication product, is making us a desirable partner for AWS and many Cloud migration companies.  

AWS recently published a blog about tcVISION, our Mainframe-to-Cloud data replication product: https://aws.amazon.com/blogs/apn/real-time-mainframe-data-replication-to-aws-with-tcvision-from-treehouse-software/ 

Additionally, here is a blog about Treehouse Software’s extensive mainframe experience: https://treehousesoftware.wordpress.com/2019/09/12/treehouse-softwares-differentiator-weve-been-helping-enterprise-mainframe-sites-since-1982/


If your enterprise is planning on riding the wave with a Mainframe-to-Cloud migration project, we would welcome the opportunity to help get you moving immediately with an online presentation and demonstration of our tcVISION data replication solution. Contact Treehouse Software today!

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.