IntegrationHub ETL dynamically create entity field and mapping

[pethumdesilva]

Hello community members,

I have an ETL application and already created entity mapping using IntegrationHub ETL (3.2) guided experience.

But I want to customize the mapping, base on the user input(add new filed to entity and and map to target tables). this should be done via the script dynamically not using the IntegrationHub ETL (3.2 guided experience.

Is there any way to achieve this?

Best regards,

Pethum

[Kieran Anson]

Hi Pethum,

Can you provide a bit more context on "dynamically". You specify mappings in ETL in order to manipulate the data before assigning it to a field of a CI, you're unlikely to be able to achieve that dynamically as it requires human decision making. Unless I am misunderstanding your ask?

[pethumdesilva]

Hello Kieran,

Thanks for the reply, In this approach, custom field mappings are stored in a system property, allowing flexibility in adapting the ETL definition during scheduled imports. While a basic mapping is predefined within the ETL application, users can extend it by adding custom fields without modifying the core configuration. During the import process, the ETL reads the system property and dynamically incorporates these additional fields, ensuring a seamless and adaptable data transformation process. This method enhances configurability, enabling users to tailor data mappings based on evolving business needs while maintaining the integrity of the standard ETL framework.

Hope this is clear for you.

Best regards,

Pethum

[Kieran Anson]

There isn't a way to do this natively.

Some of the Service Graph Connectors would use script operations to do this, whereby they read a system property to know whether to map a value or not.

If you're building a solution that you're planning to put on the ServiceNow Store, you may want to speak with the store app review team for architectural advise. You may be over-complicating things with the new of simplifying the customers ability to adopt your ETL definition