Documentation 7.0
 Aqua Data Studio
7.0
1. Installation
1.1 Minimum
Requirements
1.2 Installing Aqua Data Studio in Windows
OS
1.3 Installing Aqua Data Studio in Linux
OS
1.4 Installing Aqua Data Studio in Mac OS
1.5
First steps towards Configuring
1.6 Character set and
Internationalization
2. Server
Registration
2.1 Supported RDBMS Servers in ADS 7.0
2.2 How to Register a Server in ADS 7.0
2.3 How
to Edit Server Properties
2.4
How to Copy Server Configurations
2.5
Troubleshoot Registrations
2.6 Tips and
Tricks
2.6.1 How to Register a Server Clone
2.6.2 Tab Coloring to Identify Servers
2.6.3 Using Filter Options in
Registration
2.6.4
Using Advanced Properties
2.6.5 Permissions in Server Registration
2.6.6 Drag
and Drop Features
2.6.7 Navigating with Short cut Keys
2.6.8 SQL Express
2005
2.6.9 MSDE 2000
2.6.10 PostgreSQL
SSL
2.7. JDBC Drivers and Server Registration
2.7.1 Oracle
8i JDBC Drivers
2.7.2 Oracle
9i JDBC Drivers
2.7.3
Oracle 10g JDBC Drivers
2.7.4
Oracle 11g JDBC Drivers
2.7.5 DB2
iSeries JDBC Drivers
2.7.6 DB2 7.2
JDBC Drivers
2.7.7
DB2 UDB 8.1 and DB2 UDB 8.2
2.7.8
DB2 UDB 9.0 and DB2 UDB 9.5
2.7.9 SQL
Server JDBC Drivers
2.7.10
Sybase ASE JDBC Drivers
2.7.11 Sybase Anywhere JDBC Drivers
2.7.12
Sybase IQ JDBC Drivers
2.7.13
Informix JDBC Drivers
2.7.14
PostgreSQL JDBC Drivers
2.7.15 MySQL
JDBC Drivers
2.7.16
Apache Derby JDBC Drivers
2.7.17 SQLite
JDBC Driver
2.7.18
Firebird JDBC Driver
3. Connecting to a Server (CTRL + INSERT)
4. Disconnecting a Server (CTRL + DELETE)
5. Query Analyzer - SQL Tool in ADS 7.0
5.1 Invoking the Query Analyzer (CTRL+Q)
5.2 Using
the Query Analyzer
5.3 Query Analyzer and its Environment
5.4 Using
Advanced Properties
5.5
Parameterized Scripts
5.6
Displaying Results of Queries
5.7 Saving Query
Results
5.8 Tips and
Tricks
6. SQL
History (CTRL+ ALT+H)
7. Automate your SQL scripts using ADS
7.0
7.1.1 Adding Insert, Update, Delete and
Select
7.1.2 Introduce Columns and Value Stubs
7.1.3 Comments and Morph to Delimited
Text
7.1.4
Formatting Statements
7.2 Auto
Completion
7.3 Aqua
Commands
8. Query
Builder Tool in ADS 7.0
8.1 Using the
Query Builder
9. Charting
Tool in ADS 7.0
9.1 Invoking Charting Tools in ADS 7.0
9.2 Working with
Grids
9.3 Working
with Pivot Grids
9.4 Advanced Features of Charting Tools
9.5 Sample
Charting Demo
10. SQL Query Tuning - Visual Explain Tools
10.1
Invoking Execution Plans
10.2 Using
Explain Diagrams
10.3 Sample
Query Tuning Demo
11. GUI Tools for Creating Database
Objects
11.1.1 Creating
Tables
11.1.2
Creating Constraints
11.1.3 Creating
Indexes
11.1.4
Creating Views and Triggers
11.1.5 Creating Aliases and Synonyms
11.1.6
Creating Storage Objects
11.2 Multi
Scripting Objects
12. Tools and Features available in ADS
7.0
12.1 How to Import Data using ADS 7.0
12.2 How to Export Data using ADS 7.0
12.3 Generate SQL Scripts using ADS 7.0
12.4 Table Data
Editor
12.5 Server
Script Generator
12.6
Using Object Search in ADS 7.0
12.7
Comparing two Database Schemas
12.8 Using
Explain White Board
12.9 Using
Execution Monitor
12.10
Generating ER Diagrams
13. Procedure
Editor
13.1 Sample
Stored Procedure
14. Function
Editor
14.1
Sample User Defined Function
15. Package
Editor
16. SQL Debugger
16.1
Features of ADS 7.0 Debuggers
16.1.1 Oracle
Debugger
16.1.2 DB2
Debugger
16.1.3 MS SQL
Debugger
16.1.4 Sybase
Debugger
17. ER Modeler
in ADS 7.0
17.1
Notation and Normalization
17.2 Working
with ER Modeler
17.2.1 Creating
Tables
17.2.2 Creating
Indexes
17.2.3
Creating Constraints
17.2.4
Creating Relationships
17.2.5
Adding Notes and Regions
17.2.6 Saving
an ER Model
17.3 Forward
Engineering
17.4 Reverse
Engineering
17.5 ER Modeler
Demo
18.
Version Control in ADS 7.0
18.1
Using Subversion Repository
18.2 Using CVS
Repository
18.3 Tips and
Tricks
19. DBA Corner
19.1 ORACLE DBA
Tools
19.1.1 Server
Statistics
19.1.2 Rollback
Manager
19.1.3 Log
Manager
19.1.4 Session
Manager
19.1.5 Instance
Manager
19.1.6 Storage
Manager
19.1.7 Security
Manager
19.1.8 SGA
Manager
19.2 SQL SERVER
DBA Tools
19.2.1 Instance
Manager
19.2.2 Session
Manager
19.2.3 Security
Manager
19.2.4 Storage
Manager
19.2.5 SQL Agent
Manager
19.3 SYBASE DBA
Tools
19.3.1 Instance
Manager
19.3.2 Session
Manager
19.3.3 Security
Manager
19.3.4 Storage
Manager
19.4 MySQL DBA
Tools
19.4.1 Instance
Manager
19.4.2 Session
Manager
19.4.3 Storage
Manager
19.4.4 Security
Manager
19.5 DB2 for
LUW DBA Tools
19.5.1 Instance
Manager
19.5.2 Session
Manager
19.5.3 Storage
Manager
19.5.4 Security
Manager
20. Compare
Tools in ADS 7.0
20.1 File
Compare
20.2 Results
Compare
20.3 Directory
Compare
20.4 Tab Compare
20.5 Schema
Compare
20.6 Copy
History Compare
21.
Editors available in ADS 7.0
21.1.1 SQL
Editor
21.1.2 HTML
Editor
21.1.3 XML
Editor
21.1.4 Text
Editor
21.1.5 Regular
Expressions
21.2 Image
Viewer
22.
Application Workspace and Options
22.1 Menus and
Toolbar
22.2 Shorcuts
22.3
Schema and Script Browser
22.4 Details
View
23. Aqua
Data Studio 7.0 OPTIONS
23.1 General
Options
23.2 Editor
Options
23.3
Compare and Results Options
23.4 Query
Analyzer Options
23.5
Scripts and Results Options
23.6 Visual
Explain Options
23.7 Formatter
Options
23.8 Permissions and Registration Options
23.9 Key Mapping Options and Key Assist
Tool
23.10 Settings: Find the application
settings
24. Aqua Data Studio Technical Support
24.1 Error
Logging
|
9.1 Invoking Charting
Tools in ADS 7.0
Getting Started with GRIDS
 |
 |
 |
 |
 |
 |
