Welcome to IDERA DB Optimizer 18.6.x

DB Optimizer Home | DB Optimizer Documentation | IDERA Technical Support | www.idera.com

ReadMe Last Published: Feb. 8, 2024. Any updates to these notes will be available at www.idera.com/support/productdocuments.


Thank you for using IDERA DB Optimizer, an enterprise SQL development and optimization tool that gives database developers and administrators the perfect environment for building the best performing SQL code. This application easily identifies inefficient SQL code and boosts developer productivity by ensuring SQL is right before it becomes a problem in mission-critical applications. DB Optimizer also provides a rich SQL IDE with code completion, real-time error checking, code formatting and sophisticated object validation tools. Lastly, DB Optimizer provides advanced project and data source management tools.

WaRNING:   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.

What's New in DB Optimizer 18.6

Allows users to connect to PostgreSQL through Azure Active Directory

Adds support for PostgreSQL profiling in DB Optimizer

Adds multi-factor authentication for MS SQL Server in DB Optimizer and DB Change Manager

Requirements

Hardware Requirements

Supported Operating Systems

Other Requirements

DBMS Support

SQL Execution, Tuning and DBMS Support

SQL Profiling and DBMS Support

Release Notes

Upgrade Notes

Known Issues

Bug Fixes

Additional Resources

Licensing Your IDERA Product

IDERA Product Support

IDERA Technical Support

IDERA on the Web

What's New in DB Optimizer 18.6

Allows users to connect to PostgreSQL through Azure Active Directory

This release of DB PowerStudio allows users to connect to PostgreSQL through Azure Active Directory.

Adds support for PostgreSQL profiling in DB Optimizer

DB Optimizer 18.5 allows users to select PostgreSQL for a profiling session.

Adds multi-factor authentication for MS SQL Server in DB Optimizer and DB Change Manager

DB Optimizer and DB Change Manager users now can use multi-factor authentication for Microsoft SQL Server.

Requirements

Before installing IDERA DB Optimizer, verify that your environment meets the following requirements.

Hardware Requirements

The following are the minimum hardware requirements:

Supported Operating Systems

DB Optimizer is supported on the following operating systems (32- and 64-bit):

Supported Cloud Platforms

DB Optimizer is supported on the following cloud platforms:

·        Amazon Elastic Compute Cloud (EC2)

·        Amazon Redshift

·        Microsoft Azure SQL Database with AAD Support

·        Microsoft Azure Virtual Machine (VM)

·        Oracle Autonomous Database (Profiling only)

·        Oracle Cloud Infrastructure***

·        Snowflake

DBMS Support

SQL Execution, Tuning and DBMS Support

SQL execution and SQL tuning with DB Optimizer is supported on the following DBMS platforms and versions:

SQL Profiling and DBMS Support

SQL profiling with DB Optimizer is supported on the following DBMS platforms and versions:

* For these databases, DB Optimizer supports a subset of this database version’s features/functions.

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

Note: DB Optimizer does not access the information, tables, or views licensed under Oracle's diagnostic pack.

Release Notes

Upgrade Notes

Known Issues

The SQL Server sqlvariant data type is not currently supported by the Microsoft JDBC driver. If a query is used to retrieve data from a table that contains a column of the sqlvariant data type, an exception occurs. There are two workarounds to fix this issue:

·        Use CAST to type cast the sqlvariant columns to the data type you want.

Or

·        Use the jTDS driver to connect.

Bug Fixes

For the most recent list of known issues and bug fixes in this release, see https://wiki.idera.com/display/DBO/Release+notes.

Additional Resources

Licensing Your IDERA Product

All IDERA products include a 14-day trial period. To continue using the product without interruption, we recommend that you license it as soon as possible. For information on licensing your product, refer to the Quick Start Guide. If you have not yet purchased this product, contact [email protected].

IDERA Product Support

The IDERA Web site is an excellent source for additional product information, including white papers, articles, and discussion forums. Visit www.idera.com, or click any of the links below, to find:

IDERA Technical Support

If you have a valid maintenance contract with IDERA, the Technical Support team is available to assist you with any problems you have with our applications. Our maintenance contract also entitles registered users of IDERA products to download free software upgrades during the active contract period. Evaluators receive free technical support for the term of their evaluation (14 days).

We encourage you to open technical support cases via the Customer Support Center. For additional information about IDERA Technical Support, visit the Support section of our Web site.

IDERA on the Web

To download evaluations of other IDERA products or to learn more about our company and our products visit us at www.idera.com.