Rapid SQL

Create High Performing SQL Code

  • Create high-performing SQL code on major DBMSs from one interface
  • Easily build complex SQL statements with visual query builder
  • Quickly construct, analyze and execute SQL code with code analyst
  • Simplify debugging SQL code, functions, and stored procedures
  • Collaborate effectively across development teams with version control

פרולוג'יק היא המפיצה הרישמית של מוצרי IDERA בישראל.
כמו כן פרולוג'יק מספקת חבילת מוצר מושלמת הכוללת אינטגרציה, ליווי והדרכה.

Develop High Performing Code Across DBMSs

Create high-performing SQL code on all major DBMSs (Oracle, SQL Server, DB2 and Sybase) from a single common interface. Reduce training requirements and streamline collaboration among teams across the organization. Manage multiple Oracle-specific schema object types.

Easily Build Complex Statements

Save time and start developing SQL code immediately with Visual Query Building tools. Rapid SQL gives you the ability to construct complex SQL statements with point-and-click ease using the Visual Query Builder.

Quickly Construct and Execute SQL Code

The SQL IDE is a development environment, ideal for creating and modifying SQL code geared to the needs of application developers. Real-time quick fixes flag and correct inefficient SQL au­tomatically. The IDE is also equipped with SQL code assist, real-time SQL syntax validation, and project level SQL file cataloging and search features.

Simplify Debugging

SQL Debugger simplifies the task of finding coding errors and lets you debug SQL Server, Oracle, Sybase or DB2 stored procedures as well as Oracle functions. The SQL Debugger features basic execution, line-by-line execution, breakpoint support, and other common debugging features.

Effectively Collaborate

Collaborate with your team with version control, reverse-engineering, and source code repository capabilities. Rapid SQL incorporates version control functions and build management facilities to help you manage and build projects. It provides seamless integration with most commercial version control packages and support for all operations including get, check-out, check-in, history, and differences.

SQL Scripting & Editing

Multi-Platform Interface

Develop highly performant SQL code on all major DBMSs (Oracle, SQL Server, DB2 and Sybase) from a single common interface and use the tools on all supported platforms from a single license. Streamline and automate common and repetitive tasks with an easy-to use GUI and powerful SQL editor wizards.

Visual Query Builder

Construct even the most complicated SQL statements with point-and-click ease.

Code Templates

Eliminate the need to memorize and type SQL syntax.

SQL Editor

Code folding, code collapse/roll-up, syntax coloring, hot key assignments, configurable auto replace of objects, bind variable support, selective statement execution.

Context-Sensitive DBMS Actions

DBMS actions, such as Extract and Drop, are available directly in the context menu of the appropriate tokens in the SQL editor.

Advanced Code Assist

See context-sensitive suggestions as you type (e.g., tables, columns, procedures, functions, and code templates) and is available offline.

Code Formatting

Code folding, syntax coloring, comment toggling, and other auto formatting features make it easy to read, navigate, and edit large SQL files.

Syntax & Semantic Validation

Validate SQL files and flags all DBMS-specific parser violations or references to objects not found in the target database.

Quick Fixes

Real-time parsing provides code quality suggestions for improving SQL performance as you type.

Performance Optimization

Code Analyst

Perform detailed response time analysis on the execution of stored procedures and functions.

SQL Debugger

Debug programmable objects such as stored procedures, functions, packages, and triggers. Debug Java, step seamlessly into SQL (i.e. stored procedure) and back into Java again – true system-wide, round-trip debugging.

SQL Profiler

Capture metrics of various PL/SQL programmable objects on Oracle 8.1.5 and higher.

Object & Unicode Support

Graphical Object Editors

Create, drop, or alter a wide variety of database objects, including tables, constraints, indexes, views, procedures, functions, triggers, and packages. Editors are common for all objects (across all platforms).

Wizard-Driven Object Creation

Wizards guide users through the creation of objects, prompting for the options that are applicable to objects found on the selected database platforms.

Grouped Object Command Execution

Execute database commands against a select grouping of objects (drop, compile, analyze, etc.).

Extended Alter Support

Generate complex scripts as a result of object manipulation (inserting a column in the middle of a table).

Unicode Support

Full Unicode character support throughout the application.

Enterprise Management

Troubleshooting Assistance

Use the automated IDERA Error Report feature to create a zip file containing important details about your installation, such as product information, hardware metrics, and necessary database information for troubleshooting.

Intuitive Interface

Streamline and automate common and repetitive tasks with an easy-to-use GUI and powerful wizards.

Centralized Data Source Repository

Simplify access and improve data source management. Designate Team Server as the data source catalog, and login to your data sources with Team Server credentials.


Minimum Hardware Requirements:

  • 1 GHz or faster processor
  • 1 GB of RAM
  • 1 GB of free disk space
  • 1024 x 768 display

Supported Operating Systems:

  • Windows 10, Windows 8, Windows 7 (32- and 64-bit)
  • Windows Server 2012 & 2012 R2, Windows Server 2008 SP1 & 2008 R2 (32- and 64-bit)

Supported Database Platforms

  • Firebird 2.0
  • Greenplum
  • IBM DB2 for z/OS 9 – 10.x and 11.x*
  • IBM DB2 LUW 9 – 10.x and 11.x*
  • InterBase 2007, 2009, XE, XE3, and XE7
  • Microsoft SQL Server 2008, 2012, 2014* and 2016*
  • MySQL 4.x
  • Oracle 9i, 10g, 11g and 12c*
  • PostgreSQL 9.3, 9.4
  • Sybase ASE 12.5-15.7, 16.0
  • Sybase IQ 12.7-15.4, 16.0

NOTE: SQL Profiler is only available for installations of Oracle version 8.1.5 or higher. Debugging in Rapid SQL is only available for DB2 LUW, Oracle, MS SQL Server and Sybase.
*For these databases, Rapid SQL supports a subset of this database version’s features/functions.