Previous Step

IH-ETL Guided Setup Step 1 - Basic Detail

In this step, you can preview the raw data pulled from data source and apply data transform operations if necessary (e.x. copy, to lower/upper case). Below is an example configuration:

1. Click “Preview and Prepare Data”

This displays a table that shows your existing data from the Import Set selected earlier.

From here you can create any new transformation you might need. This can include operations such as:

• Combining columns to create unique ids
• Extracting a name from a fully qualified domain name
• Replacing – in a MAC address with : to match a recommended format
• Specifying a specific hardware class based on attributes of the input
• Splitting make and model into separate fields

2. To create a new operation, click the menu button next to any column header and select “New Transform”

This opens the “New Transform” sidebar

3. As an example, select “Concatenation” as your Transform type

4. Add an additional input column of “u_mac” then set the description and name

5. Set a separator by setting “||” in the “Concatenate with string” field

6. Click “Apply” to see your new column

7. Click “Mark as Complete”

For nested data format, we provide additional functions

IH-ETL nested payload feature demo 4:15 - 11:05

Tips and Caveats

• Preview the data pulled from import set associated in the basic details section
• By default, IH-ETL will only preview 100 rows of data from data source. Use property “sn_int_studio.preview.size” to control the number (max 10k)
• select Ignore in Mapping to exclude the column from mapping and integration in the current session

Additional Resources

Landing page

IH-ETL common error scenarios

Next Step

IH-ETL Guided Setup Step 3 – CMDB Class Mapping