Search Knowledge Base by Keyword

Edit Mapping

< Back

From the Mappings tab, you can edit mappings. To edit:

    1. Click the hyperlink of the Name field to edit the mapping
  1. Edit the main query of the mapping in the query window. Data mapping can access the connected ETL database and the ReadyWorks database.
    NOTE: When using SQL functions for columns, be sure to use aliases signified by the keyword AS (see Line 2 in sample query below).

    1. Use the editing buttons to format the query
      1. Undo – Undo the last edit
      2. Redo – Redo the last edit that was undone
      3. Block Outdent – Remove an indent from a line or block
      4. Block Indent – Set a line or block in from the margin
      5. Comment – Comment out a line or block
      6. Limit Result – Select the number of rows to display from the drop down (100 (default), 500, 1000, All)
      7. Theme – Color theme of query (Theme1, Theme2)

        NOTE: Theme was deprecated in version 7.6.0912.
      8. Add SQL – Add sample SQL to the query
      9. Add Variable – Add mapping variable to the query

        1. App Filters Variable – Insert variable %[etl_app_filter__cm.name]% to filter a query based on App Filters
          1. Example Query: SELECT * FROM readyworks_etl5.cm_computerprogram cm WHERE %[etl_app_filter__cm.name]%
    2. Click the button to add a helper query. Data mapping can access the connected ETL database and the ReadyWorks database.
    3. Click the name of a query to expand or minimize the query window
    4. Click the button to run the query and preview the output before saving
      1. Select the number of rows to display from the drop down (100 (default), 500, 1000, All)
    5. Click the button to bring op the Settings dialog
      1. Configure the mapping settings and then click the Close button
             

        1. Show Data in Output – Choose if data is displayed in output
        2. Enable Audit – Choose if auditing (logging) is enabled or disabled
        3. Date Display Format – Date display format of the user (yyyy-mm-dd, mm/dd/yyyy, dd/mm/yyyy, dd mon yyyy)
        4. Time Display Format – Time display format of the user (24hr format, 12hr (AM/PM) format)
        5. Synch Type – Select the type of synch (Linking Records, Linking Waves, Unlinking Waves, Linking Tasks, Unlinking Tasks)
          1. Reload Links – Drop and reload links for the selected data type
          2. Append Links – Append new links for the selected data type
        6. Show Execution Details – Choose if verbose output is displayed during execution (Linking Records, Linking Waves, Unlinking Waves, Linking Tasks, Unlinking Tasks)
    6. Click the button to run the data mapping (as it would from a cron job)
    7. Click the button to expand the query to full window mode. Click the button to exit full window mode.
    8. Use the menu to manage queries
       

      1. Ignore from Execution – Ignore a query from execution
      2. Rename Query – Rename a query
      3. Move Up – Move a query up in the order
      4. Move Down – Move a query down in the order
      5. Delete Query – Delete a query
    9. Use the floating toolbar to format, run, and save the query when you are scrolled down
  2. View the results of the query in the Output window

    NOTE:     Encrypted data columns are masked to the end user when viewing the output.
  3. Enter the mapping properties in the Mapping Properties window

    1. Mapping Name – Name of the mapping (required)
    2. Mapping Type – Type of the mapping (Data Columns, Linking Records, Linking Waves, Unlinking Waves, Linking Tasks, Unlinking Tasks)
    3. RW Target Table – Select ReadyWorks table that is the target of the mapping
    4. Source Column (ETL) – Select source column of the mapping
      NOTE: The Name field of a data record cannot contain the string ” | “.
    5. Target Column (RW) – Select target column of the mapping
    6. Allow Null / Zero – Choose if value of the mapping can be set to NULL or zero
      NOTE: Enable Allow Null to overwrite data when the source changes to NULL (or directly through the SQL statement). When disabled, NULL values are skipped.
    7. Conversion – Select conversion method of the mapping
      1. Boolean
      2. Checkbox
      3. Date
      4. Datetime
      5. FQDN
      6. GUID
      7. NetBIOS
    8. Use the menu to manage rows

      1. Move Up – Move a row up in the order
      2. Move Down – Move a row down in the order
      3. Ignore – Ignore a row
      4. Delete – Delete a row
    9. Add Row – Add new rows for additional mappings
    10. Remove All – Remove all rows
  4. Click the button to Quick Save or Full Save the mapping. A Quick Save does not run the query while a Full Save does and can take longer to save depending on the query.
    NOTE: The RW Target Table is required to save a mapping.

Query

