Etlworks has a UI surface of dozens of screens, a knowledge base with 500+ articles, and a template library of ~4,000 prebuilt integrations. The fastest way to find what you need depends on what you're looking for — this article covers the main paths.
Start with Simba
Simba is the AI agent built into Etlworks. It is the recommended first stop when you don't know exactly where to look or what to do. Simba is embedded in the app and can:
- Answer questions about Etlworks — concepts, features, troubleshooting — sourced from the documentation and platform metadata.
- Build flows from natural-language descriptions in Composer (e.g., "load Salesforce contacts into Snowflake daily").
- Create connections from a description — including HTTP API connections built from public vendor docs.
- Browse data and run SQL through Explorer.
- Write and review JavaScript or Python.
- Manage schedules and triage failing flows.
Simba is faster than the search bar or the gallery when you can describe what you want in words. Reach for it before you reach for anything else.
Find things in the documentation
- Search bar — top of every page on the documentation portal. Suggests articles as you type; check the Related Articles section at the bottom of each page for cross-links.
- Quick tutorials — guided walkthroughs for the most common use cases: Quick tutorials.
- Integration Use Cases — database, file, API, EDI, and per-warehouse guidance (Snowflake, BigQuery, Redshift, Synapse, Vertica, Greenplum): Integration Use Cases.
- Building blocks — Connections, Listeners, Formats, Flows reference: Building blocks.
- Transformations and Mapping — how source-to-destination mapping and the transformation pipeline work: Transformations and Mapping.
- Developer Docs — REST API, AI Agent API, CLI, Scripting (JavaScript, Python): Developer Docs.
- Operations and observability — flow execution and debugging, audit history, alerts, performance, error and exception handling: Operations, Monitoring, and Observability.
- Working with Parameters and Variables — tokens, dynamic URLs, parameterized payloads: Working with Parameters and Variables.
- Working with Nested and Hierarchical Data — flatten / normalize / build / transform JSON, XML, EDI: Working with Nested and Hierarchical Data.
- Working with on-premise data — Integration Agent and hybrid deployment: Working with on-premise data.
- Customer stories — real-world implementations: etlworks.com/case-studies/.
Find things in the Etlworks app
Global search
The fastest way to find any flow, connection, listener, format, or schedule across the whole instance. Click the search field in the top menu bar (or press the keyboard shortcut). See Global Search for the full match grammar.
The Home screen (default landing page)
After sign-in, the Home screen is a customizable dashboard built around three groups of widgets — Create (start a new flow), Insights (operational metrics), and Audit — plus a list of your most recently touched flows for quick re-entry. Use Home as your daily landing point. Add or rearrange widgets to surface what you care about.
Templates
If you're starting a new integration from scratch, the Templates screen is the fastest path: ~4,000 prebuilt integrations and automations, importable in one click, complete with the flows, connections, formats, and schedules they need. System templates are maintained by Etlworks; custom templates are private to your instance. Search by keyword or browse by category.
Find properties and settings
Many screens (System Settings, Flow / Connection / Format configuration) have a per-screen search field that filters fields by name. Useful when a configuration screen has dozens of options. See Find Properties and Settings.
Find where a Connection, Listener, or Format is used
In the Connections window, select a Connection, Listener, or Format, then click Find Usage at the bottom of the screen to see every flow that references it.
Create and manage Connections and Formats
Create them from the Connections window. Use the search box in the gallery to find the connector or format type you want.
Filter existing Connections by name or tag in the main list.
Create and manage Flows
Create flows from the Flows window. The gallery search supports source-to-target patterns and action names. Examples:
- Database to file
- Web service to database
- Well-known API to database
- Queue to database
- File to file
- XSL / JavaScript / Python / SQL
- Merge / Copy
- CDC
- Snowflake / Redshift
In the main Flows list, filter by name or tag, and click the status indicator to see errors, statistics, and the most recent execution.