Connecting to IBM InfoSphere Information Governance Catalog

[jamielaird]

Does anyone have any experience connecting Alteryx to IBM InfoSphere Information Governance Catalog? This is something a potential client has asked about so I don't have any prior knowledge of the system or access for testing.

Here's what I have been able to work out for myself:

• IGC is part of the InfoSphere platform which doesn’t have a native connector to Alteryx.
• It seems to be possible to export CSVs which would obviously work as data sources but require manual work on their side.
• The recommended approach for getting data out of InfoSphere as a feed is using the InfoSphere Metadata Asset Manager which generates XML files.
• Digging deeper these are a special type of XML called XMI. An example of this file format is here.

I'm still getting my head around what exactly an XMI is and how this data would be utilised within Alteryx, but if anyone has any experience and can give me some pointers that would be very helpful.

Thanks all!

Jamie

[BrandonB · Accepted solution]

Hi @jamielaird 

It looks like it has a REST API available that can output JSON: https://www-01.ibm.com/support/docview.wss?uid=swg27047059 

Sample API Calls: https://www-01.ibm.com/support/docview.wss?uid=swg27047059&aid=1 

You can use these endpoints in conjunction with the Download tool to pull whatever data they need.

-Brandon

[jamielaird]

Wunderbar! Thank you @BrandonB 

[reenz]

Hi Jamie, could you please provide some information regarding if you were able to connect to IBM InfoSphere Governance Catalog using Alteryx? I am trying to work with the lineage and only export format I could find in IBM InfoSphere is CSV.

Thanks,

Blyzz