Integration Hub ETL Import from Excel sheet

Vinay2509
Tera Contributor

‎10-18-2023 04:25 AM

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

0 Helpfuls
  • 520 Views
3 REPLIES 3

VivekSattanatha
Mega Sage
Mega Sage

‎10-18-2023 05:09 AM

@Vinay2509 

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.

0 Helpfuls

Vinay2509
Tera Contributor
In response to VivekSattanatha

‎10-18-2023 05:27 AM

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 NameModel Number
Equipment Name123
Card Name234
Slot Name345
Port name567

 

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

0 Helpfuls

VivekSattanatha
Mega Sage
Mega Sage
In response to Vinay2509

‎10-18-2023 06:07 AM

@Vinay2509 

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

0 Helpfuls