Breadcrumbs

ETL+ Settings Page

Open with Settings image-20240529-201405.png on the Extract, Transform and Load (ETL) or Job pages.

image-20230731-044436.png

  1. Help. Click to open documentation for this ETL+ page in a web browser (shortcut F1)

  2. Client Info: Click to open ETL+ Client Information Page.

  3. Debug Mode (Logging Levels): Use the dropdown list to set the debug log level.
    Levels 0, 1 or 2 creates an additional log file with debug information saved on the client’s hard drive (HD) in the ETL+ folder.

    image-20230731-041139.png

    • The debug log file is named “Log <EntityID>_Debug.txt".

    • For more about logs and logging see ETL+ Logging

  4. Log and Working Files Folder.

    image-20230731-041421.png

    _

  5. Browse for Folder

    image-20230731-041857.png

6. 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>. Hardcoded (enabled) in multi-tenant entities.

  1. Data Warehouse: Opens the New Data Warehouse or Data Ware List page depending on your user credentials. Formerly, only available for Super Admin users.

For more see

  1. P&L: When GL Financials templates are included with your DataSelf order. The P&L dropdown sets your Profit & Loss format to EBITDA or Standard.

    image-20230731-042554.png


  2. 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.

    image-20230731-042853.png

  3. Reporting Date: This dropdown sets if the reporting date is today, yesterday or the last day of the last month.

    image-20230731-043503.png

    • The Reporting Date setting might require further template customizations.

Options used by the ETL+ Time Series Tables in zData Warehouse based upon today’s date. See ETL+ Time Series Tables in zData Warehouse

  1. CYE Value: Not in use currently.

  2. About. DataSelf ETL Plus - About page.

Refresh Batch Notification Email: Subject line text of, and Email addresses to receive, Job notifications.

  1. Refresh Batch Notification Email – Subject. The first/leftmost word(s) in the email subject.

  2. Refresh Batch Notification Email – Email. Include the email addresses of recipients of Refresh Batch notifications. Separate email addresses with commas.

  3. Notification options.

    image-20230731-044920.png

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.

  1. Back. Return to the calling page.




Keywords: email, Refresh Batch Notification Email


v2023.07 ✅