Treehouse Software Customer Success: Element Fleet Management Corp. Real-time, Bi-directional Synchronization Between IBM Mainframe Datacom and PostgreSQL

Element_Building

As a leading global fleet management company, Element provides a comprehensive range of fleet services that span the total fleet lifecycle, helping customers optimize their strategies at every stage – from acquisition and financing to program management and vehicle remarketing. These services, together with exceptional tools, technologies and consulting, empower customers to realize extraordinary results.

Business Background

Element Fleet Management has over one million vehicles under management, and serves more than 2,800 customers. The company employs over 2,700 staff members across 12 offices. Transaction sizes range from $500,000 to $40 million. 50 countries are served through the Element-Arval Global Alliance. Top industries served by Element Fleet Management are agriculture, business services, chemical, construction, consumer products, education and non-profit, energy, food and beverage, insurance, manufacturing, pharmaceutical and healthcare, professional services, telecommunications, transportation, and utilities.

Business Issue

Much of Element’s mission critical mainframe data is stored in a legacy IBM mainframe database. The cost to maintain these legacy databases is high and they lack the features required for modernizing the data architecture. The data is utilized by an extensive number of interlinked programs dependent on this legacy data. Element required a solution that would allow the legacy environment to continue while having real time replicated data on a modern database/platform. This enables them to utilize modern programing and data tools to be competitive in their market.

Element_Diagram

Technology Solution

Treehouse software and the customer developed a phased plan to prove out and implement tcVISION. This started with a proof-of-concept to prove out the technology’s effectiveness and technical suitability. This was proceeded by architectural phase to define the architectural solution including, configuration management, environments and promotion, high availability, security, disaster recovery, monitoring, operations procedures, script customization, data replication mapping and training plans. After defining the architecture, the production deployment phase started with incremental sprint-like deployments. Additional files were deployed into production every few weeks.

This project enabled the tcVISION product to synchronize mission critical financial IBM mainframe Datacom data to a modern PostgreSQL database. Bi-directional, real-time data synchronization enables changes on either platform to be reflected on the other platform (e.g., a change to a PostgreSQL table is reflected on mainframe Datacom). This allows their business to modernize the application on PostgreSQL without disrupting the existing critical work on the legacy system.

NOTE: Many modern tools are using the PostgreSQL database, which greatly enhances business agility (e.g., other divisions within Element are already using Amazon Web Services (AWS), so having tcVISION in place now makes mainframe data delivery to the AWS cloud an easy option). See a step-by-step video of Mainframe-to-PostgreSQL on AWS here. 

Successful, real-time mainframe data replication to an open systems application allows web and mobile access and updates. Element indicated their satisfaction with the results and the solution, especially reduced mainframe MIPS costs, and enhanced business ability to respond to business environment changes.


Find out more about tcVISION — Enterprise ETL and Real-Time Data Replication Through Change Data Capture

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, Linux, Unix and Windows platforms. 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 on-premise and Cloud-based.

tcVISION_Connection_Overview_Web01

tcVISION acquires 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 PostgreSQL, Adabas LUW, Oracle Database, Microsoft SQL Server, IBM Db2 LUW and Db2 BLU, and IBM Informix.


__TSI_LOGO

Visit the Treehouse Software website for more information on tcVISION, or contact us to discuss your needs.

 

Want to See a Live, Online Demonstration of Mainframe-to-Amazon Web Services (AWS) Data Replication using Treehouse Software’s tcVISION?

tcVISION is a powerful and comprehensive solution for real-time, bi-directional replication of mainframe data to AWS. tcVISION’s GUI modeling and mapping, and ease of migrating data to AWS makes it an ideal choice for modernizing large mainframe environments. Additionally, tcVISION can synchronize mission critical data from a mainframe system on AWS. Real-time, bi-directional data synchronization enables changes on either system to be reflected on the other system (e.g., a change to a PostgreSQL table on AWS is reflected on the mainframe database). This allows businesses to modernize an application on AWS without disrupting the existing critical work on the legacy system.

