Announcing General Availability of DB PowerStudio, version 18.2

by Sep 1, 2022

IDERA’s DB PowerStudio provides a powerful cross-platform toolset for database development, tuning and database management.

What’s new in DB PowerStudio version 18.2

We are excited to announce that we have added Snowflake data warehouse support for DBArtisan and Rapid SQL users!

Snowflake’s data warehouse is a fully managed system that’s simple to use yet can power a near-unlimited number of concurrent workloads.  These users will now be able to take advantage of the performance, flexibility, and scalability of DB PowerStudio to easily load, integrate, analyze, and securely share data within the Snowflake platform. 

Product Enhancements for Snowflake customers

  • Snowflake-native authentication – implements the standard username and password authentication for Snowflake to securely retrieve and use objects.

  • Single sign-on support – reduces the number of attack surfaces because users only log in once each day and only one set of credentials are used.

  • Key pair authentication support – benefits the user by assigning asymmetric public and private keys. This authentication can be used as an alternative to password authentication. 

 

DBArtisan and Rapid SQL updated support for current database versions

  • Upgraded support for PostgreSQL from version 12.0 to 13.0.

  • Upgraded support for Oracle Database from version 19.0 to 21C. 

 

Customers continue to derive the following benefits from DB PowerStudio 18.2

  • Appropriate functioning of all tree nodes, extracts and alters for DBArtisan and Rapid SQL.

  • Manage multiple platforms (SQL Server, Azure SQL Database, Oracle Database, Sybase ASE and IQ, Db2 LUW and z/OS, Redshift, MySQL, PostgreSQL, Greenplum and now Snowflake) from one GUI.

  • Proactively manage space, data and performance with built-in analytics.

  • Easily find and fix performance issues using intelligent diagnostics.

  • Move schema and table data across different platforms with ease.

  • Protect data security with view, grant and revoke of permissions.

 

For a more detailed list of the improvements, please refer to the  DB PowerStudio 18.2.

Product Links for this release