Rapid SQL Home | Rapid SQL Documentation | Embarcadero Technical Support | www.embarcadero.com
ReadMe Last Published: May 6, 2014. Any updates to these notes will be available at http://docs.embarcadero.com.
Thank you for using Embarcadero Rapid SQL, the integrated development environment for IBM DB2, Microsoft SQL Server, MySQL, Oracle, Sybase, and Teradata database systems. Rapid SQL is your fast path to higher productivity whether you're programming in SQL, PL/SQL, Transact-SQL, HTML or Java. Before you use Rapid SQL, please read the information below.
What's New in Version 8.6.1/XE5
What's New in Version 8.6/XE5
Other New DBMS Version Support
DBMS Support and Connectivity
Generic JDBC/ODBC Connectivity
Specifically-tested JDBC/ODBC Connectivity Products: Apache Hive/Hadoop
DBMS Versions No Longer Supported
Release Notes
Additional Resources
Licensing Your Embarcadero Product
Embarcadero Technologies Product Support
Embarcadero Technologies Technical Support
Embarcadero Technologies on the Web
What's New in Version 8.6.1/XE5
DB Team Server
In previous releases, Rapid SQL integrated with Embarcadero Connect, a data governance and metadata repository. Rapid SQL users could make use of datasource definitions and ER/Studio data model information stored on the repository as well as open a browser window to work directly against Embarcadero Connect.
Rapid SQL features that were previously available through the Embarcadero Connect integration are now available against Embarcadero DB Team Server. New DB Team Server features now available in DBArtisan are:
What's New in Version 8.6/XE5
64-bit Installation
Rapid SQL now runs as a native 64-bit application. Separate installers let you choose between 32-bit and 64-bit applications. See Important Advisory Notes for more information.
Windows 8 Support
Rapid SQL is now fully supported on the Windows 8 operating system. For information specific to Windows 8.1, see Important Advisory Notes.
Teradata Support
This release provides a Technical Preview of support for Teradata versions 13.10, 14, and 14.10. Specifically, version 12 syntax is supported. Connectivity is available with either of the Teradata ODBC or JDBC drivers (installed, with all Teradata prerequisites satisfied). Functionality as of the current release is as follows:
Teradata access is not covered under XE or trial licenses. Contact [email protected] for a separate Teradata license.
Other New DBMS Version Support
As of this release, Rapid SQL provides full support for the following DBMS platform versions:
Sybase ASE Updates
Against version 15.7 datasources, the Login Wizard/Editor now generates DDL that uses CREATE/ALTER LOGIN syntax. New properties let you work with SUID, LOGIN PROFILE, and EXEMPT INACTIVE LOCK parameters. The Change Login Password, Add/Modify Login Trigger, and Drop Login Trigger actions have also been updated to generate DDL that uses ALTER LOGIN syntax.
DB2 LUW Updates
The Update Statistics object action has been updated to use the ADMIN_CMD system procedure. This eliminates the constraint to have target datasources registered by alias and using the native client. Update Statistics can now be used against all datasources, regardless of how they were registered.
SQL Server Updates
A new Enable/Disable Filetable(s) action lets you build and submit an ALTER TABLE statement, specifying either an ENABLE FILETABLE_NAMESPACE or DISABLE FILETABLE_NAMESPACE argument. This enables or disables system-defined constraints on a FileTable.
Oracle Updates
If the Oracle SQL*Net Client is not installed, Rapid SQL/DBArtisan will attempt to connect to an Oracle datasource using the Oracle Database Instant Client.
Query Builder
As of this release, when you add the same table to the diagram pane multiple times, a new alias is automatically assigned to each instance. Adding a table multiple times can be useful when selecting additional data from the table, based on different join criteria.
DBMS SUPPORT AND CONNECTIVITY OPTIONS
DEDICATED SUPPORT CONNECTIVITY OPTIONS
Rapid SQL provides dedicated connectivity to a specific version range of IBM DB2 for Linux, Unix, and Windows, IBM DB2 for z/OS, InterBase/Firebird, Microsoft SQL Server, MySQL, Oracle, and Sybase 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, driver, or client/driver combination that must be installed if using native Embarcadero clients, and the third-party, Type 4 JDBC drivers packaged with Rapid SQL.
DBMS Platform | Supported Versions | Client (or driver/client combination) Required for use with Native Embarcadero Drivers | Packaged JDBC Driver |
---|---|---|---|
Firebird | Firebird 2.0 | Firebird ODBC Driver | Jaybird JDBC Driver |
IBM DB2 for z/OS | v8, v9, and v10 | DB2 UDB Client for Windows 9.0 or later | IBM Data Server Driver for JDBC |
IBM DB2 for LUW | Versions 9.0 - 10.0 | IBM DB2 LUW Client for Windows 9.0 or later | IBM Data Server Driver for JDBC |
InterBase | InterBase 2007
InterBase 2009 InterBase XE3 |
InterBase ODBC Driver | Interbase JDBC Driver |
Microsoft SQL Server |
2005 (All editions including 2005 Express Edition for 32-bit x86 and 64-bit Itanium & x86-64)
2008 2012 |
Microsoft SQL Server Client Library | jTDS Type 4 JDBC Driver for Microsoft SQL Server
Microsoft SQL Server JDBC Driver |
MySQL | 4.x | MySQL Connector/ODBC Driver 5.2.x Driver - MySQL Connector/ODBC driver 3.51.x Driver | MySQL Connector/J JDBC Driver |
Oracle | Oracle 9i, 10g, 11g, and 12c | Oracle SQL*Net Client | Oracle JDBC Thin Driver |
Sybase ASE | Sybase System 12.5 - Sybase 15.7 | Sybase Open Client | jTDS Type 4 JDBC Driver for Microsoft SQL Server
Sybase jConnect JDBC Driver |
Sybase IQ | 12.7 - 15.4 | SQL Anywhere ODBC drivers for Sybase IQ 12.7
Sybase IQ 32-bit ODBC drivers |
Sybase jConnect JDBC Driver for Sybase IQ |
Teradata | 13.10, 14, and 14.10 | Teradata ODBC driver for Windows (version 14 recommended) | Teradata JDBC Driver |
GENERIC JDBC/ODBC CONNECTIVITY
Generic JDBC/ODBC connectivity to non-dedicated DBMS systems or non-database datasources is also provided. Rapid SQL can connect to a datasource using a customer-provided, third-party JDBC version 3.0 or ODBC version 3.0 driver. Minimal Rapid SQL functionality is provided, including a basic Explorer tree and SQL querying.
SPECIFICALLY-TESTED JDBC/ODBC CONNECTIVITY PRODUCTS: APACHE HIVE/HADOOP
Rapid SQL 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 Navigator tree are available.
DBMS VERSIONS NO LONGER SUPPORTED
As of this release, Rapid SQL is no longer tested against Microsoft SQL Server 2000 or IBM DB2 for Linux, Unix, and Windows 8.x.
Release Notes
IMPORTANT ADVISORY NOTES
Similarly, if you are using custom drivers, as of the 8.6 release, you must be using 64-bit versions of those drivers when using the 64-bit version of Rapid SQL.
KNOWN ISSUES
BUG FIXES
Bugs Fixed in Embarcadero Rapid SQL 8.6.1/XE5 | ||
---|---|---|
Issue # | Description | DBMS |
RAP-5829 | Top header in the Results tab when there are multiple results in the grid is copied with the results | ALL |
RAP-5833 | [SQL Editor]Explain feature results cannot be opened when saved as file format CSV | ALL |
RAP-5852 | [ISQL Editor] Alt-W shortcut for "wrap around search" on the Find dialog no longer works. | ALL |
RAP-5859 | [SQL Editor] XML being truncated | ALL |
RAP-5830 | [DBMS Actions] Last column-name is lost in results followed by warning. | Oracle |
RAP-5837 | [SQL Editor] Bind variable pops up when creating or updating triggers. | Oracle |
RAP-5855 | [Application] Application crashes when executing a procedure due to unhandled parameter types | Oracle |
Bugs Fixed in Embarcadero Rapid SQL 8.6/XE5 | ||
---|---|---|
Issue # | Description | DBMS |
RAP-5841 | [SQL Execution] query takes longer to execute than in previous attempts | SQL Server |
Additional Resources
Licensing Your Embarcadero Technologies Product
All Embarcadero Technologies 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 Rapid SQL Installation Guide. If you have not yet purchased your Embarcadero Technologies product, contact [email protected], or [email protected] for sales in the EMEA region.
Embarcadero Technologies Product Support
The Embarcadero Technologies 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 Technologies Technical Support
If you have a valid maintenance contract with Embarcadero Technologies, 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 Technologies 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 Technologies Technical Support, visit the Support section of our Web site.
Embarcadero Technologies on the Web
To download evaluations of other Embarcadero Technologies products or to learn more about our company and our products visit us at www.embarcadero.com.