Importing excel data into multiple tables at the same time?

[jw9]

Hi,

I have an excel file that contains specific data about servers. The CIs that needs to be updated are in the Windows Server and Linux Server tables. If I run this with a transform map for cmdb_ci_server, other tables could get updated that shouldn't. For example Hyper-V Servers that have the same name as the Windows Servers.

So how could I get the import only to point to the cmdb_ci_windows_server and cmdb_ci_linux_server tables?

I have looked at both RTE and some similar answers that suggested transform scripts but not found a definite answer if this is possible or not.

Thanks!

[Maik Skoddow]

Hi

yes this is possible with the good old import approach using several transform maps. Each transform map points to an individual table and for your import you can select the transform maps and in which order they should be executed.

Kind regards
Maik

[Maik Skoddow]

Hi @jw 

In case you think I was able to answer your question, I would be happy if you mark the appropriate response as "correct" so that the question will appear as resolved for other users who may have a similar question in the future.

If not, please tell me what you are still missing!

Many thanks & kind regards
Maik

[Tony Branton]

If you have an entitlement to use IntegrationHub-ETL, then I recommend using that to work with your data source. IH-ETL makes mapping data to multiple tables much easier to do than working with import sets and transform maps.

If IH-ETL isn't an option for you then using multiple transform maps as @Maik Skoddow mentions is the way to go.