Cloud Hadoop Deployment
Connecting to DBs in Owl Web

Explorer 2

Quick tour of features and functionality

Getting Started

This page can be accessed by clicked the Explorer option, within the compass icon

This is being released as a tech preview and supports JDBC sources

Select Your Data Source

Navigate the tree explorer and browser your pre defined connections

Create a new OwlCheck by clicking +Create OwlCheck

The edit icon indicates this OwlCheck can be edited and resumed.

View Data is an interactive option to run queries and explore the data

The bar chart icon will take you to a profile page of the dataset created prior to Explorer 2

Select The Scope and Define a Query

The orange SQL Editor icon allows you to test a query

Pick Date Column if your dataset contains an appropriate time filter

Click Build Model -> to Save and Continue

Transform Tab (optional)

The Transform (gear icons) allow you to perform common transformation functions

Click Build Model -> to Save and Continue


Various options can be applied to customize analysis

Click Save to and Click Records to Continue


Click a column checkbox to apply record deltas

This should be applied to low cardinality columns

Click Save to and Click Pattern to Continue

Pattern (optional)

Toggle on Pattern to enable this layer

Click +Add to define a group and series of columns

A key indicates a sub grouping or bucketing

Click Save to and Click Outlier to Continue

Outlier (optional)

Click Save to and Click Dupe to Continue

Dupe (optional)

The Dupe Score slider determines the amount of fuzzy match

Click Save to and Click Source to Continue

Source (optional)

Navigate to the source dataset

Click Preview to interlace the columns

Manually map the columns by dragging left to right or deselect columns

Click Save to and Click Save/Run to Continue


Select an agent

*Note if you do not see your agent, please verify the agent has been assigned to your connection via:

Admin Console-->Remote Agent--> (Link icon on far right)-->Map connections to this agent and then reload the explorer page

Click Estimate Job

Click Run to start the job

Advanced deployment optimizations are available in Parallel JDBC and Deployment Mode