Documentation 19.0 (Book History)

Aqua Data Studio 19.0
Supported RDBMS Servers
Installation
- Minimum Requirements
- Installing Aqua Data Studio in Windows OS
- Installing Aqua Data Studio in Linux OS
- Installing Aqua Data Studio in Mac OS
- Unattended Installation
- Launcher & Memory Configuration
- Interface Language, Fonts & Character sets
- Charts and OpenGL or JOGL Configuration
- Application Logs & Support Information
- Configuration & Connection files
- Upgrading
- Patch Update
Registering a Database Server
- Amazon Redshift
- Apache Cassandra
- Apache Derby
- Apache Hive and Spark
- DB2 LUW
- DB2 iSeries
- DB2 zOS
- Generic JDBC
- Generic ODBC
- Google BigQuery
- Greenplum
- Informix
- MongoDB
- MS Excel
- MS SQL Database (Azure)
- MS SQL Server
- Microsoft Access Generic ODBC
- Microsoft Excel Generic ODBC
- MySQL
- Netezza
- Oracle
- Oracle OCI
- ParAccel Analytic Platform
- PostgreSQL
- SAP HANA
- SQLite
- Sybase ASE
- Sybase Anywhere
- Sybase IQ
- Teradata Aster Database
- Teradata Database
- Vertica
- VoltDB
- Connection Pooling
- Retrieving User Credential Outside the Application
JDBC Driver Configuration
- Amazon Redshift JDBC Drivers
- Apache Cassandra JDBC Drivers
- Apache Derby JDBC Drivers
- Apache Hive JDBC Drivers
- DB2 LUW 7.2 JDBC Drivers
- DB2 LUW 8.1 and DB2 UDB 8.2
- DB2 LUW 9.x/10.x/11.x and DB2 UDB 9.5
- DB2 iSeries JDBC Drivers
- DB2 z OS JDBC Drivers
- Greenplum JDBC Drivers
- Informix JDBC Drivers
- MySQL JDBC Drivers
- Netezza JDBC Drivers
- Oracle JDBC Drivers
- ParAccel Analytic Platform JDBC Drivers
- PostgreSQL JDBC Drivers
- SAP Hana JDBC Drivers
- SQLite JDBC Drivers
- SQL Server jTDS JDBC Drivers
- SQL Server Microsoft JDBC Drivers
- Sybase ASE JDBC Drivers
- Sybase Anywhere JDBC Drivers
- Sybase IQ JDBC Drivers
- Vertica JDBC Drivers
- Teradata Aster JDBC Drivers
- VoltDB JDBC Drivers
- Teradata JDBC Drivers
- Firebird JDBC Drivers
- Oracle 8i JDBC Drivers
- Oracle 9i JDBC Drivers
- Oracle 10g JDBC Drivers
- Oracle 11g JDBC Drivers
- Kerberos Configuration
- SSL Configuration
Workspace and Docking Framework
- Panels
- Menus and Toolbar
- Shortcuts Toolbar
- Schema Browser
- Files Browser
- Projects Browser
- Details View
- Saving Workspace
Query Analyzer - SQL Tool
- Invoking the Query Analyzer
- Using the Query Analyzer
- MongoJS Query Analyzer
- Query Analyzer and its Environment
- Server Side Comments
- Parameterized Scripts
- Displaying Results of Queries
- Saving Query Results
- Tips and Tricks
- SQL Automation
- Charting Grids and Pivot Grids
- Visual Explain Plan
Secure Shell - SSH Tool
- Secure Shell (SSH) Browser
SQL History
- SQL Log
Query Builder Tool
- Launching the Query Builder
- Building Queries
- Manage Connection
- Select Deck
- JOINs
- Where Deck
- Group By Deck
- Having Deck
- Order By Deck
- Union Deck
- Subqueries
- Derived Tables
- Query Options
- Multi-Database Query
- Using Favorites
- Invalid Objects, Filter Logic or Joins
- Sharing .QBW Files
- UI Persistence
Visual Analytics
- Launching Visual Analytics
- Workbooks
- Worksheets
- Chart Title
- Dashboards
- Data Pane
- Columns and Rows Decks
- Chart Properties Deck
- Chart Properties Axes
- Chart Properties Color
- Chart Properties Label
- Filters Deck
- Parameter Control Decks
- Reorganizing the Workspace
- Chart Pane
- Table Pane
- Showing/Hiding Workspace Elements
- Connecting to Data
- Data Sources and Worksheets
- Data Source Dimensions and Measures
- Managing Data Sources
- Data Extracts
- Data Types
- Bins
- Split Data
- Combined Fields
- Calculated Fields
- Calculated Field Functions
- Disaggregate Measures
- Table Calculations
  - Convert Table Calculations into Formula
