IDERA – Aqua Data Studio

IDERA – Aqua Data Studio

• Use a single database tool to manage many tasks for numerous data sources
• Easily develop, execute, and share SQL statements
• View, filter, and edit query results in Excel-like grid with copy-and-paste
• Create visualizations and dashboards to analyze data with drag-and-drop
• Compare schema, data, query results, files, and folders
• Reverse-engineer databases into entity relationship diagrams

Visually Build Queries

Drag and drop tables and views into a visual whiteboard, display existing and create new table joins, select columns, and aggregate properties such as where clauses and subqueries.

Easily Edit SQL Code

Connect to any database server and execute SQL queries. Automatically format SQL, color syntax, and complete text to save time in writing SQL statements. View query results in text, grid, pivot, and form views and export to common formats.

Visually Analyze Data

Create engaging data visualizations and dashboards to explore and share with others. Identify patterns and trends to find opportunities for further analysis. Apply filters, data labels, table calculations, and statistical analysis with R to create charts to improve business decisions, limit risk and solve difficult problems.

Edit Data in Excel Style Grid

Edit the result-set of an executed query on a data grid using a convenient graphical interface. Easily alter data, and add and delete rows using an editable, Excel-like grid.

Model Entity Relationship Diagrams

Design physical database models. Forward engineer to model tables, views, indexes, constraints, and relationships and generate SQL scripts. Reverse engineer existing databases to visualize a database model. Quickly convert models from one database platform to another.

Analyze Queries — Connect to any database and execute SQL queries effortlessly. Automatically format SQL, color syntax, and complete SQL. Perform advanced analysis by viewing query results in text, grid, pivot, and form views with quick filtering and one-click export to Excel.

Access SQL History — Quickly retrieve and reuse any previously executed queries with the automatic recording of all queries. Filter and archive queries to ensure efficient scaling.

Visually Build Queries — Construct sophisticated database queries without ever writing a line of SQL. Select tables and columns from the graphical user interface. Leverage the rich set of visual options including joins, group bys, sort order, and equality comparisons.

Build Charts — Build great-looking 2D and 3D charts by choosing from a comprehensive range of chart types and customize to meet specific needs. Update all charts in real time based on the query result set. Create charts based on pivoted data.