Welcome to IDERA Rapid SQL 18.6.x

Rapid SQL Home | Rapid SQL Documentation | IDERA Technical Support | www.idera.com

ReadMe Last Published: Feb. 5, 2024. Any updates to these notes will be available at www.idera.com/support/productdocuments.


Thank you for using IDERA Rapid SQL, the integrated development environment for many different database systems. Rapid SQL is your fast path to higher productivity whether you're programming in SQL, PL/SQL, Transact-SQL or HTML. Before you use Rapid SQL, please read the following information.

What's New in Rapid SQL 18.6

Provides full GIT support

Allows users to connect to PostgreSQL through Azure Active Directory

Allows Redshift authentication through IAM

Adds support for PostgreSQL profiling in DB Optimizer

Adds multi-factor authentication for MS SQL Server in DB Optimizer and DB Change Manager

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

IDERA Team Server 2016 Support

Generic JDBC/ODBC Connectivity

IBM DB2 for z/OS Stored Procedure Requirements

DBMS Versions No Longer Supported

Release Notes

Known Issues and Bug Fixes

Additional Resources

Licensing Your IDERA Product

IDERA Product Support

IDERA Technical Support

IDERA on the Web

What's New in Rapid SQL 18.6

Provides full GIT support

DB PowerStudio 18.6 provides full support of GIT by allowing the creation of projects inside of DBArtisan and Rapid SQL. This allows users to view a project once created inside of the GIT Repository.

Allows users to connect to PostgreSQL through Azure Active Directory

This release of DB PowerStudio allows users to connect to PostgreSQL through Azure Active Directory.

Allows Redshift authentication through IAM

DB PowerStudio 18.5 allows users to use Redshift authentication through AWS Identity and Access Management (IAM).

Adds support for PostgreSQL profiling in DB Optimizer

DB Optimizer 18.5 allows users to select PostgreSQL for a profiling session.

Adds multi-factor authentication for MS SQL Server in DB Optimizer and DB Change Manager

DB Optimizer and DB Change Manager users now can use multi-factor authentication for Microsoft SQL Server.

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.

Browser Requirements

Rapid SQL requires Microsoft Internet Explorer 11 or later.

Hardware Requirements

IDERA recommends the following minimum hardware requirements:

Operating System Requirements

Rapid SQL supports the following operating systems:

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.

For version control integration, if you install the 64-bit version of Rapid SQL, 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

Rapid SQL 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, driver, or client/driver combination that must be installed if using native IDERA clients, and the third-party, Type 4 JDBC drivers packaged with Rapid SQL.

 

Cloud/DBMS Platform

Supported Versions

Client (or driver/client combination) 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**
2012
2014

2016*

2017*

2019*

2022*

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, 5.7, and 8.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

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

BSD License

Snowflake

 

 

 

 

Sybase ASE

15.7 and 16.0

Sybase Open Client

jTDS Type 4 JDBC Driver for Microsoft SQL Server
Sybase jConnect JDBC Driver

LGPL source & license

Sybase IQ

15.4, 16.0, and 16.1

SQL Anywhere ODBC drivers for Sybase IQ 12.7
Sybase IQ 32-bit ODBC drivers

Sybase jConnect JDBC Driver for Sybase IQ

 

 

* Rapid SQL 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 Rapid SQL releases.

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 4.0 or ODBC version 3.0 driver. Minimal Rapid SQL 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, Rapid SQL 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 Rapid SQL against an IBM Db2 for z/OS data source, ensure that these components are installed on the server.

Cloud

Rapid SQL 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

Rapid SQL is no longer being tested against Sybase ASE versions before 15.7.

Release Notes

Known Issues and Bug Fixes

For the more recent list of known issues and bug fixes in this release, see http://docwiki.embarcadero.com/RapidSQL/186/en/Release_Notes_for_Rapid_SQL_18.6.

Additional Resources

Licensing Your IDERA Product

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:

IDERA Technical Support

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.

IDERA on the Web

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