Query
Analyzer
|
Execute Query
|
Open
GRID
|
Chart Display Area |
Select Category
|
Select Series
|
 |
 |
 |
 |
 |
 |
Options
|
Stacked Area Chart
|
Chart
Types
|
Column Chart
|
Chart Views
|
Series View
|
How to use Grids
- Connect to the Database Server and Open a Query Analyzer
- Type in the Query for which you want to view the Charts, in the
Query Analyzer and Execute the Query
- Click on Grid Tab
- To enable the Chart View Click on Show Charts Icon near
records(s) [Fetch MetaData: /ms] [Fetch Data: /ms]
- In the Chart display Area, select a Category and Series
- Different Types of Charts are available and you can change
types using the drop down
- The Legend displays the type of the Chart
- Different types of views are available in ADS 7.0 - Isometric,
Category and Series
- CTRL+R saves the results
- The Chart layout can be saved and shared in XML. Load layout
from XML opens saved XML charts
- Right click on the Chart and you can save it as an Image
- You can generate script to window, save and share the
scripts
Getting Started with PIVOT GRIDS
 |
 |
 |
 |
 |
 |
Open
Pivot Grid
|
Drag into Row Field
|
Drag into Column Field
|
Pivot Chart - Column |
Editing Column Fields
|
Pivot Chart - Area
|
 |
 |
 |
 |
 |
 |
Scripting
|
Excel Viewer
|
ADS Pivot Chart in Excel
|
Save a Pivot Chart
|
ADS Pivot Chart in Excel |
Pivot Grid Options
|
How to use Pivot Grids
- Connect to the Database Server and Open a Query Analyzer
- Type in the Query for which you want to view the Charts, in the
Query Analyzer and Execute the Query
- Click on Pivot Grid Tab
- To enable the Chart View Click on Show Charts Icon near
records(s) [Fetch MetaData: /ms] [Fetch Data: /ms]
- In the Chart display Area, select a Category and Series
- From the Field List, you need to drag items to the Pivot
Grid
- You can drop the Fields into Filter Fields, Row Fields or
Column Fields
- Each of these have got options to Filter items
- In the figure shown, I have added CardType into the column
Field and in the drop down, I am selecting only 2 items so that the
columns are returned on the basis of this filter (See figure
Editing Column Fields)
- The Pivot Grid has options to Display Fields, Total and
Sub-Total
- Aggregate Functions like Sum, Count, Min, Max, Average,
Standard Deviation are available
- CTRL+R saves the results
- The Chart layout can be saved and shared in XML. Load layout
from XML opens saved XML charts
- Right click on the Chart and you can save it as an Image
- You can generate script to window, save and share the
scripts
|
