Contents x
    Configure convenient settings related to ETL Configuration (e.g. Schedule)
      • Print
      • PDF
      Contents

      Configure convenient settings related to ETL Configuration (e.g. Schedule)

        • Print
        • PDF
        Article summary

        summary

        TROCCO allows you to make various useful settings for the ETL Configuration you have created.
        There is a Schedule setting****that allows the user to set the timing of automatic job execution, a Notification setting that notifies the user of the results of executed jobs, errors, etc., and a Change History that allows the user to view and restore past changes to ETL Job Configuration.

        Schedule and Notification Settings

        Schedule and Notification settings can also be set for Data Mart Configuration and Workflow Definitions.

        ETL Configuration details screen

        The ETL Configuration Details screen is divided into the following four tabs
        For the procedure for displaying the ETL Configuration details screen from the TROCCO top screen, see Executing an ETL Job.

        image

        ETL Configuration Overview

        View recently executed ETL Jobs, Data Source and Data Destination Settings, and execution previews.
        Labels can also be removed from the menu on the right side of the screen.
        image

        Schedule

        ETL Job Setting Schedule for automatic execution of ETL Jobs.
        Schedule Setting makes it possible, for example, to "automatically run a job every Sunday at 8:00 p.m.".

        Click on "Add Schedule" to set it up.
        The frequency of Schedule can be selected from hourly, daily, weekly, or monthly.

        image

        image

        Notification settings

        Job Setting for notifications about executed ETL Jobs.
        Notification settings allow you to

        • I want to be notified when an ETL Job fails.
        • I want to be notified when the Incremental Data Transfer result is 0.

        See Creating Notifications for more information on how to set up notification settings.

        image

        change log

        View a history of changes made to ETL Configuration.
        You can see the details of past ETL Configurations as well as in the form of Incremental Data Transfers between before and after the ETL Configuration was edited.
        You can also restore past changes.

        The following issues can be addressed by utilizing the change history

        • After changing ETL Configuration, ETL Configuration is no longer working properly. I want to return to the original settings.
        • Other members who share the setting made changes. I want to check the difference before and after the change.

        image

        If you want to restore past settings

        Click on Advanced/Restore for the revision you wish to restore.
        Check the differences in the revision details, and if all is well, click Restore Revision Settings.
        image

        The subsequent steps are the same as in ETL Configuration STEP3.

        Was this article helpful?
        What's Next