Rapid Database Extractor on cloud

1-click AWS Deployment 1-click Azure Deployment


Database developers with heterogeneous database environments typically have to use multiple database-specific tools to complete tasks that Rapid Database Extractor can execute in a single integrated development environment. By contrast, IDERA’s free tool streamlines and automates common and repetitive database exploration tasks, reducing errors, saving time and increasing productivity.

  • Manage SQL Server and Oracle data sources
  • Manipulate database objects
  • Interactively edit SQL code
  • Selectively execute SQL queries to retrieve data
  • Export data to common file formats
  • Connect to cloud and run in cloud (provisional)

Rapid Database Extractor on cloud for AWS



Major Features of  Rapid Database Extractor

1.Manage SQL Server and Oracle Data Sources

Connect to SQL Server and Oracle data sources from a single user interface. Register data sources manually or semi-automatically. Log in to multiple data sources. Drill down into the data sources to view registered databases on each server.

2.Manipulate Database Objects

Drill down into each database to display its objects and to inspect the structure of individual objects for quick visibility into databases. Navigate and search objects, create new objects, edit existing objects, execute context-sensitive commands, and browse outline views without SQL script. Manage database objects, including tables, constraints, indexes, views, procedures, functions, triggers, and packages. Efficiently navigate databases with many objects.

3.Interactively Edit SQL Code

Edit SQL code in the interactive development environment. Select from a list of context-sensitive suggestions for object and function names, and automatically insert SQL statements from templates to avoid looking up, memorizing, and typing. Prevent and fix common mistakes with SQL code quality markers. Validate SQL syntax and semantics in real-time to avoid parser violations and unresolved references. Automatically format displayed SQL code for easy navigation. Apply and share custom SQL formatting profiles for consistent SQL code layout. Improve queries by viewing the SQL query execution plan.

4.Selectively Execute SQL Queries to Retrieve Data

Associate SQL files with data sources, specify SQL session options, and selectively execute SQL statements in the integrated environment to quickly manipulate database content. Display the resulting data in a convenient grid. View logs of all executed SQL queries to analyze and document past actions.

5.Export Data to Common File Formats

Save extracted data to standard file formats (Excel, HTML, XML, delimited TXT, and SQL INSERT statements) for subsequent analysis and collaboration.

6.Connect to Cloud and Run in Cloud (Provisional)

Connect to database instances hosted in the cloud, such as SQL Server on Azure Virtual Machine (VM), SQL Server on Amazon Elastic Compute Cloud (EC2), and SQL Server on Amazon Relational Database Service (RDS).

Run on virtual machines hosted in the cloud, such as Windows on Azure Virtual Machine (VM) and Windows on Amazon Elastic Compute Cloud (EC2).


Installation Instructions For Windows

A) Click the Windows “Start” button and select “All Programs” and then point to Rapid Database Extractor

B) RDP Connection: To connect to the operating system,

1) Connect to virtual machine using following RDP credentials :

  • Hostname: PublicDNS  / IP of machine
  • Port : 3389

Username: To connect to the operating system, use RDP and the username is Administrator.
Password : Please Click here  to know how to  get password .

C) Other Information:

1.Default installation path: will be on your root folder “C:\Program Files\Idera\Idera Rapid Database Extractor\”
2.Default ports:

  • Windows Machines:  RDP Port – 3389
  • Http: 80
  • Https: 443

Configure custom inbound and outbound rules using this link

Installation Step by Step Screenshots



















Rapid Database Extractor on cloud