Contents x
    STEP2 Previewing Data Setting and Making Detailed Settings
      • Print
      • PDF
      Contents

      STEP2 Previewing Data Setting and Making Detailed Settings

        • Print
        • PDF
        Article summary

        summary

        This page describes ETL Configuration STEP 2 "Data Preview and Advanced Settings".

        STEP2 Data Preview and Advanced Settings

        In STEP 2, you can see a preview of the data to be transferred.
        Then, detailed ETL Configuration settings are made for the ETL Configuration data.

        Schema Data Preview

        Proceeding from STEP1 to STEP2, a preview of the transferred data is first created.
        The preview shows the columns, data types, and values to be retrieved from the Data Source.

        Time to create preview

        Depending on the size of the data and other factors, it may take several minutes to create a preview.

        • Preview in progress
          image
        • Preview creation complete
          image
        If the preview result is different from the data you want to get

        Click on STEP 1 Data Source and Data Destination Configuration at the top of the screen to re-configure the settings.
        If you go back to STEP1, modify the settings, and try to go to STEP2 again, the following dialog box will appear.
        At this point, select Run Automatic Data Setting, make your decision, and click Next.
        image

        Note that if you create the preview again in STEP2, the STEP2 settings you had made before returning to **STEP1 will be reset. **
        Please note

        Advanced Settings

        In STEP 2, you can perform detailed ETL Configuration regarding ETL Data Settings.
        If you are satisfied with the preview, scroll down to the bottom for advanced settings.
        The advanced settings are separated by the following four tabs

        image

        Data Setting

        This section includes Column Setting and Filter Setting for each column.
        See Template ETL and Programming ETL for more information on the various settings on the Data Settings tab.

        Input Option

        ETL Configuration options for Data Source.
        Note that the options available for ETL Configuration depend on the Data Source Connector.

        Output Option

        ETL Configuration options for Data Destination.
        Note that the options available for ETL Configuration depend on the Data Destination Connector.

        About File/Storage System Connector

        Please refer to the following for the setting items of Input Option and Output Option regarding File/Storage System Connector.

        Job Setting

        Data Settings related to Job Settings during ETL Job.

        Next Steps

        Once you have completed the above settings, be sure to click****Preview Changes at the bottom of the page.
        You must click Preview Changes for the settings to take effect.

        Check the preview again and if all is well, click on the "Confirm" button.
        Proceed to STEP3 Confirm and Apply.

        image

        Was this article helpful?
        What's Next