Lumos and SeviceNow integration

[kanhaiya_work]

We are looking to integrate Lumos with ServiceNow for user and HR profile creation.

Lumos team is saying that they have pre-built connector to integrate with ServiceNow to create users directly in sys_user table, and don't have any scope to set staging table name.

However, we do not want to allow them to insert or update record directly in our actual table, we want them to insert/update in our staging table, and transform map will handle to update the actual table.

Is it possible? Has anybody done this same integration?

[Nayan ArchX]

Create transform maps in Enterprise Service Management Integrations Framework

https://www.servicenow.com/docs/bundle/xanadu-employee-service-management/page/product/human-resourc...

ServiceNow community Q&A where users discuss transform maps handling user → HR profile logic after staging.

https://www.servicenow.com/community/hrsd-forum/transformation-map-to-import-user-and-create-hr-prof...

https://www.servicenow.com/community/hrsd-forum/import-sets-in-hr-scope-problem-with-write-to-tables...

https://www.servicenow.com/docs/r/xGHm5nN1KlkEq58WJHJoPw/hO3YFSLbsh4cnHsIiqcZbA

If my response has resolved your query, please consider giving it a thumbs up ‌‌ and marking it as the correct answer‌‌!

Thanks

Nayan Patel

IT ServiceNow Consult, ServiceNow ArchX

If my response has resolved your query, please mark it Helpful by giving it a thumbs up and Accept the Solution

[kanhaiya_work]

Hi @Nayan ArchX,

Did you integrate Lumos and ServiceNow?

Do you know if Lumos has ability to insert records in ServiceNow staging table?

I believe that you explained how things work in ServiceNow. I know all of those things already.

[Nayan ArchX]

This may help you https://developers.lumos.com/reference/overview

[Vishal36]

Hi @kanhaiya_work, 

No, this is not possible if Lumos’ pre-built connector is hardcoded to write directly into the sys_user table. Transform maps in ServiceNow only execute when data is inserted into a staging or import table. They do not trigger on direct writes to production tables like sys_user.

If Lumos cannot configure the target table, you will not be able to enforce the staging → transform → target pattern using their connector alone.

To achieve this controlled architecture, you would need either:

Lumos to support writing into a staging table
A middleware layer to route data into a ServiceNow import table
A custom integration using ServiceNow APIs
You may want to consider a custom integration approach like OpsHub 's SDK that will help you to build an integration that writes data into a ServiceNow staging table first and then apply transform maps before updating the sys_user table in a controlled and governed manner.

All the best!