question Re: Integration Hub ETL Import from Excel sheet in Employee Slate and Employee Center forum

Integration Hub ETL Import from Excel sheet

VinayG260465653 — Wed, 18 Oct 2023 11:25:14 GMT

Hi Team,

I am using Integration HUB ETL to load/Import data from Excel sheet.

As I am aware that it works fine for One source to Single Target table.

Also it works fine for One Source to Multiple tables, only when Excel has data in only one Sheet tab.

Ex: I am importing data of Equipment, Slot, Port, Card data all related data in one sheet, not in different sheet, This case will work.

Now Question is: In Sheet we have Field column and it has Equipment name, Card Name, Slot Name, Port name as records of Field column.

In this case How to map fields and how we will come to know which row is getting updated in target table.

Do we have any mechanism or Business rules or Logic behind this?

Please advise if any script related that helps Integration HUB ETL

Thanks in advance!

Vinay

Re: Integration Hub ETL Import from Excel sheet

VivekSattanatha — Wed, 18 Oct 2023 12:09:04 GMT

@VinayG260465653

Please navigate to your CMDB Integration Studio Application's data source record within the 'cmdb_inst_application_feed' table. Within this record, you can configure both the "before" and "after" scripts. In the "before" script, you can access the IRE payload, and in the "after" script, you can retrieve the result of the IRE payload. This allows you to track and identify the specific records that have been updated through this process.

Re: Integration Hub ETL Import from Excel sheet

VinayG260465653 — Wed, 18 Oct 2023 12:27:43 GMT

Hi Vivek,

Thanks for the response!

But catch here is, in the below excel data, we have Field column with records. Each record should go to their respective targeted table in CMDB

Ex: Equipment name record should go to Equipment Table

Card name record should go to Card table

Slot name record should go to Slot table

Port name record should go to Port table

Field Name	Model Number
Equipment Name	123
Card Name	234
Slot Name	345
Port name	567

Please advise how do we map this to multiple targeted table using Integration HUB ETL(excel import) and how to segregate this data in target table?

Thanks in advance

Vinay

Re: Integration Hub ETL Import from Excel sheet

VivekSattanatha — Wed, 18 Oct 2023 13:07:44 GMT

@VinayG260465653

The excel format should be changed and it should be there in one row.

Re: Integration Hub ETL Import from Excel sheet

Miroslaw M — Tue, 04 Nov 2025 04:50:43 GMT

can you provide steps on how you are doing it for even one source to one target table?