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

2.7.17 SQLite JDBC Driver

JDBC Drivers - SQLite JDBC Drivers

Aqua Data Studio (ADS) supports SQLite Database Schema. SQLite is a very popular free embedded SQL database engine.

You can get more information about SQLite Database and SQLite Driver here

Vendor: SQLite
Download Page: http://www.sqlite.org/download.html
Driver URL: http://www.zentus.com/sqlitejdbc

SQLite tutorial for Aqua Data Studio to Connect SQLite Database

The entire database is stored as a single cross-platform file on a host machine. SQLite locks the database file at the beginning of a transaction. SQLite uses SQL DBMS.


Create Server Group	Register a SQLite Server	Enter Properties	Locate SQLite Driver


SQLite Driver Properties	SQLite Server in ADS	SQLite Schema	Creating tables in SQLite

To connect to SQLite Database using Aqua Data Studio 7.0 :

Download SQLite JDBC driver from the url given above to your local machine. There is a Windows, MacOS X and Linux x86/amd64 SQLite JDBC driver version
Create a new server Group and name it as SQLite
Right Click on server group and click on the the Item which displays Register Server
Provide a new name for the SQLite Server
In the General tab, pick Generic - JDBC
Specify a URL. Enter "jdbc:sqlite:C:\SQLite\SampleDB.db" where SampleDB is the SQLite database you want to Connect to
Provide "org.sqlite.JDBC" in the Driver field
Locate the the downloaded driver by clicking on Browse

The SQLite Database server is registered successfully in Aqua Data Studio and You can now connect to the newly registered Server and perform Data Manipulations.