Contact Treehouse Software today for a live, online session that demonstrates real-time replication of mainframe data to Amazon RDS instances!

Example of a Treehouse Software Mainframe-to-AWS Data Replication Demo Environment…

Slide1

tcVISION Technology

tcVISION‘s support for AWS as a target is fully integrated alongside traditional Linux/Unix/Windows (LUW) targets such as PostgreSQL, Oracle Database, IBM DB2 LUW, Software AG Adabas LUW, IBM Informix, Sybase, Microsoft SQL Server, and ODBC.

tcVISION_Connection_Overview_Web01

tcVISION considerably simplifies mainframe data exchange processes. The structure of the existing mainframe data is analyzed by tcVISION processors, then automatically mapped to a target data mapping. The data mapping information is presented in a user-friendly and transparent format – even for users with no mainframe knowledge.

The mapping information is saved in a meta data repository hosted on a relational database, and can easily be made available to other applications. The Windows-based Control Board of tcVISION provides an easy-to-use facility to administer the data flow. tcVISION provides a variety of interfaces to allow seamless integration with ETL or EAI solutions.


__tsi_logo_400x200

Since 1982, Treehouse Software, Inc. has been serving enterprises worldwide with industry-leading software products and outstanding technical support.  Today, Treehouse Software is a global leader in providing data migration, replication, and integration solutions for the most complex and demanding heterogeneous environments, as well as feature-rich, accelerated-ROI offerings for information delivery, business intelligence and analytics, and application modernization.

 

 

Treehouse Software Collaborates with Amazon Web Services (AWS) to Offer Comprehensive Enterprise Mainframe-to-AWS Data Replication

Press Contact: Joe Brady (+1.724.759.7070 x110; jbrady@treehouse.com)

Pittsburgh, PA; Treehouse Software, Inc., of Sewickley, PA is pleased to announce an agreement with Amazon Web Services (AWS) to offer enterprise customers a complete Mainframe-to-AWS data replication solution to provide them with fast and easy access to the cloud.

tcVISION_Mainframe_To_AWS_635

Treehouse Software’s tcVISION is a powerful and mature software product designed for real-time, bi-directional replication of mainframe data to AWS. tcVISION’s GUI modeling and mapping, and ease of migrating data to AWS makes it an ideal choice for modernizing large mainframe environments.

Additionally, tcVISION can synchronize mission critical data from a mainframe system on AWS.  Real-time, bi-directional data synchronization enables changes on either system to be reflected on the other system (e.g., a change to a PostgreSQL table on AWS is reflected on the mainframe database). This allows businesses to modernize an application on AWS without disrupting the existing critical work on the legacy system.

“Through this exciting new collaboration, Treehouse Software and AWS are working together to offer customers with mainframe systems a straightforward solution for enhancing their business agility,” said George Szakach, President of Treehouse Software. “We provide our proven mainframe data delivery capabilities, and the customer benefits from modernization of their data within the flexible, scalable, pay-as-you-go offering on AWS.”

Video – How does tcVISION replicate mainframe data to AWS?


About Treehouse Software, Inc.

__tsi_logo_400x200

Since 1982, Treehouse Software, Inc. has been serving enterprises worldwide with industry-leading software products and outstanding technical support.  Today, Treehouse Software is a global leader in providing data migration, replication, and integration solutions for the most complex and demanding heterogeneous environments, as well as feature-rich, accelerated-ROI offerings for information delivery, business intelligence and analytics, and application modernization.

Treehouse Software Customers are Looking Upwards to Mainframe-to-Cloud Data Replication

The search is on for a mature, easy-to-implement Extract Transform and Load (ETL) solution for migrating mission critical data to the cloud.

Mainframe_to_Cloud

