Rapid SQL Home | Rapid SQL Documentation
| IDERA Technical
Support | www.idera.com
ReadMe
Last Published: Dec 1, 2022. 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 IBM
DB2, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, Snowflake, Sybase and
Teradata 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.3
Updates Azure cloud
monitoring capability in DBArtisan
Supports the latest
version of Log4j
Improves multiple
areas within DBArtisan and Rapid SQL
Improves
multiple areas within DB Change Manager
Updates profiling
session capability in DB Optimizer
Technical 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
Additional Resources
What's New in Rapid SQL 18.3
Updates Azure cloud monitoring capability in
DBArtisan
The monitoring capability for Microsoft Azure
cloud is updated in DBArtisan. This functionality includes multi-tabbed process
monitoring and management as well as allows you to catch performance issues
before they arise.
Supports the latest version of Log4j
DB PowerStudio 18.3 includes support for the
latest version of Apache Log4j, which is essential for proper logging and
diagnostics of applications.
Improves multiple areas
within DBArtisan and Rapid SQL
DB PowerStudio 18.3 includes updates to the
following areas within DBArtisan and Rapid SQL:
Improves multiple
areas within DB Change Manager
Updates profiling session capability in DB
Optimizer
DB Optimizer 18.3 updates profiling session
capability, which alerts users to potentially problematic SQL ahead of time.
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.
Rapid
SQL requires Microsoft Internet Explorer 11 or later.
IDERA recommends the following minimum hardware requirements:
Rapid SQL supports the following operating systems:
Windows
7 Support Notes - Windows 7 provides 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.
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).
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, 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 IDERA 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 IDERA Drivers |
Packaged JDBC Driver |
Source & License |
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 SQL Server |
2008 2014 SP2* 2016* 2017* 2019* |
Microsoft SQL Server
Client Library |
jTDS Type 4 JDBC Driver for Microsoft SQL Server |
|
MySQL |
4.x, 5.x, and 8.x |
MySQL Connector/ODBC
Driver 5.2.x Driver - MySQL
Connector/ODBC driver 3.51.x Driver |
MySQL Connector/J JDBC
Driver |
|
Oracle |
10g, 11g, 11g R2, 12c, 12c R2, 18c,
and 19c |
Oracle SQL*Net Client |
Oracle JDBC Thin
Driver |
|
PostgreSQL |
9.3 - 9.10,
10.7, 11.2, and 12.x |
PostgreSQL ODBC Driver
(latest version recommended) |
PostgreSQL JDBC Driver |
|
Snowflake |
|
|
||
Sybase ASE |
15.7 and 16.0 |
Sybase Open Client |
jTDS Type 4 JDBC Driver for Microsoft SQL Server |
|
Sybase IQ |
15.4, 16.0, and 16.1 |
SQL Anywhere ODBC
drivers for Sybase IQ 12.7 |
Sybase jConnect JDBC Driver for Sybase IQ |
|
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
For
the more recent list of known issues and bug fixes in this release, see http://docwiki.embarcadero.com/RapidSQL/183/en/Release_Notes_for_Rapid_SQL_18.3.
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.