Integration hub etl

Khanna Ji · ‎08-02-2020

What does ETL stands for here

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

Ankur Bawiskar · ‎08-02-2020

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

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Ankur Bawiskar · ‎01-29-2021

Not much sure on that part.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Khanna Ji · ‎01-29-2021

AMDB? Is it Asset Management Database? As per my info, it can be used for any table in ServiceNow

Shail4 · ‎02-01-2021

Yes, its Asset Management Database and I had the same understanding that it can be use for any table however I couldn't find asset table/class in IntegrationHub ETL.

Ankur Bawiskar · ‎10-05-2020

@ServiceNow User

Hope you are doing good.

Let me know if I have answered your question.

If so, please mark appropriate response as correct & helpful so that this thread can be closed and others can be benefited by this.

If not, please let us know if you need some more assistance.

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

manoj_s · ‎03-27-2021

When trying to bring data from SCCM . We want to use the last hardware scan date from SCCM into the Most recent discovery date in the Computer .

But Using the Service graph for SCCM ( Integration ETL) even when we map the Most recent discovery date in the Mapping to last hardware scan date, the IRE is overriding it with the Update date of the CI.

Has anyone tried to do this in IntegrationHub ETL ?