Treehouse Software’s tcVISION supports a vast array of integration scenarios throughout the enterprise, providing easy and fast data migration for mainframe application modernization projects, and enabling data replication between mainframe, Linux, Unix and Windows platforms. 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 on-premise and cloud-based.

Mainframe-to-Cloud Case Use Example…

BAWAG P.S.K. is one of the largest banks in Austria, with more than 1.6 million private and business customers and is a well-known brand in the country. Their business strategy is oriented towards low risk and high efficiency.

BAWAG was looking to reduce the load on their IBM mainframe and as a result, reduce costs. The project involved offloading data from their core database system to a less expensive system, in real-time, and to provide read access from that system to the new infrastructure. The primary motivator for this data migration was the constantly increasing CPU costs on the mainframe caused by the growing transaction load of online banking, mobile banking, and the use of self service devices.

BAWAG ultimately migrated their online banking application to the cloud using tcVISION. Realtime Event-handling, Realtime Analytics, Realtime Fraud Prevention are only a few of the use cases that the bank’s solution currently covers.

BAWAG_Diagram

The bank decided to use tcVISION to migrate z/OS DB2 data into a Hadoop data lake (a storage repository that holds raw data in its native format). 20 Million transactions were made within 15 minutes.

Cost Reductions Seen Immediately

BAWAG is now seeing a 35-40 percent reduction of the MIPS consumption for online processing during business hours. After hours, consumption is less, because it is mainly batch processing on the mainframe. Currently, a volume of approximately 30 GB changed data (uncompressed) is replicated from DB2 per day.

In addition to the primary usage scenario, BAWAG can also cover additional use cases. This includes real-time-event handling and stream processing, analytics based upon real-time data as well as the possibility to report and analyze structured and unstructured data with excellent performance. The system can be inexpensively operated on Commodity Hardware and has no scalability limitations. Compared to the savings, the costs of replication (CPU consumption) of tcVISION are now very low.

Additionally, BAWAG plans to extend the use of tcVISION in the future, including implementation of real-time replication from ORACLE into the data lake.


Find out more about tcVISION — Enterprise ETL and Real-Time Data Replication Through Change Data Capture

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, Linux, Unix and Windows platforms. 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 on-premise and Cloud-based.

_0_tcvision_connection_overview

tcVISION acquires 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.


__TSI_LOGO

Visit the Treehouse Software website for more information on tcVISION, or contact us to discuss your needs.

Treehouse Software Eases the Challenges for Mainframe-to-Modern Platform Transformation Programs for Systems Integrators

Unlock Your Customers’ Business Value Faster with Frequent Production Deliveries, Using Agile Methods

Treehouse Software’s product, tcVISION has proven to be vital for the ease and success of many mainframe modernization initiatives.

A big problem for a Systems Integrator (SI), or any mainframe modernization vendor, is the myriad of dependencies between mainframe and open systems data and components. As part of a mainframe modernization project, these vendors need to determine the ordering of phases or waves of applications to be migrated. There are often shared databases that can make it very difficult to move one set of applications without moving others. This can result in the conclusion that they must go with a “big bang” approach, which can lead to a bid for a program with one large delivery at the end with all of the integrated components in place. This is very unappealing to customers as they are paying out big dollars without the corresponding business value of a production deployment. This approach also significantly increases the project risk.

___Mainframe_To_LUW

With Treehouse Software’s bi-directional replication product, tcVISION, a subset of applications can be migrated, and tcVISION’s data synchronization capabilities can be used to bridge specific shared legacy mainframe databases to the modern database versions on open systems. This allows them to deliver in phases, thus getting modernized modules in production faster. In addition, it decreases risk as issues can be found much faster with the more frequent production deployments. When the last modules are deployed to production, they would no longer need the synchronization.

