DBArtisan
Home | DBArtisan
Documentation | IDERA
Technical Support | www.idera.com
ReadMe
Last Published: August 19, 2019. 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 IBM DB2, Oracle, PostgreSQL, Microsoft
SQL Server, MySQL, Sybase and Teradata systems, from a single, consistent,
user-friendly interface. Before you use DBArtisan, please read the following
information.
What's New in DBArtisan 17.0.4
Added Support for Latest SQL Server, Oracle,
and Postgres Versions
What's New in DBArtisan 17.0.3
What's New in DBArtisan 17.0.2
What's New in DBArtisan 17.0.0
Improved SQL Server Feature Plan Support
Improved Execution Plan Support
Improved Databases Summary Detail Screen
Improved Server Roles Functionality
Added Print Capability to Index CREATE and
ALTER Scripts
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 17.0.4
added support for latest sql Server, oracle, and
postgres versions
DBArtisan 17.0.4 adds support for SQL Server 2019, Oracle 19c, and
Postgres 11.2.
Fixed Issues
This release also includes a number of fixed issues that you may
review in the Release
Notes.
What's New in DBArtisan 17.0.3
Fixed Issues
There are no new features in DBArtisan 17.0.3. This release does
include a number of fixed issues that you may review in the Release
Notes.
What's New in DBArtisan 17.0.2
There are no new features in DBArtisan 17.0.2. This release does
include a number of fixed issues that you may review in the Release
Notes.
What's New in DBArtisan 17.0.0
Improved SQL
Server Feature Support
DBArtisan 17.0 improves SQL Server feature support with new
functionality including:
·
Table and index compression
·
Columnstore Index
support
·
Primary and Secondary XML Index support
·
Spatial Index support
·
Data Masking support
·
Temporal Tables support
·
In-Memory Tables support
·
Natively-Compiled Procedures support
·
Table Encryption support
·
Check Constraints support
Improved Execution Plan Support
Execution plans now offer the ability to display the estimated
plan and the actual plan as well as the ability to view the query plan as a
graph, tree, or XML.
DBAs now can use file groups, data files, and log files in the
Server Storage section of DBArtisan to visualize the high-level usage and
status of their disk space. User-defined filegroups
can be created to group data files together for administrative, data
allocation, and placement purposes.
Improved Databases Summary Detail
screen
The Databases Summary Detail screen now provides the Source Database column to signify
whether the database is a snapshot copy of another database.
Improved Server Roles Functionality
The Server Roles tab no longer allows for hierarchical server
roles.
Added Print capability to Index
CREATE and ALTER Scripts
Users now can print Index CREATE or ALTER errors as shown.
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:
Windows
7 Support Notes - Windows 7 provides two user types: Standard users and
Administrators. DBArtisan can be installed or uninstalled by an administrator
or by a standard user using an administrator token. Standard users can run
DBArtisan. For the purpose of running DBArtisan, default standard user token
privileges should not be modified. Modifying standard user token privileges can
result in licensing issues which will prevent DBArtisan from operating
properly.
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 IBM DB2 for Linux, UNIX, and
Windows, IBM DB2 for z/OS, Microsoft SQL Server, MySQL, PostgreSQL, Oracle,
Sybase, and Teradata 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.
|
DBMS Platform |
Supported Versions |
Client Required for
use with Native IDERA Drivers |
Packaged JDBC Driver |
Source & License |
|
IBM DB2 for z/OS |
9 – 10.x and 11.x* |
DB2 UDB Client for
Windows 8.0 or later |
IBM Data Server Driver
for JDBC |
|
|
IBM DB2 for LUW |
9 – 10.x and 11.x* |
IBM DB2 LUW Client for
Windows 8.0 or later |
IBM Data Server Driver
for JDBC |
|
|
Microsoft SQL Server |
2008 2016* 2017* 2019* |
Microsoft SQL Server
Client Library |
jTDS Type 4 JDBC Driver for Microsoft SQL Server |
|
|
MySQL |
4.x and 5.x |
MySQL Connector/ODBC
Driver 5.2.x Driver - MySQL
Connector/ODBC driver 3.51.x Driver |
MySQL Connector/J JDBC
Driver |
|
|
Oracle |
9i, 10g, 11g, 12c, and 19c |
Oracle SQL*Net Client |
Oracle JDBC Thin
Driver |
|
|
PostgreSQL |
9.3, 9.4,
9.5, 9.6.x, and 11.2 |
PostgreSQL ODBC Driver
(latest version recommended) |
PostgreSQL JDBC Driver |
|
|
Sybase ASE |
12.5 - 15.7, 16.0 |
Sybase Open Client |
jTDS Type 4 JDBC Driver for Microsoft SQL Server |
|
|
Sybase IQ |
12.7 - 15.4, 16.0 |
SQL Anywhere ODBC
drivers for Sybase IQ 12.7 |
Sybase jConnect JDBC Driver for Sybase IQ |
|
* About Technical
Previews - Technical previews are intended to introduce a new DBMS platform
only. The available functionality is typically minimal. For example, command
Line startup, standard datasource registration and connection features, limited
Datasource Navigator tree functionality, a minimal set of object actions, as
well as SQL Editor execution and related, common SQL Editor functionality such
as Query Options, Paste SQL Syntax, and Paste SQL Statement.
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/170/en/Release_Notes_for_DBArtisan_17.0.
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.