DB
Optimizer Home | DB Optimizer
Documentation | IDERA
Technical Support | www.idera.com
ReadMe
Last Published: July 17, 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.7
Enhances security authorizations
Adds support for Azure DevOps for source control
Enhances DB2 performance in DB Change Manager
Requirements
DBMS Support
SQL Execution, Tuning and DBMS Support
SQL Profiling and DBMS Support
Release Notes
Additional Resources
What's New in DB Optimizer 18.7
Enhances security authorizations
DB PowerStudio 18.7 users
can now leverage multi-factor authentication (MFA) using the identity provider
Microsoft Entra, formerly Azure Active Directory (AD), when connecting to
Oracle. When logging into Oracle, you can users gain the inherent security
policies and procedures from Microsoft Entra by entering your password only
once.
Adds support for Azure DevOps for source
control
This release of DBArtisan and Rapid SQL includes support for Azure
DevOps for source control. Users gain the benefits of planning, collaborating,
and code development using Azure DevOps Git repository for Project management.
This feature allows developers to log in to Azure DevOps via a token and manage
their code for history, check-in, and checkout capabilities.
Enhances DB2 performance in DB Change Manager
DB Change Manager 18.7 users can take advantage of the added
options in DB2 Data Synchronization to optimize performance, by maintaining
data integrity, and therefore avoiding bottlenecks by making sure the data is
accurate. There also are additional options that improve comparisons of
Triggers and Sequence Columns, providing the user the benefit of constancy
across schemas.
Requirements
Before
installing IDERA DB Optimizer, verify that your environment meets the following
requirements.
The following are the minimum hardware requirements:
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
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
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
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:
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.
To download evaluations of other IDERA products or to learn more
about our company and our products visit us at www.idera.com.