- Parameters
- Refreshing Data
- Viewing Data
- Exporting View Data
- Visualization
- Saving Work
- Exporting Work
- Building Views
  - Basic View
  - Creating Filters
  - Sharing Filters
  - Sorting
  - Highlight Actions
    - Aggregation Functions in Status Bar
  - How to Make an Area Chart
  - How to Make a Bar Chart
  - How to Make a Bullet Chart
  - How to Make a Combination Chart
  - How to make Filled and Symbol Maps
    - How to Make a Filled Map Chart
    - How to Make a Symbol Map
    - Map Customization
  - How to Make a Funnel Chart
  - How to Make a Gauge Chart
  - How to Make a Histogram
  - How to Make a Heat Map Chart
  - How to Make a Horizon Chart
  - How to Make a Line Chart
  - How to Make a Mekko Chart
  - How to Make a Pie Chart
  - How to Make a Price Chart
  - How to Make a Radar Chart
  - How to Make a Reference Lines and Box Plot Chart
  - How to Make a Shape Chart
  - How to Make a Sunburst Chart
  - How to Make a Table
  - How to Make a Treemap Chart
  - Displaying Trend Lines
  - Editing Axes
  - Undo and Redo
  - Sample Data Source
- Exporting Visualizations
  - PDF Fonts
- Error Conditions and How to Resolve Them
- Using R with ADS
  - R Installation
  - Using Rserve
  - R Troubleshooting
- Data Densification
- Size Deck
- Attribute
- Date and DateTime Hierarchy
GUI Tools for Database Objects
- Creating Databases
- Creating Tables
- Creating Constraints
- Creating Indexes
- Creating Views & Triggers
- Creating Aliases & Synonyms
- Creating Storage Objects
- Multi Scripting Objects
Tools and Features
- How to Import Data
- How to Export Data
- Generate SQL Scripts
- Table Data Editor
- Server Script Generator
- Using Object Search
- Comparing two Database Schemas
- Using the Visual Explain White Board
- Using the Execution Monitor
- Using the Connection Monitor
- Generating ER Diagrams
- Using the Compress Tool
Procedure, Function & Package Editor
SQL Debugger
- Oracle Debugger
- DB2 Debugger
- MS SQL Debugger
- Sybase Debugger
ER Modeler
- Notation and Normalization
- Creating Tables
- Creating Indexes
- Creating Constraints
- Creating Relationships & Subcategories
- Adding Notes and Regions
- Saving and Exporting an ER Model
- Forward Engineering
- Reverse Engineering
- ER Modeler Demo
- Converting ER Models DB to DB
Version Control
- Using a Subversion Repository
- Using a CVS Repository
- Using a Perforce Repository
- Using a Git Repository
- Git Client
- File Search in Version Control
Database Administrator Tools
- ORACLE DBA Tools
- SQL SERVER DBA Tools
- SYBASE DBA Tools
- MySQL DBA Tools
- DB2 for LUW DBA Tools
- Amazon Redshift DBA Tools
- Greenplum DBA Tools
- Informix DBA Tools
- Netezza DBA Tools
- ParAccel DBA Tools
- PostgreSQL DBA Tools
- Sybase Anywhere DBA Tools
- Sybase IQ DBA Tools
- Teradata Aster DBA Tools
- Teradata DBA Tools
- Vertica DBA Tools
Compare Tools
- Schema Compare and Synchronization
- Tab Compare
- Directory Compare
- File Compare
- Copy History Compare
- Results Compare
Editors & Viewers
- Standard Options Across All Editors
- Editor Specific Options
- Code Insight & Code Completion Limits
- Regular Expressions in Editors
AquaScripts and AquaProjects
- AquaScript Templates
- AquaScript Editor and Debugger
- AquaScript Generator
- Aqua Open APIs
FluidShell
- Using FluidShell
- Shell Commands
  - alias
  - ask
  - autocommit
  - cat
  - cd
  - change
  - clear
  - cli
  - commit
  - compare
  - connect
  - cp
  - csv2excel
  - csv2html
  - csv2json
  - csv2xml
  - date
  - declare
  - describe
  - disconnect
  - echo
  - excel2csv
  - exec
  - export
  - fluidshell
  - go
  - grep
  - gunzip
  - gzip
  - help
  - history
  - list
  - ls
  - mkdir
  - more
  - mv
  - open
  - projectdeploy
  - pwd
  - reconnect
  - ren
  - rm
  - rmdir
  - rollback
  - run
  - scp
  - sendmail
  - session
  - sleep
  - source
  - sqlbuffer
  - sqldump
  - sqlexport
  - sqlhistory
  - sqlimport
  - ssh
  - syncdir
  - tail
  - tar
  - tee
  - touch
  - unalias
  - unset
  - unzip
  - zip
  - securestore
