DB Optimizer 17.0.1 and later cannot use any workspaces produced by previous DBO versions, nor use any files created by those older workspaces.
DB Optimizer provides the following new features and fixed issues. For items introduced or fixed in an earlier release, see Previous features and fixed issues.
18.3 New features
Updates Azure cloud monitoring capability in DBArtisan
The monitoring capability for Microsoft Azure cloud is updated in DBArtisan. This functionality includes multi-tabbed process monitoring and management as well as allows you to catch performance issues before they arise.
Supports the latest version of Log4j
DB PowerStudio 18.3 includes support for the latest version of Apache Log4j, which is essential for proper logging and diagnostics of applications.
Improves multiple areas within DBArtisan and Rapid SQL
DB PowerStudio 18.3 includes updates to the following areas within DBArtisan and Rapid SQL:
- Extraction operations on roles for PostgreSQL allows users to have higher control over their data security.
- Handling procedures with cascaded parameters on Redshift provides additional usage options with those parameters.
- Connections to Azure SQL using multi-factor authentication provides more secure access.
- Connections to PostgreSQL via Java Database Connectivity (JDBC) provides native connectivity for quicker access.
- Reordering columns for Data Definition Language (DLL) validation allows the flexibility to rerun or reuse in scripts.
Improves multiple areas within DB Change Manager
- Validation of Dump Devices, Linked Servers, Remote Servers and Server Triggers on Azure enables higher quality of those features.
- Reuse of connection settings on logins when a node is accessible in SQL Server Management Studio (SSMS) allows faster user connections.
- Fully populating database nodes on Azure for completeness.
Updates profiling session capability in DB Optimizer
DB Optimizer 18.3 updates profiling session capability, which alerts users to potentially problematic SQL ahead of time.
18.3 Fixed issues
| Issue Number | Description | DBMS |
|---|---|---|
| DBA-34744 | Log4J Upgrade all of DB PowerStudio | |
| DBA-34743 | DDL validation failing after reordering columns | Oracle |
| DBA-34682 | Windows Authentication not working with Access Analyst | SQL Server |
| DBA-34605 | Cannot connect to Azure SQL using MFA | Azure SQL |
| DBA-34524 | Receiving an error when trying to connect to PostgreSQL | PostgreSQL |
| DBA-34244 | User would like additional features for Azure support | Azure SQL |
| OPT-5352 | Profiling session does not finish and seems to stall | Sybase ASE |
18.2 New features
Adds support for Snowflake in DBArtisan and Rapid SQL
DB PowerStudio 18.2 adds support for Snowflake in DBArtisan and Rapid SQL.
Adds support for Windows 11
DB PowerStudio now supports the Microsoft Windows 11 operating system.
Updates database platform support
This release of DB PowerStudio includes updated support in DBArtisan and Rapid SQL for the following database platforms:
- DB2 LUW 11.5
- Sybase IQ 16.1
Updates trial licensing in DB Optimizer
This release of DB PowerStudio includes updated trial licensing support for DB Optimizer to limit the number of suggestions a user can submit.