Save your team from the frustrations of...
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.
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
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…
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.
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.
Maximizing Data Potential: Microsoft Fabric and WhereScape in Harmony
Forget gold. Forget oil. We are living in an era where data is our most precious commodity. As organizations strive for deeper insights into how their products perform, how their brand is perceived, and how customers behave, the need for stronger and more efficient...
Efficient Processing Techniques for JSON and Parquet Semi-Structured Data
Introduction to Semi-Structured Data and Its Importance Semi-structured data sits on the spectrum somewhere between traditional database tables and unstructured data. It has organizational properties that make it easier to analyze than raw text, but it doesn’t fit...
A Webinar Recap: Exploring Data Automation Levels with Kent Graziano
Our most recent webinar, "The Future of Data Warehousing: Understanding Automation Levels," hosted by Patrick O'Halloran, Solutions Architect, and esteemed guest speaker Kent Graziano dove into the transformative world of data warehouse automation. They discussed its...
WhereScape’s Supported Platforms: Accelerating Data Solutions Across the Board
The Future of Data Warehouse Automation with WhereScape Data warehouse automation represents a transformative shift in how businesses manage and utilize their data. WhereScape is at the forefront of this movement, offering tools that automate code generation,...
Overcoming Challenges with AI Hallucinations
Conversing with your digital assistant on your smartphone, using facial recognition for security, traveling in autonomous vehicles, or browsing recommended products based on your search history - there is no denying AI is embedded in many aspects of our lives. AI has...
Navigating Data Governance with WhereScape 3D
Properly managing and organizing data allows businesses to not only understand crucial patterns and trends, but also to leverage that data in strategic ways that grow revenue over time. Data drives decision-making and paves the way for innovation when used properly....
Deep Dive into WhereScape RED: Features and Benefits
Transforming a business’s various databases and files into actionable insights and reports is crucial, but incredibly time-consuming with traditional tools. Fortunately, with data warehouse automation tools like WhereScape RED, organizations can take advantage of a...
Brief Insights from Gartner® Latest Report on Data Fabric and Data Mesh
In the rapidly evolving world of data management, distinguishing between the myriad of strategies and technologies can be daunting. The latest Gartner® report, "How Are Organizations Overcoming Issues to Start Their Data Fabric or Mesh?" provides critical insights...
ETL vs ELT: What are the Differences?
In data management, the debate between ETL and ELT strategies is at the forefront for organizations aiming to refine their approach to handling vast amounts of data. Each method, ETL vs ELT, offers a unique pathway for transferring raw data into a warehouse, where it...
Embracing the Future of Data Management Recap: Insights from Mike Ferguson
In our recent webinar, "Embrace the Future of Data Management with Automated Cloud Data Warehousing," we had the privilege of diving into the transformative world of cloud data warehousing and highlighting the pivotal role of automation. Guided by our own Brad Kloth,...
Related Content
Maximizing Data Potential: Microsoft Fabric and WhereScape in Harmony
Forget gold. Forget oil. We are living in an era where data is our most precious commodity. As organizations strive for deeper insights into how their products perform, how their brand is perceived, and how customers behave, the need for stronger and more efficient...
Efficient Processing Techniques for JSON and Parquet Semi-Structured Data
Introduction to Semi-Structured Data and Its Importance Semi-structured data sits on the spectrum somewhere between traditional database tables and unstructured data. It has organizational properties that make it easier to analyze than raw text, but it doesn’t fit...
A Webinar Recap: Exploring Data Automation Levels with Kent Graziano
Our most recent webinar, "The Future of Data Warehousing: Understanding Automation Levels," hosted by Patrick O'Halloran, Solutions Architect, and esteemed guest speaker Kent Graziano dove into the transformative world of data warehouse automation. They discussed its...
WhereScape’s Supported Platforms: Accelerating Data Solutions Across the Board
The Future of Data Warehouse Automation with WhereScape Data warehouse automation represents a transformative shift in how businesses manage and utilize their data. WhereScape is at the forefront of this movement, offering tools that automate code generation,...