- by Dave Paul, WhereScape RED Global Product Manager
We’ve taken the wraps off the latest version of WhereScape RED and delivered a slew of new features you’ve been asking for. There are three big themes in WhereScape RED 126.96.36.199 update: Compatibility, Flexibility and Convenience.
Compatibility means WhereScape RED works with more databases and languages than ever before.
Flexibility means WhereScape RED works on-premise or in the cloud (and across both), on 32-bit or 64-bit architectures.
And Convenience means the power to work the way you want to, including through a powerful dedicated command line interface.
Let’s look at the top new features in more detail.
1. Dedicated command line interface
We know you love your command line interface and we’re pleased to include this feature in 188.8.131.52. While WhereScape RED has always offered the option for a limited number of actions via arguments for both the WhereScape RED and Setup Administrator applications, the advent of DevOps has rendered this approach inadequate. With the emergence of dedicated teams for software installation, data warehouse development, code deployment and operational running and monitoring of ELT processing, REDCLI means each team can perform interactions with WhereScape RED from a familiar interface, within your own application (no need to fire up the WhereScape RED GUI, in other words).
As an example, a release management team can promote an approved update to a subset of the data warehouse without using a WhereScape GUI: do it through the REDCLI. Fast, simple and the way you like to work.
2. WhereScape RED is a 64-bit application (and handles 32-bit just as well)
Yes, there’s still an awful lot of 32-bit out there. Also yes, 64-bit architectures are emerging on the scene and fast. Now you can use one WhereScape RED across both.
Before this release WhereScape RED was a 32-bit application and predominately interacted with metadata, data warehouse and source system databases via 32-bit database drivers. From this release, WhereScape RED is now a 64-bit application and can interact with databases via 64-bit drivers or, using a unique bridge, via 32-bit drivers if 64-bit drivers are not available.
This greatly expands the databases that WhereScape RED will work with, allowing it to cater for both old and new. What you’ll notice in the interface is that when selecting ODBC, you get to choose whether 32 or 64-bit; depending on that choice, WhereScape RED will talk to 64-bit natively, or 32-bit via the bridge.
This feature also means you can easily work in the typical mixed environments of today’s technology landscape. It’s the best of both worlds and provides a soft migration path from 32 to 64-bit.
3. Support for additional host script languages
To date, the code generated to create and populate data warehouse objects on database platforms such as SQL Server, Oracle and Teradata was predominately database-stored procedures.
But the world is changing, and cloud data warehousing is increasingly attractive for multiple reasons. The trouble is, some cloud database technologies don’t support stored procedures.
In these cases, we recommend the code to create objects and populate them is instead developed in your preferred host script language. In previous versions of WhereScape RED this was often Korn shell for Unix and PowerShell for Windows; today, in WhereScape RED 184.108.40.206 the host script language is extensible so, for example, Python scripts can now be generated and executed. In fact, WhereScape RED can now be configured to support the language you prefer. That’s maximum flexibility which lets you work your preferred way.
4. Generate and run host scripts for secondary processing of a data warehouse table
Each WhereScape RED data warehouse table has two update routines associated with it. Often, only one is used to populate the table’s data for each pass of the ELT. But a secondary update routine can be used for either secondary processing or specific processing on a different frequency to the main routine (e.g. weekly or monthly). For newer data warehouse databases, the secondary update routine was limited to SQL blocks; not any more. The latest WhereScape RED allows generation of the secondary routine in any defined host script language.
Yes, this is a great development for cloud data warehouses. Along with feature 3 above, it means more flexibility to use the language and platforms you choose
5. Introduction of a new template and script editor
In addition to the REDCLI, we’ve added a new template and script editor. Templates are the heart of the extensible WhereScape RED model, essentially the engine that generates code. WhereScape RED now includes an enhanced text editor for the modification of generated host scripts and for customisation of templates used for code generation offering the features added to the procedure editor in the previous release
Some of the highlights of this new editor include contextual syntax highlighting, improved find and replace, line numbering, case conversion features etc.
6. Enhancement to multi-database support for SQL Server customers
Finally, while much of the focus for the new release of WhereScape RED is extensibility and broader data warehouse database support, there are many features added for existing data warehouse databases. One such example is an enhancement to multi-database support for SQL Server customers.
For 18 months WhereScape RED has allowed SQL Server customers to distribute their data warehouse tables and indexes across multiple databases on the same server. But all the generated stored procedures were stored in the WhereScape RED metadata database.
The WhereScape RED metadata objects and data warehouse objects can now be further separated, with the stored procedures stored in a data warehouse database (by default the same database as the associated table).
Do more with WhereScape RED, today
These new features give you the ability to create and manage data warehouses better and faster, work with cloud solutions like Snowflake, RedShift and Azure in addition to SQL Server, Oracle, Teradata and others, with WhereScape RED outputting the code you prefer.
This latest release builds upon the feature-rich extensible model first introduced over two years ago, with the templates delivering the more power and depth of capability to meet all your data warehouse automation requirements.
It’s the WhereScape RED you know and love, ready for the future. Upgrade immediately and take advantage today.