Guide to develop Custom ETL Map to process JSON Files for Domain Separation

Madhava B
Tera Contributor

Hi,

 

As an Architect for Big Service Provider Client, I was asked to develop a solution to import CI data from Multiple Customers of Service Provider. Initially explored Service Graph Connector option, but didn't get expected result. So decided to explore option of developing a custom ETL Map to import CIs. Want to share the knowledge here so that it will useful to someone.

 

High-level Steps Involved,

 

1. Create a Data Source with File type JSON

MadhavaB_0-1726472359857.png

2. JSON File format

MadhavaB_1-1726472714014.png

3. Create ETL Map using IntergrationHub ETL

MadhavaB_3-1726472812874.png

 

MadhavaB_2-1726472778697.png

 

To Onboard new customers,

1. Add data source for each customer

2. Add Robust Import Set Transformer record

3. Scheduled Import Job

 

At NewRocket we have dedicated CMDB Capability team with vast experience into Custom ETL Development, Please reach out to us to know more information.

 

Regards,

Madhava

0 REPLIES 0