Data load and transform map through Catalog Item

[varma2]

Hi All,

I need to import data load and transform map through catalog item. When ever user submit a request with attachment the data should load  through transform map via ritm only.

Please suggest how it possible.

Thanks,

Hari

[Jaspal Singh]

Hi,

Look for blog that has multiple options to create catalog item & one of them being creation via import sets.

Alternatively you can also check blog from Ankur

[P-Rudenko-SN]

Most likely, you'd have to use the Integration Hub in order to achieve this. So for example the following can be done:

1. Once the user submits the request, the attached file is getting uploaded to the shared drive.

2. You'd need to create a Data Source with pre-defined Transform Map.

3. The Data Source will pick up the files uploaded to the shared drive, and run the import into the target table.

[Ankur Bawiskar · Accepted solution]

Hi,

I have written article for same

Refer that and do the steps mentioned in that.

Please mark it helpful as well

Data load and transform via Catalog Item

Just one thing to remember if you are doing your catalog item in scoped application then you should allow Can Delete access

Regards
Ankur

[varma2]

Hi Ankur,

Congratulation for NO.1 in community leader.

I tried above your suggestion created catlog its improting the data in cmdb_hardware_product_model. But we have a reference field called Manufacture its not fetching currect domain Manfacture value. its taking another domain value in manufacture field.

And also we have multiple same manufacture names for differnt domains also,  it should be pickup right domain manufacture name.

Note :- we are using Domian  saparatinon instance.

And also record which is imported creted by showing sysytem not requested for user.

Please suugest.

Thank you,

Varma