Integration hub etl

[Khanna Ji]

What does ETL stands for here 

https://docs.servicenow.com/bundle/orlando-servicenow-platform/page/product/configuration-management/concept/integrationhub-etl.html

[AbhishekGardade]

ETL is short for Extract, Transform, Load

Thanks

-Abhishek Gardade

[Sudhanshu Talw1]

Hi,

ETL stands for extraction, transformation, and loading.

When you create an integration, you import source data, transform data if needed, and select target CMDB classes and attributes to map the data to. Eventually, you run an integration test of the sample data, using your settings in the IntegrationHub ETL.

You can then preview the integration test results and adjust any settings before scheduling recurring integration runs for large data sets. If you develop and test the ETL transform map on a development instance, then you can test and adjust the configuration before implementation on a production instance.

Following video will help:

https://www.youtube.com/watch?v=YvsCY0M7JLw

Mark it helpful/correct.

Thanks

Sudhanshu

[Ankur Bawiskar · Accepted solution]

Hi,

Please find below points

• ETL is a type of data integration that refers to the three steps (extract, transform, load) used to blend data from multiple sources.
• It's often used to build a data warehouse.
• During this process, data is taken (extracted) from a source system, converted (transformed) into a format that can be analyzed, and stored (loaded) into a data warehouse or other system.
• Extract, load, transform (ELT) is an alternate but related approach designed to push processing down to the database for improved performance.

In terms of ServiceNow when you want to integrate 3rd party data into tables such as CMDB you would use that.

You can download the ETL app from ServiceNow store.

Sharing few links for help

https://blog.vsoftconsulting.com/blog/understanding-servicenow-integrationhub

https://docs.servicenow.com/bundle/orlando-servicenow-platform/page/product/configuration-management...

Regards
Ankur

[Shail4]

Hi Ankur,

Can we use IntegrationHub ETL to populate data in AMDB?