WhereScape December 2021 Release: Let’s find out what’s new

| December 23, 2021
WhereScape December 2021 Release: Let's find out what's new

I am incredibly pleased to announce the latest release of WhereScape 3D and WhereScape RED that focuses on three main areas: DevOps automation workflows, Cloud data source discovery and Improved collaboration.

What’s New?

We affectionately refer to this as our “DevOps” release, with new features that group together complex workflows into a single button and integrate with an even wider range of DevOps processes. WhereScape users can leverage CI/CD pipelines for hugely powerful automation processes such as discovery and profiling source systems, generating models such as data vaults and their staging models and deploying them with all the necessary (generated) code to make them live on their database platforms, whether in the cloud, on-premises or a hybrid.

Single-click and DevOps pipeline automation.

DevOps Extensions

Several new command line interface (CLI) features have been introduced in WhereScape 3D for broader integration with DevOps processes – driven by platforms like Azure DevOps, Jenkins and Git – as well as via WhereScape 3D’s new Configurable Workflows (more on that below). New commands include:

  • Import/export all configurations and settings
  • DDL generation
  • Import/export of models
Import/export of model
Using Azure DevOps pipelines to control the end-to-end discover > design > build > deploy.

Configurable Workflows

Users can now configure WhereScape 3D workflow buttons to accommodate custom processes. A set of model conversion rules or a user-defined script can now be attached to a workflow button, allowing processes such as exporting models and/or DDL to Git to be performed with the click of a button. Alternatively, batches of processes can be grouped together and executed with a single click; for example discovering and profiling a source system, automatically creating an ODS target model and deploying the model to WhereScape RED for code generation in their platform of choice, e.g. Snowflake / Synapse / BigQuery / Exasol / Redshift…

Workflow buttons present complex multi-step processes as a single-click.

Extensible Source Connections

Data source browsing has been expanded significantly and now has seamless integration with WhereScape Source Enablement Packs. This feature enables any script-readable data source to be browsed in WhereScape 3D / WhereScape RED and integration code generated to load source data into your data warehouse. Example sources made available by this feature are REST APIs/SOAP Services, Cloud Storage (Amazon S3, Azure, Google), complex JSON/XML/AVRO file parsing, and many more. If you can connect to a data source using a script then you can now graphically browse it in WhereScape.

A few examples of sources you can connect to via Extensible Source Connections.

Shared Environment Improvements

All WhereScape 3D settings are now migrated into WhereScape’s centralized metadata database, simplifying configuration of new shared environments, improving workflow and allowing users to easily share configurations and customizations. Data type mappings, discovery methods, profiling methods and database functions are all now stored in the repository rather than per user.

PLUS A WHOLE LOT MORE……

Check out our release notes for the full details. Here are some notable improvements:

  • Security – with WhereScape 3D support for Azure Active Directory, LDAP and Active Directory. Plus enhanced security for ODBC connections.
  • Data Vault and Business Vault – with improved PIT / Bridge wizards, naming conventions and standards. Plus enhanced control over data transformations and business logic.

Want to find out more?

Existing customers can access the installer, full release notes and user guide on our portal.

Not yet a WhereScape customer? For a 1:1 session with one of our solutions architects to understand these new product features in more depth, please request a private consultation here.

WhereScape Announces the Release of RED 10.0.0.0

WhereScape is pleased to announce the general availability of WhereScape RED 10.0.0.0. This release is the culmination of man-years of effort. It confirms WhereScape’s commitment to continuing to develop new technologies and tools and its commitment to delivering the...

Effective AI through Data Modeling

As we journey deeper into the digital age, the importance of data modeling within the broader landscape of artificial intelligence (AI) has become more pronounced than ever. The success of AI-driven initiatives is tightly woven with the quality and structure of the...

Is Data Vault 2.0 Still Relevant?

TL;DR  Yes. Data Vault 2.0 Data Vault 2.0 is a database modeling method published in 2013. It was designed to overcome many of the shortcomings of data warehouses created using relational modeling (3NF) or star schemas (dimensional modeling). Speci fically, it...

Data Vault 2.0 Resources

Data Vault Revisited: A Six-Year Journey into the Secure Data Repository In 2017, Dr. Barry Devlin provided valuable insights about Data Vaults, a concept that sparked interest among businesses and IT professionals. Data Vaults were envisioned as secure repositories...

Understanding Data Vault 2.0

How to Avoid Pitfalls During Data Vault 2.0 Implementation Implementing a data vault as your Data Modeling approach has many advantages, such as flexibility, scalability, and efficiency. But along with that, one must be aware of the challenges that come along with...

Navigating the AI Landscape

The Pivotal Role of Data Modeling In the rapidly evolving digital age, artificial intelligence (AI) has emerged as a game-changer, deeply impacting the business landscape. Its ability to automate operations, refine decision-making processes, and significantly enhance...

Information Management Maturity

Unlocking Your Business Potential: Understanding and Enhancing Information Management Maturity In a recent report by Gartner, they emphasize the crucial role of information in the current business environment, stating, "Through 2025, organizations that are data-driven...

Data Warehousing Best Practices

In modern times, organizations are daily generating huge volumes of data. Appreciating the significance of data, companies are storing data from different departments which can be analyzed to gather insights to help the organization in better decision-making. This...

Related Content

WhereScape Announces the Release of RED 10.0.0.0

WhereScape Announces the Release of RED 10.0.0.0

WhereScape is pleased to announce the general availability of WhereScape RED 10.0.0.0. This release is the culmination of man-years of effort. It confirms WhereScape’s commitment to continuing to develop new technologies and tools and its commitment to delivering the...

WhereScape Announces the Release of RED 10.0.0.0

WhereScape Announces the Release of RED 10.0.0.0

WhereScape is pleased to announce the general availability of WhereScape RED 10.0.0.0. This release is the culmination of man-years of effort. It confirms WhereScape’s commitment to continuing to develop new technologies and tools and its commitment to delivering the...

Effective AI through Data Modeling

Effective AI through Data Modeling

As we journey deeper into the digital age, the importance of data modeling within the broader landscape of artificial intelligence (AI) has become more pronounced than ever. The success of AI-driven initiatives is tightly woven with the quality and structure of the...