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)
- Apply transform operations to tailor data. OOB Transform types are listed in product documentation
- select Ignore in Mapping to exclude the column from mapping and integration in the current session
Additional Resources
Next Step
IH-ETL Guided Setup Step 3 – CMDB Class Mapping