As an example, a large Treehouse customer is currently involved in gradually modernizing and replacing a set of applications, and is using a similar approach. The customer will be using their mainframe Adabas database synced with Oracle on Linux, while in the process of modernizing the applications. Treehouse Software’s experts and tcVISION product are making sure the customer’s transition goes smoothly and seamlessly.


Enterprise ETL and Real-Time Data Replication Between Virtually Any Source and Target

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, Linux, Unix and Windows platforms. 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 on-premise and Cloud-based.

_0_tcvision_connection_overview

tcVISION acquires 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, 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, Hadoop/HDFS, MongoDB, Oracle Database, Microsoft SQL Server, IBM DB2 LUW and DB2 BLU, IBM Informix, PostgreSQL, etc.


__tsi_logo_400x200

Visit the Treehouse Software website for more information on tcVISION, or contact us to discuss your needs.

Treehouse Software Partners with Stone Bond Technologies to offer comprehensive enterprise Data Virtualization

Press Contacts: Joe Brady (+1.724.759.7070 x110; jbrady@treehouse.com); Irma Barrientos (+1 713.300.8882; ibarrientos@stonebond.com)

Pittsburgh, PA; Houston, TX, November 17, 2016. ­ Treehouse Software, Inc., of Sewickley, PA and Stone Bond Technologies, L.P. of Houston, TX today announced a partnership to bring agile integration and data virtualization capabilities to every enterprise. Now mainframe data sources can be combined into virtual schemata with relational databases, ERP data, Cloud sources and social media by combining Stone Bond’s Enterprise Enabler® with Treehouse’s tcACCESS.

Since the mid-1990s, Treehouse has been a global leader in mainframe data migration, replication and integration, offering robust and flexible solutions for ETL, CDC and real-time, multidirectional replication between databases on various platforms. With Enterprise Enabler, Treehouse customers benefit from a single platform for enterprise and Cloud integration to deliver integration projects with up to 90% time savings over other solutions.

Treehouse will provide worldwide product sales, marketing and support for Enterprise Enabler, bringing leading-edge integration capabilities to its hundreds of existing customers and to new customers pursuing initiatives such as Agile BI, Master Data Management, Logical Data Warehouses and Web Services.

One of the fastest-growing data virtualization platforms on the market, Enterprise Enabler has been leading the innovation of data management, data federation and data virtualization for nearly 15 years. To serve its expanding base of customers, Stone Bond has grown its set of AppComm™ connectors to accommodate the widest range of enterprise and line-of-business data sources. Treehouse’s tcACCESS effectively becomes the “Mainframe AppComm”, providing full read/write access to a wide range of mainframe data sources on both z/OS and z/VSE platforms.

Wayne Lashley, Treehouse Chief Business Development Officer, said, “Our reputation for capably solving mainframe data integration challenges now extends to other modern enterprise data sources including SAP, Salesforce.com and Microsoft SharePoint. With the push of a button, our customers can securely expose these disparate virtualized sources to popular BI tools like Tableau and to other applications in standard formats like REST and JSON. Current, past and new customers can look to Treehouse to address any imaginable integration scenario.”

Commented Tom Sieger, Stone Bond SVP, Corporate Strategy and Business Development, “Embracing mainframe data sources bolsters the “enterprise” in Enterprise Enabler. We are excited to work with Treehouse to grow Enterprise Enabler sales into new markets and geographies.”


__tsi_logo_400x200

About Treehouse Software, Inc.
Privately-held Treehouse Software was founded in 1982, and has hundreds of customers worldwide that benefit from the company’s industry-leading products and outstanding technical support. The traditional strengths of the company in performance management, security and software configuration management have been complemented by visionary leadership in mainframe data replication and integration and application modernization.

stonebond_logo

About Stone Bond Technologies, L.P.
Headquartered in the heart of Houston, Texas, Stone Bond Technologies was founded in 2002 with a commitment to innovation that continues today. More than just adding features to existing offerings, the company’s approach to information business systems is to make an enterprise’s data agile: to move data efficiently and easily, without barriers. Stone Bond’s client base continues to expand from its roots in the Energy industry to Financial Services, Life Sciences, Information Technology, Hospitality, Manufacturing and more.

