Integrationhub ETL fails loading SCCM Servicegraph data sources

[Martijn Dessing]

Hi,

We upgraded excisting SCCM SG implementation to v3.2.1. 

We now want to change mapping of computer class and attrubute with the use of Integationhub ETL.

On the first step  for Basic details, when loading a SCCM data source and sample import set it returns the error, 

'Data source table already associated with 'SCCM Processor' ETL Map'

I does this on all instances (recently cloned Rome )

One way around this is to disable the data source in the Robust Import Set Transformer. 

But that will leave you with both a new empy mapping in IH ETL  and the next import run (also a test run) will fail (in loading state) because the transform is missing.

Also is appears that IH ETL can not save new mappings, After a new mapping is added, it gives the message that the mapping is saved, but after returning to the mapping form, it is gone.

So why is IH ETL not able to edit the current datasource mapping right out of box?

[jonathandrury]

Does anyone have insight into this? I see a similar issue.

[Pratiksha]

Check on data source if it is getting loaded in data source or not. 

[JasonW39]

I have run into this problem as well. It appears that the SCCM Service Graph Connector doesn't work like most of the others seem to. There is no Data Source by default, why you select "Specify Basic Details" and if you try to select the corresponding data source (SG-SCCM Computer Identify), you get an error saying: Data source table already already associated with 'SCCM Computer Identity' ETL Map

If you navigate to sys_data_sources, you should find that there are 2 sets of data sources related to SCCM.  One with a generic name "SG-SCCM Computer Identity" and one that contains a prefix that was specified when the SGC was initially setup. According to the documentation, the generic ones are only there to serve as a template, and do not get used in practice.

I had some success by going into each of the generic job records, and scrolling to the bottom where the Robust Transform related list is located, and deactivating the record in either the "Transforms" or "Robust Transforms" related lists.

Hope this helps!