How to edit a Service Graph Connector mapping?

[davidmcdonald]

This is probably a silly question, I feel like I've missed something obvious, but how do you edit the mapping of a Service Graph Connector like the SCCM Service Graph Connector?

In previous versions, it was just a transform map that could be edited. Value scripts, custom mappings, onAfter scripts, all able to be modified.

Now, it looks like it goes through the Robust Transform Engine, which doesn't look like it's easy to edit using classic forms. I'm guessing here's some sort of studio I should be using instead. I just want to change the mapping to include a new field from SCCM and map it to a field in the CMDB.

I installed the "IntegrationHub ETL" plugin which installed the Integration Studio, however although I can see the imports in a list, when I open one it sends me to a guided setup assistant, which doesn't sound right because the SCCM connector should already have been developed.

Imports in a list in the IntegrationHub ETL studio.

After clicking on an import:

Anyone able to point me in the right direction on how to edit the mapping for a Service Graph Connector?

[Bala Krishna2]

HI David,

You are right direction . 

Easiest way to add a new field map is through Integration Hub ETL. 

Step 1: Modify query to pull new field data.

Step 2: Go to integration Hub ETL 

            Complete Step 1 and Step 2( Where you should find the new attribute added from query)
Step 3: Map your new attribute

Step 4: Test and verify data.

Although these can done directly on CMDB rte def table as well.

Regards,

Bala Krishna 

Aelum Consulting.

[ram_mandadapu · Accepted solution]

Hi David,

You are on the correct path. Please open each step and mark it as complete.

In step 3, you should be able to edit the mappings. Please follow this tutorial. 

[davidmcdonald]

Ah yep, that got it!

Marking steps 1 and 2 as completed allows access to step 3 which lets me make changes to the mappings.

Here it is in the ETL Mapping Assistant with steps 1 and 2 completed.

And here are the editable mappings in "Select CMDB Classes to Map Source Data", where I can see the "Edit Mapping" button.

Here are some of the mappings. A lot of the available fields are empty, I suspect that they get populated once I've done a test import and there is data in the staging table.