Documentation 22.0 (Book History)

Aqua Data Studio 22.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
- Remember Password
- Ultimate License
Registering a Database Server
- Amazon Redshift
- AWS Amazon Athena
- Apache Cassandra
- Apache Derby
- Apache Hive and Spark
- DB2 LUW
- DB2 iSeries
- DB2 zOS
- Generic JDBC
- Generic ODBC
- Google BigQuery
- Greenplum
- Informix
- InterBase
- MariaDB and Amazon RDS
- MongoDB
- MongoDB Atlas
- MS Database Warehouse (Azure Synapse)
- MS Excel
- MS SQL Database (Azure)
- MS SQL Server and Amazon RDS
- Microsoft Access Generic ODBC
- Microsoft Excel Generic ODBC
- MySQL (includes Aurora, Amazon RDS, Google)
- Netezza
- Oracle and Amazon RDS
- Oracle OCI
- ParAccel Analytic Platform
- PostgreSQL (includes Aurora, Amazon RDS, Google)
- SAP HANA
- SingleStore (MemSQL)
- SQLite
- Snowflake
- 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 Athena JDBC
- 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
- InterBase JDBC Drivers
- MariaDB 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
- Snowflake 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
- Configuring an SSH Tunnel
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
Scheduled Tasks
- Windows Scheduled Tasks
  - Windows Manage Scheduled Tasks
- macOS Scheduled Tasks
  - macOS Manage Scheduled Tasks
- Task Scheduler for Projects
- Common Scheduled Tasks Errors
Data Masking
Random Table and Data Generator
Unit Testing Framework
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
- MariaDB 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
- SingleStore (MemSQL) DBA Tools
- Snowflake 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
- Data 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
  - 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 Builder Options
- Scheduler
- Query Analyzer Options
- Scripts and Results 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
- SSO Options

Book History Documentation 22.0

Page Name	Revision	Last Edited	Edited by	Type
Amazon Redshift	1	May 8, 2024 3:44 PM	nadine.hinojosa	Edit
Registering a Database Server	2	May 8, 2024 3:42 PM	nadine.hinojosa	Edit
Ultimate License	1	May 8, 2024 3:40 PM	nadine.hinojosa	Edit
Remember Password	6	May 8, 2024 3:39 PM	nadine.hinojosa	Edit
Configuration & Connection files	1	May 8, 2024 3:38 PM	nadine.hinojosa	Edit
Application Logs & Support Information	1	May 8, 2024 3:37 PM	nadine.hinojosa	Edit
Charts and OpenGL or JOGL Configuration	1	May 8, 2024 3:35 PM	nadine.hinojosa	Edit
Interface Language, Fonts & Character sets	1	May 8, 2024 3:33 PM	nadine.hinojosa	Edit
Launcher & Memory Configuration	1	May 8, 2024 3:31 PM	nadine.hinojosa	Edit
Unattended Installation	1	May 8, 2024 3:28 PM	nadine.hinojosa	Edit
Installing Aqua Data Studio in Mac OS	1	May 8, 2024 3:21 PM	nadine.hinojosa	Edit
Installing Aqua Data Studio in Windows OS	5	May 8, 2024 3:17 PM	nadine.hinojosa	Edit
Installing Aqua Data Studio in Windows OS	4	May 8, 2024 3:16 PM	nadine.hinojosa	Edit
Installing Aqua Data Studio in Windows OS	3	May 8, 2024 3:14 PM	nadine.hinojosa	Edit
Installing Aqua Data Studio in Linux OS	5	May 8, 2024 3:13 PM	nadine.hinojosa	Edit
Installing Aqua Data Studio in Linux OS	4	May 8, 2024 3:10 PM	nadine.hinojosa	Edit
Installing Aqua Data Studio in Linux OS	3	May 8, 2024 3:10 PM	nadine.hinojosa	Edit
Installing Aqua Data Studio in Linux OS	2	May 8, 2024 3:09 PM	nadine.hinojosa	Edit
Installing Aqua Data Studio in Linux OS	1	May 8, 2024 3:08 PM	nadine.hinojosa	Edit
Installing Aqua Data Studio in Windows OS	2	May 8, 2024 2:48 PM	nadine.hinojosa	Edit

Search Tips

Aqua Data Studio / nhilam

Book History Documentation 22.0

Search Tips

Aqua Data Studio / nhilam

Title

Book History Documentation 22.0