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 220.127.116.11 update: Compatibility, Flexibility and Convenience.
Compatibility meansWhereScape RED works with more databases and languages than ever before.
Flexibility meansWhereScape REDworks 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 18.104.22.168. WhileWhereScape RED has always offered the option for a limited number of actions via arguments for both theWhereScape REDand 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 withWhereScape REDfrom a familiar interface, within your own application (no need to fire up theWhereScape REDGUI, 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 oneWhereScape RED across both.
Before this release WhereScapeRED 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 REDis 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 thatWhereScape REDwill 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 REDwill 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 ofWhereScape REDthis was often Korn shell for Unix and PowerShell for Windows; today, inWhereScape RED22.214.171.124 the host script language is extensible so, for example, Python scripts can now be generated and executed. In fact,WhereScape REDcan 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
EachWhereScape REDdata 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 latestWhereScape REDallows 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 extensibleWhereScape REDmodel, essentially the engine that generates code.WhereScape REDnow 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 ofWhereScape REDis 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 monthsWhereScape REDhas 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 theWhereScape REDmetadata database.
TheWhereScape REDmetadata 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 withWhereScape 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, withWhereScape REDoutputting 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 yourdata warehouse automation requirements.