DBArtisan
Home | DBArtisan
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 DBArtisan, the award-winning DBA tool for enterprise-wide
database administration. DBArtisan empowers you to manage all of your critical
databases running on current versions of many different database systems, from
a single, consistent, user-friendly interface. Before you use DBArtisan, please
read the following information.
What's New in DBArtisan 18.7
Enhances security
authorizations
Adds support for Azure
DevOps for source control
Enhances DB2 performance
in DB Change Manager
Technical Requirements
32-bit versus 64-bit Application Considerations
and Restrictions
DBMS Support and Connectivity
Dedicated Support Connectivity Options
Generic JDBC/ODBC Connectivity
IBM Db2 for z/OS Stored Procedure Requirements
DBMS Versions No Longer Supported
Release Notes
Additional Resources
What's New in DBArtisan 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.
Technical Requirements
Before
using DBArtisan, please verify that your environment meets the requirements
listed below:
NOTE: Users need
full registry privileges during the installation and access to the keys under
HKEY_CURRENT_USER in the registry after installation.
DBArtisan
requires Microsoft Internet Explorer 11 or later.
IDERA recommends the following minimum hardware requirements:
DBArtisan supports the following operating systems:
32-Bit
Versus 64-Bit Application Considerations and Restrictions
If you install the 64-bit version of DBArtisan and you are using
custom drivers, you must be using 64-bit versions of those drivers when using
the 64-bit version of DBArtisan. Similarly, 32-bit versions of custom drivers
must be used with the 32-bit DBArtisan installation.
For version
control integration, if you install the 64-bit version of DBArtisan, you can
work with either a 32-bit or 64-bit MSSCCI provider. The feature is controlled
from the Options Editor's Version Control tab (File > Options >
General > Version Control).
Dedicated
Support Connectivity Options
DBArtisan provides dedicated connectivity to a specific version
range of databases.
The
following connectivity options are provided:
The
following table provides a summary of resources/requirements for connectivity
to dedicated DBMS platforms. For each platform, it lists supported versions,
the client software that must be installed if using native IDERA clients, and
the third-party, Type 4 JDBC drivers packaged with DBArtisan.
|
Supported Versions |
Client Required for
use with Native IDERA Drivers |
Packaged JDBC Driver |
Source & License |
|
|
Amazon Redshift |
|
|
|
|
|
Greenplum |
|
|
|
|
|
IBM Db2 for z/OS |
10.x and 11.x* |
DB2 UDB Client for
Windows 8.0 or later |
IBM Data Server Driver
for JDBC |
|
|
IBM Db2 for LUW |
10.x and 11.x* |
IBM DB2 LUW Client for
Windows 8.0 or later |
IBM Data Server Driver
for JDBC |
|
|
Microsoft Azure SQL
Database with AAD Support |
|
|
|
|
|
Microsoft SQL Server |
2008** 2016* 2017* 2019* 2022* |
Microsoft SQL Server
Client Library |
jTDS Type 4 JDBC Driver for Microsoft SQL Server |
|
|
MySQL |
4.x, 5.7, and 8.0 |
MySQL Connector/ODBC
Driver 5.2.x Driver - MySQL
Connector/ODBC driver 3.51.x Driver |
MySQL Connector/J JDBC
Driver |
|
|
Oracle |
10g**, 11g**, 11g R2**, 12c, 12c
R2, 18c, 19c, and 21c |
Oracle SQL*Net Client |
Oracle JDBC Thin
Driver |
|
|
Oracle Autonomous
Database |
|
|
|
|
|
PostgreSQL |
9.x, 10,
11, 12, 13, and 14 |
PostgreSQL ODBC Driver
(latest version recommended) |
PostgreSQL JDBC Driver |
|
|
Snowflake |
|
|
|
|
|
Sybase ASE |
15.7 and 16.0 |
Sybase Open Client |
jTDS Type 4 JDBC Driver for Microsoft SQL Server |
|
|
Sybase IQ |
15.4, 16.0, and 16.1 |
SQL Anywhere ODBC
drivers for Sybase IQ 12.7 |
Sybase jConnect JDBC Driver for Sybase IQ |
|
* DB PowerStudio 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 releases.
Generic JDBC/ODBC Connectivity
Generic JDBC/ODBC connectivity to non-dedicated DBMS systems or
non-database datasources is also provided. DBArtisan
can connect to a datasource using a
customer-provided, third-party JDBC version 4.0 or ODBC version 3.0 driver.
Minimal DBArtisan functionality is provided, including a basic Explorer tree
and SQL querying.
IBM Db2 for
z/OS Stored Procedure Requirements
When working against an IBM DB2 for z/OS data source, DBArtisan relies on
the following stored procedures, provided as an optional installation step in
setting up the DB2 subsystem:
·
DSNWZP
·
DSNUTILS
·
ADMIN_COMMAND_DSN
·
ADMIN_COMMAND_DB2
Prior to using DBArtisan against an IBM Db2 for z/OS data source, ensure that
these components are installed on the server.
Cloud
DBArtisan runs on cloud virtual machines, such as Microsoft Azure
VM and AWS EC2, with Microsoft Windows. It supports database instances on cloud
virtual machines, such as Microsoft Azure VM and AWS EC2.
DBMS Versions
No Longer Supported
DBArtisan is no longer being tested against Sybase ASE versions
before 15.7.
Release Notes
For
the more recent list of known issues and bug fixes in this release, see http://docwiki.embarcadero.com/DBArtisan/187/en/Release_Notes_for_DBArtisan_18.7.
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 Installation
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. 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.