ETL-connectors
ETL connectors
ETL Parsing allows administrators to manage the processing of analytics data on the ETL server directly from the Admin Panel.
Available ETL connectors:
List
Admins can view all created ETL presets with the following information:
- Name – preset name
- Connector type – type of ETL connector (Power BI, Qlik Cloud, PBIRS, etc.)
Available actions:
- Create New Preset – opens the form to create a new ETL preset
- Server credentials – manage authentication details for the ETL server (required before creating presets)
- Delete preset – removes a preset from the list
- Start preset parsing – initiates data processing for the preset
- Edit configuration – modify parsing and update settings
Create ETL Preset
Admins must fill in the Server credentials before creating a new preset.
Fields for ETL presets:
| Item | Description | UI |
|---|---|---|
| Name | Unique name to identify the ETL preset | input field |
| Connector | Select the ETL connector type (Power BI, Qlik Cloud, PBIRS, etc.) | drop-down list |
| Auto-update time (by UTC) | Time when the preset will be automatically updated (24-hour format, UTC) | drop-down list |
| Notification emails | Email addresses to receive notifications when ETL processing completes. Use commas to separate multiple addresses. Mail server credentials must be configured | input field |
| Enabled | Toggle to enable or disable the preset | switcher |
Edit ETL Preset
Admins can edit an existing preset via the Configuration button.
Configuration Tab
| Item | Description | UI |
|---|---|---|
| Name | Edit the preset name | input field |
| Connector | Displays the connector type (cannot be changed) | drop-down list (disabled) |
| Sync user permissions | Enables synchronization of user permissions from the source system. When active, the system compares user access data from ETL (Auditor data) with users on the Hub and updates permissions accordingly. | boolean button |
| Unblock the users if they have any access | If enabled, the system automatically unblocks users on the Hub who have access to at least one report in Power BI as of the current sync date. | boolean button |
| Auto-update time (by UTC) | Adjust the automatic update schedule (24-hour format, UTC) | drop-down list |
| Notification emails | Modify emails for completion notifications; multiple addresses must be separated by commas | input field |
For more detailed information about the synchronization logic and user activation behavior, refer to the ETL user synchronization logic page
Credentials Tab
Admins must provide server authentication details to allow the ETL connector to access the data source.
| Item | Description | UI |
|---|---|---|
| ETL link | URL or host address of the ETL server | input field |
| ETL token | Token for authentication and access to ETL server | input field |
⚠️ Server credentials are mandatory; presets cannot be created without them.
Filters Tab
Admins can manage filters applied during ETL processing:
- Click a filter name to edit
- Click the trash icon to delete a filter
- Action buttons:
- Sync filters – synchronizes filters from the ETL server
- Create filter – manually add a new filter
Filter fields:
| Field | Description | UI |
|---|---|---|
| Type | Type of filter (IP, Email, Workspace) | drop-down list |
| Value | Value for the filter | input field |
Error Logs Tab
Displays system messages and errors related to ETL processing:
| Date & Time | Message |
|---|---|
| 2025-05-21 00:00:22 | 403: Forbidden |
| 2025-05-21 01:45:10 | EnrichJob finished |
Date format: YYYY-MM-DD hh:mm:ss (UTC)
Purpose
ETL Parsing is required for:
- Analytics processing for reports (Power BI, Qlik, PBIRS)
- Onboarding screen logic
- BI access synchronization (locks, filters)
- Displaying view and viewers statistics on object cards
Setup Overview
- Access the ETL Connector section in the Admin Panel
- Fill in Server credentials (mandatory)
- Create and configure parsing presets, including update schedules and filters
Connector Types and Credentials
- Power BI – Standard API, requires Power BI token
- PBIRS – Requires SFTP access and a token for BI synchronization
- Qlik – Similar to BI connector; token required; BI access sync for Qlik will be available in future releases
Filter Management
- Filters can be:
- Synchronized from the ETL server
- Created manually
- Deleted (preferably after synchronization)
Logs
- Execution errors are logged in the Error Logs tab
- Extended logging is planned for future updates