From the Edit Mapping page, you can manage the mapping queries. To manage the mapping queries:

  1. Edit the main query of the mapping in the query window. Data mappings can access the connected ETL database and the ReadyWorks database.

    1. Use the editing buttons to format the query
      1. Undo – Undo the last edit
      2. Redo – Redo the last edit that was undone
      3. Block Outdent – Remove an indent from a line or block
      4. Block Indent – Set a line or block in from the margin
      5. Comment – Comment out a line or block
      6. Limit Result – Select the number of rows to display from the drop down (100 (default), 500, 1000, All)
      7. Theme – Color theme of query (Theme1, Theme2)

        NOTE: Theme was deprecated in version 7.6.0912.
      8. Add SQL – Add sample SQL to the query
      9. Add Variable – Add mapping variable to the query

        1. App Filters Variable – Insert variable %[etl_app_filter__cm.name]% to filter a query based on App Filters
          1. Example Query: SELECT * FROM readyworks_etl5.cm_computerprogram cm WHERE %[etl_app_filter__cm.name]%
    2. Click the button to add a helper query. Data mappings can access the connected ETL database and the ReadyWorks database.
    3. Click the name of a query to expand or minimize the query window
    4. Click the button to run the query and preview the output before saving
      1. Select the number of rows to display from the drop down (100 (default), 500, 1000, All)
    5. Click the button to bring op the Settings dialog
      1. Configure the mapping settings and then click the Close button
             

        1. Show Data in Output – Choose if data is displayed in output
        2. Enable Audit – Choose if auditing (logging) is enabled or disabled
        3. Date Display Format – Date display format of the user (yyyy-mm-dd, mm/dd/yyyy, dd/mm/yyyy, dd mon yyyy)
        4. Time Display Format – Time display format of the user (24hr format, 12hr (AM/PM) format)
        5. Synch Type – Select the type of synch (Linking Records, Linking Waves, Unlinking Waves, Linking Tasks, Unlinking Tasks)
          1. Reload Links – Drop and reload links for the selected data type
          2. Append Links – Append new links for the selected data type
        6. Show Execution Details – Choose if verbose output is displayed during execution (Linking Records, Linking Waves, Unlinking Waves, Linking Tasks, Unlinking Tasks)
    6. Click the button to run the data mapping (as it would from a cron job)
    7. Click the button to expand the query to full window mode. Click the button to exit full window mode.
    8. Use the menu to manage queries
        

      1. Ignore from Execution – Ignore a query from execution
      2. Rename Query – Rename a query
      3. Move Up – Move a query up in the order
      4. Move Down – Move a query down in the order
      5. Delete Query – Delete a query
    9. Click the button to Quick Save or Full Save the mapping. A Quick Save does not run the query while a Full Save does and can take longer to save depending on the query.
      NOTE: The RW Target Table is required to save a mapping.
    10. Use the floating toolbar to format, run, and save the query when you are scrolled down

Output

From the Edit Mapping page, you can view the results of a mapping query or set of queries. To view the results:

  1. Click the button to run the query and preview the output before saving
    1. Select the number of rows to display from the drop down (100 (default), 500, 1000, All)
  2. View the results of the query in the Output window

    NOTE: Encrypted data columns are masked to the end user when viewing the output.

Mapping Properties

From the Edit Mapping page, you can edit the mapping properties. To edit the mapping properties:

  1. Edit the mapping properties in the Mapping Properties window

    1. Mapping Name – Name of the mapping (required)
    2. Mapping Type – Type of the mapping (Data Columns, Linking Records, Linking Waves, Unlinking Waves, Linking Tasks, Unlinking Tasks)
    3. RW Target Table – Select ReadyWorks table that is the target of the mapping
    4. Source Column (ETL) – Select source column of the mapping
      NOTE: The Name field of a data record cannot contain the string ” | “.
    5. Target Column (RW) – Select target column of the mapping
    6. Allow Null / Zero – Choose if value of the mapping can be set to NULL or zero
      NOTE: Enable Allow Null to overwrite data when the source changes to NULL (or directly through the SQL statement). When disabled, NULL values are skipped.
    7. Conversion – Select conversion method of the mapping
      1. Boolean
      2. Checkbox
      3. Date
      4. Datetime
      5. FQDN
      6. GUID
      7. NetBIOS
    8. Use the menu to manage rows

      1. Move Up – Move a row up in the order
      2. Move Down – Move a row down in the order
      3. Ignore – Ignore a row
      4. Delete – Delete a row
    9. Add Row – Add new rows for additional mappings
    10. Remove All – Remove all rows

Settings

From the Edit Mapping page, you can configure the mapping settings. To configure the mapping settings:

  1. Click the button to bring op the Settings dialog
  2. Configure the mapping settings and then click the Close button
         

    1. Show Data in Output – Choose if data is displayed in output
    2. Enable Audit – Choose if auditing (logging) is enabled or disabled
    3. Date Display Format – Date display format of the user (yyyy-mm-dd, mm/dd/yyyy, dd/mm/yyyy, dd mon yyyy)
    4. Time Display Format – Time display format of the user (24hr format, 12hr (AM/PM) format)
    5. Synch Type – Select the type of synch (Linking Records, Linking Waves, Unlinking Waves, Linking Tasks, Unlinking Tasks)
      1. Reload Links – Drop and reload links for the selected data type
      2. Append Links – Append new links for the selected data type
    6. Show Execution Details – Choose if verbose output is displayed during execution (Linking Records, Linking Waves, Unlinking Waves, Linking Tasks, Unlinking Tasks)
Tags: