C
O
N
TE
N
TS
Introducing Rapid SQL ......................................................................................................................5
About Rapid SQL ..........................................................................................................................5
Technical Requirements...................................................................................................................7
Browser Requirements ................................................................................................................7
Hardware Requirements ..............................................................................................................7
Operating System Requirements .................................................................................................7
Windows 7 Support Notes ............................................................................................................................................... 7
32-bit versus 64-bit Application Considerations and Restrictions ...................................... 7
DBMS Support and Connectivity Options ........................................................................................8
Dedicated Support Connectivity Options ....................................................................................8
IDERA Team Server 2016 Support .................................................................................................................................... 11
Generic JDBC/ODBC Connectivity ............................................................................................................. 11
IBM DB2 for Z/OS Stored Procedure Requirements ....................................................................11
Specifically-tested JDBC/ODBC Connectivity Products: Apache Hive/Hadoop ...........................12
DBMS Versions no Longer Supported ..........................................................................................12
Installing and Licensing Rapid SQL ..................................................................................................................... 13
Installing Rapid SQL .........................................................................................................................14
Using the Nov. 8 and Later Installation Kit ..................................................................................14
Using the Pre-Nov. 8 Installation Kit ............................................................................................15
Viewing the Installation Options .................................................................................................16
Licensing Your Product ................................................................................................................................................................................................................ 17
Licensing Overview ........................................................................................................................................... 18
Viewing Your License Type and Modules ....................................................................................18
Understanding Trial, Workstation, and Networked Licenses ................................................................... 18
Directing Queries Regarding Licenses ..................................................................................................................................................... 19
Licensing Your Application ......................................................................................... 20
Registering a Trial or Workstation License during Installation ...................................................................................... 20
Registering a Workstation License After Application Startup .......................................................................... 20
Registering By Phone ...................................................................................................................................................................................................................................................................... 21
Registering a Networked License ........................................................................................................................ 22
Selecting a License Category during Startup ...................................................................................23
Online/Offline Mode and Concurrent License Checkout ................................................................24
Rapid SQL Tutorial exercises ............................................................................................................25
Session 1: Getting Started ...............................................................................................................26
Starting the Rapid SQL Application ...................................................................................... 26
Registering Cross-Platform Datasources to Rapid SQL ...................................................................28
Session 2: Productivity Enhancers ...................................................................................................29
The Datasource Navigator Tree .................................................................................. 30
Creating an Object Using the Object Creation Wizard ........................................................................................................... 31
Working with an Existing Object Using the Object Editor .............................................................................. 32
Object Documentation and Reporting .............................................................................................33
Working With Code, Files and Data ........................................................................................................................................................................................... 34
Setting Environment Options ..........................................................................................................34