About the Etlworks Explorer

About the Etlworks Explorer

Etlworks Explorer helps you see and understand your data. Whether it’s in a spreadsheet, an SQL database, a file, or a web service, you can connect and visualize any data anywhere.

What you can do in the Etlworks Explorer

• Discover and explore metadata
• Visualize data
• View data in the original Format
• Use SQL to transform data in any Format
• Upload files to any location
• Download files from any location

Start the Etlworks Explorer

Click the compass icon on the left navigation bar.

If you want to open the Etlworks Explorer in a separate tab, right-click on the compass icon.

Step 1. Select the Connection that you want to explore data and metadata.

Step 2. Assign a Format to the Connection if needed.

Step 3. Expand the metadata objects, such as database tables, files, columns, etc.

Step 4. Select a table, view, file or API endpoint and click View data to view the data in a grid Format.

Step 5. Select a Connection or metadata object and click Develop SQL to write and execute SQL.

Step 6. Select a file or API endpoint and click Raw data to see the data in its raw (original) Format.