Change configuration

• Startup
• Business
• Enterprise
• On-Premise
• Add-on

This function is only available to customers with dedicated instances. Only a SuperAdmin user has access to Configuration.

To configure Etlworks, open Configuration and select a category in the left navigation bar.

Configure appearance and links

Select General to configure the appearance, links, and default email addresses.

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

This is required for adding new users, resetting passwords, and sending email notifications.

Etlworks uses SMTP to send email notifications.

Select Mail to configure the SMTP server parameters for sending email notifications.

Etlworks support the following email configurations:

• Custom SMPT - works with most SMTP server which support username+password authentication.
• GMail - works with gmail and Google Workspace mail. Requires OAuth authentication with Google.
• Office365 - works with Office 365 mail. Requires OAuth authentication with Microsoft.

Custom SMTP

Select Custom SMTP inType. Enter SMTP server parameters.

Gmail

Make sure SMTP is enabled for your Google account. 

Select Gmail inType. Enter the FROM email account in  Email. Click Sign in with Google.

Make sure to sign in with the same account as entered in Email.

Office 365

Make sure SMTP is enabled for your Microsoft account. 

Select Office365 inType. Enter the FROM email account in  Email. Click Sign in with Microsoft.

Make sure to sign in with the same account as entered in Email.

Testing email configuration

Click Send test mail to test the SMPT configuration. 

Configure network

Please contact Etlworks support before making any changes in this category.

Select Network to configure how the service works in case there is a multi-node cluster deployment.

Configure flows

Select Flows to configure the maximum number of records that will be displayed when the user clicks Test transformation.

You can also suspend and resume flow executions under this section.

Configure listeners

Select Listeners to configure asynchronous POST/PUT Listener requests throttling and queuing.

Configure Explorer

Select Explorer to configure

• The maximum number of records which can be displayed in the Etlworks Explorer,
• The maximum number of items that can be displayed in the SQL history
• The Data structure sample records which controls how many records the ETL engine will sample to determine columns and data type when reading the metadata for the connection. This parameter is not used when retrieving the metadata for the database connections. 

Configure timezone

Select Timezone to configure the server and account timezone.

Configure maintenance tasks

Select Maintenanceto configure maintenance tasks. 

Configure global search

Select Search to configure global search parameters.

• Max Results: the maximum number of search results to return.  The default is 20. 

Configure Security

Select Security to configure Export/Import Encryption and SSO.

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 Super Admin. The system administrator can disable API keys for roles other than API user. The API keys are enabled for all roles by default.