ETL+ Settings Page v2022.02

Owned by Cortlandt _
Oct 04, 2023
2 min read

Client Info: Click the button to view client information.

Error Retry: When hitting certain extraction errors, retry up to 3 times waiting 3 seconds between retries.

Debug Mode: Use the dropdown list to set the debut mode to Levels 1 or 2. This creates an additional log file with debug information in the ETL+ folder. The file is named “Log <EntityID>_Debug.txt”.

0_EntityID Column: Check this box to create an additional column in data warehouse tables where the column name and content is set to 0_<EntityID>.

Data Warehouse: Only available for Super Admin users. Allows the maintenance of the ETL+ data warehouse settings.

About: Click the button to read ETL+ About.

P&L: When GL Financials templates are included with your DataSelf order, this dropdown sets your Profit & Loos format to EBITDA or Standard.

FYear Start: When your DataSelf order includes fiscal period based reporting, this dropdown sets your calendar-based fiscal period start. For instance, setting this to Feb considers your FYr start on Feb 1st. Consult DataSelf for other non-standard fiscal year templates.

Reporting Date: This dropdown sets if the reporting date is today, yesterday or the last day of the last month. This setting might require further template customizatios.

CYE Value: Not in use currently.

Refresh Batch Notification Email: Defines Refresh Batch email notification settings:

  • Subject: Sets the first word(s) in the email subject.

  • Email: Include the email addresses of recipients of Refresh Batch notifications. Separate emails with commas.

  • Notification Dropdown: Select one of the following notification rules:
    - Always Notify: ETL+ always sends a notification at the end of executing a Refresh Batch.
    - Notify on Error: ETL+ only sends a notification at the end of executing a Refresh Batch if at least an error was logged, and/or if a refresh batch didn’t execute on its expected WTS schedule.
    - Cloud - Always Notify: The same as Always Notify but sent from DataSelf cloud servers. Use this option for on-premises ETL+ that can’t connect to DataSelf SMTP server.
    - Cloud - Notify on Error: The same as Notify on Error but sent from DataSelf cloud servers. Use this option for on-premises ETL+ that can’t connect to DataSelf SMTP server.
    - No Notification.