Import Business applications to Enterprise Business Application Portfolio

Jim Garrett
Tera Contributor

Have hundreds of Business Applications to add to the Enterprise Business Application portfolio.

Manual import is slow and requires several steps physically - i.e. takes at least a minute or more to enter.

====

We've tried imports to the dpm_enterprise_taxonomy_node_entity_m2m table using:

- Transform Maps with Sys_ID and /or name and Source Scripts

BUT the way the data is stored in the Document ID (ex: Business Application: BusinessAppName123)

It results in an entry with an <empty> value in the Document ID

========

Has anyone been successful in importing the Business applications from a single array?
Taxonomy node name                       Document ID

Below a screenshot from Demo Data in PDI (Thanks for any suggestions / solutions)

JimGarrett_0-1751318324516.png

 

1 REPLY 1

Damhoej
Giga Guru

Have you tried to use IntegrationHub ETL as the import tool?
There you can transform data so you will get the correct "value" to enter in the field.
Some of the fields are display values and need the SYS_ID to populaste properly