Overview
System configuration allows Super Admin users to control global behavior of Etlworks, including UI settings, execution behavior, security, integrations, and maintenance.
Access
From Account Menu
Top-right menu → PLATFORM → Settings
From Navigation Panel
Navigation Panel → Settings
Find Settings
Etlworks provides a search field hat allows you to quickly find settings.
How it works
- Enter a keyword in the search field
- Matching fields are shown or highlighted
- Non-matching fields are hidden
General Settings
Configure appearance and basic system behavior.
You can change the following along with other parameters:
- The application name (the default is Etlworks)
- The company logo (large, small, and override for the blue-on-blue color themes)
- The default color scheme
Configure email
Required for:
- User invitations
- Password resets
- Notifications
Etlworks supports:
- Custom SMTP (username/password)
- Gmail (OAuth or API)
- Office 365 (OAuth or Graph API)
Notes:
- OAuth-based authentication is recommended
- SMTP is deprecated by providers and may require manual enablement
- Always test configuration using Send test mail
Configure network
Used for multi-node deployments.
Contact Etlworks support before making changes.
Configure flows
Controls how Flows are executed and monitored.
Configure number of displayed and log records
Set the maximum number of records that will be displayed when the user clicks Test transformation. You can also change the default value for number of logged records during ETL transformations.
Configure inspection service
The flow inspection service is designed to analyze and identify potential performance bottlenecks and structural issues within executed flows. Learn about inspection service.
Detects performance and structural issues in Flows.
Superadmin user can:
- Configure minimum severity level
- Disable reporting
Truncate Exception Details in Error Notifications
By default, when a scheduled flow fails, the full exception stack trace is included in the email notification. To make these notifications easier to read and reduce clutter, you can enable the global setting “Truncate exception in failed flow email notification” under Settings → Flows. When this option is enabled, only the error description and message will be included in the email, without the full stack trace. This setting is disabled by default and must be manually turned on. Once enabled, it applies to all on-error notifications sent by scheduled flows running on both the host instance and Integration Agents.
Record detailed flow execution application log
When enabled, this option records additional diagnostic information for each flow execution in the Audit Trail.
-
The recorded data includes internal steps executed to run the flow, such as:
Collecting connection details
Preparing metadata
Initializing runtime components
Each step is stored as part of a steps array in the JSON payload attached to the audit-trail record.
Every step contains a name and a start time (with millisecond precision).
This feature can be useful in rare cases where you need to debug performance issues in flows scheduled to run in real time or at a high frequency. For example, it can help detect latency caused by external components such as managed Redis or the internal database.
Note: This configuration controls the flow execution process log that goes into the application log. It does not affect or replace the actual ETL process log.
Suspending and Resuming flow executions
User can suspend and resume flow executions under this section.
Environment Customization
Etlworks allows super-admin users to customize the execution environment by defining global and secure variables as well as predefined flow parameters.
Working with Environment Variables in Etlworks explains how to create and use environment variables and secure environment variables that can be referenced anywhere in flows, connections, schedules, and agents.
Predefined Flow Parameters and Auto Suggestions describes how predefined parameters and auto-suggestions help standardize configuration across flows and simplify setup.
Together, these features make it easy to manage environment-specific settings and reuse configuration values consistently across all integrations.
Configure listeners
Select Listeners to configure asynchronous POST/PUT Listener requests throttling and queuing.
Configure Explorer
Controls how data is displayed in Explorer.
Includes:
- Max number of displayed records
- Max SQL history items
- Sampling size for metadata detection
Configure timezone
Configure Administration Timezone.
Configure maintenance tasks
Configure system maintenance tasks.
Includes:
- Cleanup routines
- Background maintenance jobs
Configure global search
Configure global search behavior.
Configure Security
Select Security to configure Export/Import Encryption, SSO and some of the security policies.
Export/Import Encryption
In Etlworks it is possible to export and import flows, connections and formats. By default the export files are encrypted by built-in symmetric RSA key. You can upload your own symmetric RSA key and the system will use it to encrypt and decrypt the export files. The key can have an optional Passphrase.
Notes
- Export files encrypted by built-in key can be imported into environment with configured custom key.
- Export files encrypted by the custom key cannot be imported into environment with a standard built-in key.
SSO
Single sign-on (SSO) allows you to give your team members one account for all of the systems your business uses. If you have an Etlworks Enterprise or on-premise account and have SSO set up for your business, you can require users to log in to Etlworks using their SSO credentials.
The following SAML identity providers are supported:
- Active Directory Federation Service (ADFS).
- Azure Active Directory (AD).
- Google Apps.
- Salesforce.
- IBM ISAM
- OKTA.
- Onelogin.
- Auth0.
Contact Etlworks support at support@etlworks.com to configure SSO for your Enterprise or on-premise account. Read about configuring SSO with Azure AD as an identity provider.
After Etlworks support configures your Identity Provider in the SSO provider solution you will receive SSO Login and Logout URLs and Certificate that you need to configure under Settings -> Security.
Allow API key authentication
The API key can be used to authenticate the user when making a call to the user-defined and built-in API. The API key can be generated and assigned to the user with any role, including Admin. Account administrator can disable API keys for roles other than API user.
Optionally configure Max API Key TTL in days.
The API keys are enabled for all roles by default.
Enable Gravatars
If selected, user avatars will attempt to load from Gravatar using the user’s email address. When not enabled, the standard generated avatar is always used.
Configure AI
Use the AI section to control access to AI-assisted features and fine-tune AI-based template discovery.
Available settings:
Disable AI features: turn off all AI-powered functionality
OpenAI API key: overrides the default Etlworks-provided key
OpenAI main model: overrides the default model used for classifying prompts
Embedding OpenAI model: overrides the default model used for computing semantic similarity between prompts and templates
Templates max search results: maximum number of templates returned by AI search (default: 5)
Templates search minimum similarity threshold: minimum similarity score required to include a match (default: 0.3)
Note: The OpenAI API key, main model, and embedding model fields are optional overrides. Etlworks includes built-in defaults for these values. Most customers do not need to change them unless they prefer to use their own OpenAI account (e.g., to access higher token limits or custom usage tiers).