- Shell Variables
- Shell History
- Executing SQL
- Auto Completion
- Automating Data Export
Options
- General Options
- Editor Options
- Compare Options
- Results Options
- Query Analyzer Options
- Scripts and Results Options
- Query Builder Options
- Visual Explain Options
- Formatter Options
- Permissions and Registration Options
- Key Mapping Options and Key Assist Tool
- Command line
- ER Modeler Options
- Version Control Options
- E-mail Options
- Secure Storage Options
- SSH Terminal Options
- FluidShell Options
- Debugger Options
- File Association Options

Book History Documentation 19.0

Page Name	Revision	Last Edited	Edited by	Type
Aqua Data Studio 19.0	5	Oct 1, 2019 9:24 PM	amercado	Edit
Patch Update	2	Sep 24, 2019 6:29 PM	amercado	Edit
Patch Installation	1	Sep 24, 2019 6:25 PM	amercado	Edit
Patch Installation	0	Sep 24, 2019 6:23 PM	amercado	New
Installing Aqua Data Studio in Mac OS	2	Jul 30, 2019 7:16 PM	amercado	Edit
Installing Aqua Data Studio in Windows OS	6	Jul 30, 2019 7:14 PM	amercado	Edit
Installing Aqua Data Studio in Linux OS	3	Jul 30, 2019 7:14 PM	amercado	Edit
Installing Aqua Data Studio in Linux OS	2	Jul 30, 2019 7:13 PM	amercado	Edit
Installing Aqua Data Studio in Windows OS	5	Jul 30, 2019 7:13 PM	amercado	Edit
Installing Aqua Data Studio in Windows OS	4	Jul 30, 2019 12:08 AM	nhilam	Edit
Installing Aqua Data Studio in Mac OS	1	Jul 30, 2019 12:06 AM	nhilam	Edit
Installing Aqua Data Studio in Linux OS	1	Jul 30, 2019 12:05 AM	nhilam	Edit
Installing Aqua Data Studio in Windows OS	3	Oct 3, 2018 7:14 PM	amercado	Edit
Upgrading	2	Jul 31, 2018 8:26 PM	amercado	Edit
Installing Aqua Data Studio in Windows OS	2	Jul 23, 2018 8:53 PM	amercado	Edit
Installing Aqua Data Studio in Windows OS	1	Jul 23, 2018 8:48 PM	amercado	Edit
SSL Configuration	0	Jul 12, 2018 12:50 PM	amercado	New
Upgrading	1	Jun 22, 2018 7:32 PM	amercado	Edit
Upgrade	0	Jun 22, 2018 7:30 PM	amercado	New
SGA Manager	2	May 22, 2018 5:46 PM	amercado	Edit

Search Tips

Aqua Data Studio / nhilam

Book History Documentation 19.0

Search Tips

Aqua Data Studio / nhilam

Title

Book History Documentation 19.0