Welcome to DBArtisan® 2016.0.1

DBArtisan Home | DBArtisan Documentation | Embarcadero Technical Support | www.embarcadero.com

ReadMe Last Published: February 1, 2016. Any updates to these notes will be available at http://docs.embarcadero.com.


Thank you for using Embarcadero 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 information below.


What's New in DBArtisan 2016

PostgreSQL Object Management

Analyst Explorer Node

Missing Indexes

ISQL Performance

Team Server 2016 Support

Technical Requirements

Browser Requirements

Hardware Requirements

Operating System Requirements

32-bit versus 64-bit Application Considerations and Restrictions

DBMS Support and Connectivity

Dedicated Support Connectivity Options

Generic JDBC/ODBC Connectivity

Specifically-tested JDBC/ODBC Connectivity Products: Apache Hive/Hadoop

Release Notes

Important Advisory Notes

Team Server 2016 Installation and Configuration

Known Issues

Bug Fixes

Additional Resources

Licensing Your Embarcadero Product

Embarcadero Product Support

Embarcadero Technical Support

Embarcadero on the Web

What's New in DBArtisan 2016

Postgresql Object Management

Wizard and Editor for Types have been added for PostgreSQL.

Analyst Explorer Node

The Analyst Node of the Explorer provides shortcuts to the License-specific Analyst Series tools. This shortcuts are:

Missing Indexes

In order to improve the performance of a system. The Missing Indexes feature analyze the system looking for Missing Indexes which once added would improve the performance. DBArtisan proposes you some Indexes to be created after analyzing the system, which can be created automatically from a Missing Index or from the dedicated wizard.

Only available for SQL Server.

ISQL Performance

SQL Editor includes the ISQL Performance functionality for SQL Server. ISQL Performance provides information about the SQL statements while you are writing in the SQL Editor. This information is included in a new window as well as listed in the Error Pane. It provides information like:

Only available for SQL Server.

Team Server 2016 Support

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.

Browser Requirements

DBArtisan requires Microsoft Internet Explorer 11 or later.

Hardware Requirements

Embarcadero recommends the following minimum hardware requirements:

Operating System Requirements

DBArtisan supports the following operating systems:

XP Support Notes - Windows XP has two user security groups: Users and Power Users. Microsoft intentionally does not grant members of the Users Group the authority to install applications or make global changes to the system. Restricted Users are members of the Users Group. Standard users belong to the Power Users Group. Microsoft grants members of the Power Users Group the authority to install programs. You must be a member of the Administrators Group in order to install and use Embarcadero applications. Because Restricted Users are members of the Users Group, they cannot install and run Embarcadero applications.

Use the Group Membership tab to determine your group and review the Microsoft security guidelines. On the Control Panel, open User Accounts. On the Users tab, select a user and then click the Properties button. Click the Group Membership tab.

Vista and Windows 7 Support Notes - Windows Vista UAC and Windows 7 provide 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).

DBMS Support and Connectivity Options

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 Teradate 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 Embarcadero clients, and the third-party, Type 4 JDBC drivers packaged with DBArtisan.


DBMS Platform Supported Versions Client Required for use with Native Embarcadero Drivers Packaged JDBC Driver Source & License
Apache Hive (Technical Preview) * 0.13.1 Simba Hive ODBC Driver ( v1.4.13.1013)
Hortonworks Hive ODBC Driver (v1.4.08.1008)
Cloudera ODBC Driver for Apache Hive (v2.05.10.1003)
Apache Software Foundation - Apache Hive JDBC v0.13.1 license
IBM DB2 for z/OS v8, v9, and v10 DB2 UDB Client for Windows 8.0 or later IBM Data Server Driver for JDBC
IBM DB2 for LUW Versions 9.0 - 10.0 IBM DB2 LUW Client for Windows 8.0 or later IBM Data Server Driver for JDBC
Microsoft SQL Server 2005 (All editions including 2005 Express Edition for 32-bit x86 and 64-bit Itanium & x86-64)
2008
2012
2014
Microsoft SQL Server Client Library jTDS Type 4 JDBC Driver for Microsoft SQL Server
Microsoft SQL Server JDBC Driver
LGPL source & license
MySQL 4.x MySQL Connector/ODBC Driver 5.2.x Driver - MySQL Connector/ODBC driver 3.51.x Driver MySQL Connector/J JDBC Driver GPL source & license
Oracle Oracle 9i, 10g, 11g, and 12c Oracle SQL*Net Client Oracle JDBC Thin Driver
PostgreSQL 9.3 minimum
Specifically-supported PostgreSQL-based database products include Greenplum, Pivotal HAWQ, and BigSQL.
PostgreSQL ODBC Driver (latest version recommended) PostgreSQL JDBC Driver BSD License
Sybase ASE Sybase 15.7 - Sybase 16 Sybase Open Client jTDS Type 4 JDBC Driver for Microsoft SQL Server
Sybase jConnect JDBC Driver
LGPL source & license
Sybase IQ 12.7 - 15.4, 16 SQL Anywhere ODBC drivers for Sybase IQ 12.7
Sybase IQ 32-bit ODBC drivers
Sybase jConnect JDBC Driver for Sybase IQ  
Teradata (Technical Preview) * 13.10, 14.0, 14.10, and 15.0 Teradata ODBC driver for Windows (version 15 recommended) Teradata JDBC Driver  

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.

Specifically-Tested JDBC/ODBC Connectivity Products: Apache Hive/Hadoop

