by Peter M. Horbach

tcVISION and Snowflake

With tcVISION B.O.S. offers a solution with a wide range of possible uses for the data integration of a mainframe with the operating systems z/OS, z/VSE, VSEn, z/VM, network platforms and database systems under Windows, UNIX and Linux as well as integration with popular and well-known cloud systems.

An overview of all supported platforms, databases and systems can be found here.

A connection to data warehouse systems has been part of the tcVISION solution from the very beginning.

Different cloud-based systems are supported by tcVISION, such as Google Cloud BigQuery or Amazon Redshift.

Tasks in the environment of a data warehouse or business intelligence can be solved faster and more scalable, since the user can quickly and easily transfer the - often historically grown and very special mainframe data - to a warehouse and evaluate or analyze them in real time.

The combination of tcVISION and a data warehouse opens up the possibility for companies to quickly and easily integrate data from the z mainframe or from the distributed environment. The tcVISION change data capture technology ensures that the data warehouse is always supplied with up-to-date data in real time.

The latest addition to a cloud-based data warehouse system is support for Snowflake.

Snowflake is a cloud-based database platform purpose-built to handle data warehouse workloads. It is a solution that is optimized for processing large amounts of data and enables scalable, elastic and high-performance data processing.

Snowflake can be hosted on any of the following cloud platforms:

  • Amazon Web Services (AWS)
  • Microsoft Azure (Azure)
  • Google Cloud Platform (GCP)

Advanced data integration capabilities are offered by Snowflake, including the ability to seamlessly integrate data from disparate sources such as data lakes, cloud storage, or other databases. In addition, the system supports a variety of analysis tools and provides an easy-to-use SQL interface for query execution and data manipulation.

Snowflake has been added to the tcVISION solution as an additional output component and - like any other database - has been transparently integrated into the graphical user interface.

All information required for processing with Snowflake (e.g. account, scheme, warehouse, database and table definitions) are part of the tcVISION repository and are recorded via the standard dialogs for the metadata via the graphical interface.

Both the loading of the Snowflake Warehouse and the processing of change data via journal functions are part of the Snowflake implementation. The processing processes required for this are created via wizard-controlled dialogs.

In addition to a high degree of parallel processing (loads, CDC and queries), the data warehouse technology is characterized by the fact that the administrative effort otherwise associated with a data warehouse is completely eliminated. Thus, tcVISION presents itself as an ideal addition to the integration of data into the Snowflake data warehouse technology for customers who demand a high level of up-to-dateness.

Overall, tcVISION, in conjunction with Snowflake, offers a modern and powerful platform for data analysis and data integration. With the scalable and elastic architecture, it enables companies to efficiently process large amounts of data and make informed decisions based on their data.

For more details, please visit our website, register for our newsletter or arrange a personal workshop directly. We introduce you to tcVISION, tailored to your situation, infrastructure and requirements.

Peter M. Horbach has been active in the area of data synchronization and replication with more than 40 years of IT experience. He manages the international partner business for BOS Software and writes for our blog.

zurück zur Übersicht