Cloud-y … with a 100 Percent Chance of Data

cloud computing and downloading

by Wayne Lashley, Chief Business Development Officer for Treehouse Software

Along with three of my colleagues, I recently participated in the Treehouse exhibit at the Gartner Application Architecture, Development and Integration (AADI) event in Las Vegas. This is a conference where we have exhibited in the past, and I personally have attended several other times. In fact, I just learned that the DI in AADI no longer stands for “Data Integration”; this change was only made in the past couple of years, as in the past it was the data integration aspect that made the show particularly relevant to Treehouse.

Though data integration vendors such as Informatica, Pervasive and Adeptia—and Treehouse—were in attendance, their numbers seemed diminished over prior years. And while “Legacy Modernization” had an entire subject “track” a couple of years ago, a number of “name” LM vendors were notably absent this year, and the topic was only rarely represented in sessions.

But there was a predominant theme at the event, and its name is Cloud.

People have been talking about “Cloud” for years already, and it is a well-established concept with many dimensions and extensive implementations. And it’s probably familiar enough to The Branches readers that I won’t waste words describing it, other than to say that it is simply a way to offer computing services via the Internet without the subscriber—most Cloud offerings are subscription-based—knowing or caring what or where the physical implementation is.

Many people consider that Salesforce.com is the granddaddy of all Cloud services, and to my mind it popularized the term “Software as a Service” (SaaS). Evolutionary Technologies, Inc. (ETI), a long-standing player in the data integration field and a company that I have had a lot of contact with over the years, reinvented itself around 2005 as a SaaS company, in doing so placing the company on the leading edge of “aaS” providers and essentially defining an entirely new market space.

These days there are a number of other “aaS” genres competing for mindshare and dollars, the most dominant being “Platform as a Service” (PaaS). Once again, Salesforce.com seemed to define the space initially, but others such as Amazon and Google have since come to dominate it. Just this week I was invited to an event for Oracle partners where Oracle executives will present their concept for an Oracle Cloud PaaS. I recall a Microsoft Worldwide Partners Conference (WWPC) a couple of years ago where Microsoft kicked off its Azure Cloud platform. You don’t have to install Microsoft Office on your PC anymore; Office 365 runs in the Cloud.

Even legacy applications are getting the Cloud treatment: a company called Heirloom Computing has commenced offering a platform for running legacy COBOL applications in the Cloud.

Cloud has also entered popular culture and commodity services. There’s a TV commercial that I keep seeing advertising a Cloud-based service that automatically troubleshoots, tunes up and cleans up your PC.
In short, you’re nobody if you’re not in the Cloud.

D-for-“Data” may have morphed into D-for-“Development” in the AADI Summit name, but data replication, integration and migration remain very relevant in the Cloud age. Indeed, you can’t spell Cloud without a D.

To support provisioning of Cloud-based applications, there has to be a means for getting data from where it is now—often in mainframe-based legacy databases or relational databases on open systems, within a company’s internal IT infrastructure—to the Cloud facilities, be they public or private. This doesn’t happen by magic. We have recently been working in a customer implementation where Oracle and DB2 data are being replicated bidirectionally in a Cloud implementation using our tcVISION solution. Such a scenario posed a bit of a challenge for us in terms of licensing: the machines on which tcVISION is installed are not specifically known at a given point in time. So we had to adapt our licensing model to accommodate the new reality.

We expect to see continued growth and demand for our replication and integration solutions as Cloud offerings evolve and expand. Furthermore, we are working on a new Cloud-oriented solution in collaboration with Cloud platform providers. I have briefed several Gartner analysts on it, and their feedback has been encouraging. Check back to this space regularly for news on this exciting new Treehouse offering.