• Andi - The Authority for Database Productivity

• Andi 6.3.5 - Update to OpenJDK 17

• Andi 6.2.1

• Andi 6.2

• Andi 6.1.0

• Andi 6.0.0

• Andi 5.5.6

• Andi 5.5.5

• Andi 5.5.3 is here!

• Andi 5.5.1 is Now Available

Andi - Getting Started

• Creating a Connection

• Andi UI Navigation Overview

• Andi Application Preferences

• Andi Help

Creating, Modifying, Running, and Saving Queries

• Overview of Running A Query

• Dynamically Creating, Visualizing, and Modifying SQL Statements

• Organizing Queries Using Custom Query Groups

• Statement History

Analyzing, Manipulating, Updating, and Exporting Query Results

• Overview of Working With Query Results

• Moving, Sizing, Sorting, and Hiding Columns

• Filtering Query Results

• Data Formatting Options

Working with Complex Data Types (XML, BLOBs, and CLOBs)

• Formatter Expression Creator

• Selecting and Viewing LOB Data Types (BLOB and CLOB)

• Working With XML in the XML Viewer

Navigating Schemas and Data Relationships

• Navigating Schemas with the Schema Browser

• Using the Dynamic Database Explorer to Explore Data Relationships (Referential Integrity Required)

• Administration and Setup for the Database Explorer

• Using the Database Explorer to Explore Data Relationships (Administration and Setup Required)

Interactive Scripting Editor

• ★ Scripting Help and Examples

• Getting Started

• Introduction to the Interactive Scripting Editor

• Parallel Processing

Data Analysis

• Charts

• Box and Whisker

• Scatter Chart

• Area Chart

• XY Line Chart

• Data Selection

• Data Preparation

• Pie Chart

• Bar Chart

• Line Chart

• Chart Viewer

• Custom Chart Themes

• Pivot Chart

• Pivot Model

Data Cleansing and Verification

• Andi for Data Engineers

• Quickly verify, cleanse and analyze very large files

• CSVTable

• Column Value Processors

• Join CSV Files

• Verification Modes

• Putting it all Together

• Resolving Verification Errors

• Interrupting Long Running or Infinite Loop Scripts

• Create your own Extension

• Configure Eclipse for Andi Extension Development

• Create Delimited Line using Transformed Data

Artemis Queue

• Advanced Search

• Getting Started

• Browse

• Search

• Put

• Remove All Messages

• Requeue

• Pause/Resume

• Queue Name Filter

• Message Browser

• Integrated Scripting

WebSphere MQ

• ★ Troubleshooting

• ★ Create Queue Manager Connection

• Supported Queue Managers

• Generate List of Queues

• Browse one or More Queue Messages

• Search Queue Messages

• Put Messages to a Queue

• Requeue Queue Messages from Backout Queue

• Deleting Queue Messages

• Working With Message Queues

Technical Reference

• ★ Mac SSL error prevents activating Andi License.

• Floating License Server: Client Properties

• Technical Reference Document: MYSql Update error "Parameter metadata not available for the given statement"

• Auto Configure SSL

• Technical Reference Document: MySQL Connection Using TLS

• MySQL: Use SSL for Connection

• MySQL: Configuring SSL

• Technical Reference Document: DB2 connection using TLS

• Andi Sample Database

• Floating License Server

• Technical Reference Document: Executing an Atomic Block

• Technical Reference Document: Driver Support

• Technical Reference Document: Andi Custom Tags

Performance Optimization

• Performance Tuning for Large Result Sets