Rapid SQL Home | Rapid SQL Documentation | Embarcadero Technical Support | www.embarcadero.com
ReadMe Last Published: Junly 23, 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, PostgreSQL, 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.7/XE6
Technical Requirements
32-bit versus 64-bit Application Considerations and Restrictions
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.7/XE6
PostgreSQL Support
This release introduces support for PostgreSQL datasources, PostgreSQL version 9.3 and higher. Connectivity is available with the PostgreSQL ODBC Driver (version 9.02 minimum) or with the pre-packaged PostgreSQL JDBC Driver. Functionality as of the current release is as follows:
TECHNICAL REQUIREMENTS
Before using Rapid SQL, 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.
HARDWARE REQUIREMENTS
Embarcadero Technologies recommends the following minimum hardware requirements:OPERATING SYSTEM REQUIREMENTS
Rapid SQL 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 Technologies applications. Because Restricted Users are members of the Users Group, they cannot install and run Embarcadero Technologies 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. Rapid SQL can be installed or uninstalled by an administrator or by a standard user using an administrator token. Standard users can run Rapid SQL. For the purpose of running Rapid SQL, default standard user token privileges should not be modified. Modifying standard user token privileges can result in licensing issues which will prevent Rapid SQL from operating properly.
32-BIT VERSUS 64-BIT APPLICATION CONSIDERATIONS AND RESTRICTIONS
If you install the 64-bit version of Rapid SQL and you are using custom drivers, you must be using 64-bit versions of those drivers when using the 64-bit version of Rapid SQL. Similarly, 32-bit versions of custom drivers must be used with the 32-bit Rapid SQL installation.If you install the 64-bit version of Rapid SQL and want to interface with your source control system, your source control system must be 64-bit compliant. If you are using a 32-bit source control system, or a 64-bit source control system running in 32-bit compatibility mode, Rapid SQL cannot interface with it.
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, PostgreSQL, 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, 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 |
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 |
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.
RELEASE NOTES
IMPORTANT ADVISORY NOTES
KNOWN ISSUES
BUG FIXES
Bugs Fixed in Embarcadero Rapid SQL 8.7/XE6 | ||
---|---|---|
Issue # | Description | DBMS |
RAP-5430 | SQL tabs of scripts associated with workspaces (1-3) do not persist when application is restarted. This worked in RS742 | All |
RAP-5439 | Extraction of multiple tables generates wrong code: WITH ( WITH FILLFACTOR=90) | SQL Server |
RAP-5832 | [SQL Editor] running a query plan get incorrect results when have left over explains in the DB2 explain tables. | DB2 LUW |
RAP-5863 | [SQL Editor] Rochade database, query result error "Failed to change the catalog on the connection". | ALL |
RAP-5864 | SQL Installation Issue | ALL |
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.