DB PowerStudio DBArtisan Technical Specifications

What's New in 18.6

For the new features and fixed issues in the latest version of DBArtisan, see What's New.

System Requirements

* DBArtisan supports only a subset of features and functions for this database version.

** Support for this version is nearing end of life and may not be available in subsequent DBArtisan releases. 

Version History

Version 18.6

• Provides full GIT support
• Allows users to connect to PostgreSQL through Azure Active Directory
• Allows Redshift authentication through IAM
• Adds support for PostgreSQL profiling in DB Optimizer
• Adds multi-factor authentication for MS SQL in DB Optimizer and DB Change Manager

Version 18.5

• Adds binary column support for Db2 for LUW
• Improves synchronization script in DB Change Manager
• Improves efficiency in DBArtisan, DB Change Manager, and Rapid SQL
• Updates stored procedures functionality when using Redshift
• Updates supported database versions

Version 18.4

• Adds native GIT support
• Supports SQL Server 2022
• Improves space, capacity, and performance for Azure SQL and PostgreSQL
• Includes sign-on for AzureAD for PostgreSQL, MySQL, and SQL Server
• Includes support for PostgreSQL identity columns
• Updates Azure SQL for Data Copying in DB Change Manager

Version 18.3

• Updates Azure cloud monitoring capability in DBArtisan
• Supports the latest version of Log4j
• Improves multiple areas within DBArtisan and Rapid SQL
• Improves multiple areas within DB Change Manager
• Updates profiling session capability in DB Optimizer

Version 18.2

• Adds support for Snowflake in DBArtisan and Rapid SQL

• Adds support for Windows 11

• Updates database platform support for the following database platforms:

  • DB2 LUW 11.5

  • Sybase IQ 16.1

• Updates trial licensing in DB Optimizer to limit the number of suggestions a user can submit

Version 18.1

• Adds support for Oracle 21c and PostgreSQL 13

Version 18.0

• Adds support for Amazon Redshift cloud data warehouse

Version 17.1.0

• Improves operating system and platform support
  • Windows Server 2019
  • Oracle 11g R2
  • PostgreSQL 12.x
  • SQL Server 2014 SP2

Version 17.0.4

• Supports latest SQL Server, Oracle, PostgreSQL editions

Version 17.0.3

There are no new features for this product version release.

Version 17.0.2

There are no new features for this product version release.

Version 17.0.0

• Improved SQL Server feature plan
  • Table and index compression
  • Columnstore index support
  • Spatial index support
  • Temporal tables support
  • In-memory tables support
  • Natively-compiled procedures support
  • Column-level encryption support
  • Table encryption support
  • Data masking support
• Improved Execution Plan support
• Supports visual file group, data file, and log file
• Improved Databases Summary Detail screen
• Improved server roles 
• Added print capability to Index CREATE and ALTER scripts
• Improved debugger

Version 16.6.1

• Improved data dictionary lookup and caching
• Performance improvements
• Completes support for Oracle 12c

Version 16.6.0

• Extract, Migrate, and Report functionality completed for Oracle object types added in v16.5
• Supports additional Oracle object types
• Improved Explain Plan support
• Supports Db2 LUW 11 and Sybase 16

Version 16.5 (2016+)

• IDERA rebranding
• Product licensing changes
• Single Java directory for multiple IDERA products
• Improved password security
• Error reporting for troubleshooting
• Improved performance and exception handling
• Updated Database Explorer schema object types
• Supports newer partitioning options

Version 16.0 (2016)

• PostgreSQL object management
• Analyst Explorer node
• Missing indexes
• ISQL performance

IDERA |  Products | Purchase | Support |  Resources |  About Us  | Legal