Contents

Getting Started. 1

What is Data Explorer?. 1

Who is intended audience of the Data Explorer?. 1

Data Explorer Editions. 1

Downloading. 1

Downloading Desktop Application. 1

Downloading Server. 1

Installing. 1

Installing Desktop Application. 1

Installing Server. 1

Installing Plugins. 1

Installing License. 1

Installing JDBC drivers. 1

Installing Third Party Database Command Line Tools. 1

Starting Data Explorer. 1

Starting Desktop Application. 1

Starting Server. 1

Staring Web version of the Data Explorer. 1

Configuring. 1

Configuring Network and Services. 1

Configuring Data Explorer to work in the Client-Server mode. 1

Configuring Third-Party Database Command Line Tools. 1

Changing Look And Feel 1

Adding New Look and Feel 1

Configuring Appearance. 1

Changing settings for high DPI monitors. 1

Changing Keyboard Shortcuts. 1

Changing JVM Parameters. 1

Configuring Users, Roles and Rights. 1

Changing user’s profile. 1

Data Explorer User Interface. 1

Main Window Layout. 1

Objects Browser. 1

Navigation. 1

Finding and Filtering Nodes. 1

Node Editors. 1

Activities. 1

Working with Tabs. 1

Working with Grids. 1

Background Tasks. 1

Checking Installed Version and License. 1

Checking for Updates. 1

Getting Online Help. 1

Creating Connections. 1

Creating Connection Templates. 1

Creating Database Connections. 1

Creating File Connections. 1

Organizing connections in folders. 1

Developing and Executing ETL Scenarios. 1

Writing ETL Scenarios. 1

Creating New ETL or Data Integration Scenario. 1

Organizing ETL scenarios in folders. 1

Working with ETL Editor. 1

Using auto completion. 1

Working with syntax Errors. 1

Formatting Code. 1

Using Interactive ETL Designer. 1

Using Drag and Drop with ETL Designer. 1

Configuring ETL Editor and Designer. 1

Running ETL Scenario. 1

Working with Run-Time Errors. 1

Scheduling ETL Scenarios. 1

Working with ETL code Snippets. 1

Exporting ETL Configuration to be used by standalone ETL Framework. 1

Create configuration file for ETL Scenario. 1

Create configuration file for standalone ETL Framework. 1

Enabling audit for ETL. 1

Migrating Data and Schema Objects. 1

Creating and Executing Data Migration Scenarios. 1

Configuring Data Migration Wizard. 1

Working with Databases. 1

Browsing Database Objects. 1

Finding and Filtering Database Objects. 1

By using Find Database Objects activity. 1

By finding objects using Objects Browser built-in search. 1

Viewing Entity Relationships. 1

Using Referenced From.. 1

Using All References. 1

Viewing Tables, Views, Synonyms, etc. 1

Editing Tables, Views, Synonyms, etc. 1

Creating and profiling SQL queries and scripts. 1

Working with SQL Editor. 1

Using auto completion. 1

Formatting SQL Code. 1

Creating Queries and SQL scripts using SQL Editor. 1

Using Bind Variables in SQL. 1

Working with Syntax Errors. 1

Executing SQL Queries and Scripts. 1

Profiling SQL Queries. 1

Creating Queries using Query Designer. 1

Configuring SQL Editor and Designer. 1

Executing Stored Procedures and Functions. 1

Scripting Database Objects. 1

Handling Transactions. 1

Describing Database Objects. 1

Working with SQL code Snippets. 1

Working with SQL History. 1

Scheduling SQL. 1

Enabling audit for SQL. 1

Working with Files. 1

Browsing and Viewing Files using File Connections. 1

Browsing and Viewing Files using File Manager. 1

Adding new root folder to the Objects Browser. 1

Viewing, editing, creating, coping, moving, deleting and renaming files and folders. 1

Changing File Manager configuration options. 1

Working with Datasets. 1

Refreshing, Filtering and Sorting Dataset. 1

Searching in Dataset. 1

Exporting Dataset. 1

Creating Charts. 1

Transforming Dataset. 1

Applying Statistical Numerical and Date Functions. 1

Describing Dataset. 1

Changing Maximum Number of Rows to Display in the Grid. 1

Managing Scheduled Tasks. 1

Changing scheduler configuration properties. 1

Viewing Audit Log. 1

Viewing Application Log. 1