DBArtisan has been successfully tested against Apache Hive/Hadoop datasources using the Hortonworks ODBC driver. Similarly, Cloudera Impala datasources have been tested using the Cloudera JDBC driver. In both cases, SQL querying and a Datasource Explorer/Navigator tree are available.

DBMS Versions No Longer Supported

As of this release, DBArtisan is no longer being tested against Sybase ASE versions before 15.7.

Release Notes

Important Advisory Notes

Team Server 2016 Installation and Configuration

Team Server 2016 must be installed and Configured in order to get its Datasource and Credential Syncronization in DBArtisan.

You can find all the information for installing Team Server 2016 in Install and Configure Team Server 2016.

Team Server URL must be also configured in DBArtisan. For that, add the Team Server URL in Tools > Options... > Team Server.

Known Issues


Bug Fixes

Bugs Fixed in DBArtisan 2016.0.1
Issue # Description DBMS
DBA-33166 Case Number 00455434: Invalid column name 'systemwide password expiration'. Sybase ASE
DBA-33159 [Enhancement] Change fillfactor default value to prevent space consumption and performance issues on index rebuild. SQL Server
DBA-33154 DBA-33150 [BCBSVT] [SQL Editor] Application crashes during SQL Editor session. DB2 for LUW
DBA-33152 DBA-33150 [Enhancement] Improve the exception handling in case of driver blowing up. Oracle
DBA-33151 DBA-33150 [ISQL] Nomura crashes. Oracle
DBA-33150 Find a solution to the random crashes experienced by customers. All
DBA-33141 [DBMS Object Management] Crash and inoperative state with views. DB2 for LUW
DBA-33108 Oracle 11g and higher already has a PLAN_TABLE installed. Oracle
DBA-33095 Provide support for SQL*PLUS script commands. Oracle
DBA-33076 [Analysts] Unable to run an analysis report. SQL Server
DBA-33068 [Enhancement][Functions]Some objects do leave out the schema name in the CREATE. SQL Server
DBA-33033 Customer case 00443195: Schedule of Capacity Analyst does not work on machines with Windows in Spanish. SQL Server
DBA-32999 [DBMS Object Management] Database option "allow incremental dumps" is not shown for Sybase 15.7 SP130. Sybase ASE
DBA-32987 [Edit Data] Copy-Paste from Edit Data grid returns weird characters. SQL Server
DBA-32967 [Schema extraction/publication] Can't execute schema extraction and schema publication with some DBMS. SQL Server
DBA-32960 In Edit Data, the DELETE of a row is not actually performed in the table. SQL Server
DBA-32959 [Enhancement]Migrate Database object is missleading. Sybase ASE
DBA-32945 [DBMS Object Management] Can't exchange a table partition. Oracle
DBA-32943 Unable to kill sessions from the Lock tab in Database monitoring. Sybase ASE
DBA-32935 Analyst update error on Oracle datasources ORA-01031: insufficient privileges. Oracle
DBA-32713 [Utilities] No records are migrated with migrated feature. Sybase ASE
DBA-32698 [ISQL] Crashes in Isql when running multiple scripts. All
DBA-31366 [DBMS Actions] Tables based on materialized views do not get extracted with the appropiate unique index. Oracle
RAP-6050 [JDBC][Procedures] Smallint being treated as bit datatype. SQL Server
RAP-6048 [Data Source Navigator] Occassional crashes when expanding databases node from the datasource navigator. SQL Server
RAP-6027 [Crash] Sybase IQ customer crashes. Sybase IQ
Bugs Fixed in DBArtisan 2016
Issue # Description DBMS
DBA-32830 Not consistently opening SQL files from location set in Directories option for "User SQL Scripts".
DBA-32585 Lapsed time clock at the bottom of a Query/Results tab frame no longer works. Oracle
DBA-32474 [File Execution Facility] After row 43, Dates are being returned as zeros. All
DBA-32472 [Regression][DMBS Actions] Hide time portion of DATE datatype if zero option suppresses the time portion for all rows, even if they have non-zero times. Oracle
DBA-31935 [Schema Extraction] When extracting or compiling Function, the comments are missing from Function. Oracle
DBA-30919 [DBMS Actions] Ability to name output file. All
DBA-22901 Request support for Excel 2007. All
DBA-22732 [Editor results]Request for support for the option to save the result in Excel binary format, extension xlsb. All
DBA-4638 Wrong database device size is displayed in Explorer window. Sybase ASE
RAP-5970 Customer case 00430700: The application generates a corrupt xlsx file when importing results to Excel. Oracle
RAP-5865 [Tools] Ability to save a .csv file from results where all the fields are enclosed in double quotes. Oracle
RAP-5742 508 compliance for the application: JAWS incorrectly reads the drop-down options that have seperators.  

Additional Resources

Licensing Your Embarcadero Product

All Embarcadero 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 DBArtisan Installation Guide. If you have not yet purchased your Embarcadero product, contact sales@embarcadero.com, or uk.sales@embarcadero.com for sales in the EMEA region.

Embarcadero Product Support

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

Embarcadero Technical Support

If you have a valid maintenance contract with Embarcadero, the Embarcadero Technical Support team is available to assist you with any problems you have with our applications. Our maintenance contract also entitles registered users of Embarcadero 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 Technical Support request form. For additional information about Embarcadero Technical Support, visit the Support section of our Web site.

Embarcadero on the Web

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