Pulling Large amount of Data from COGNOS into Alteryx

[alexg1]

Has anyone had any success directly connecting to a COGNOS table or accessing report results in the XML format? For most reports I run, a flat Excel is sufficient. However, the number of rows written to the most important one regularly exceeds the maximum number of rows written by Excel, requiring me to break it up into multiple files. My thought would be to try to access it directly somehow, but perhaps there is a better way? Any assistance is appreciated!

[IraWatt]

Hey @alexg1,

I haven't used COGNOS but the out of the box XML Parse tool is pretty great for ingesting XML.

Would you be looking to use the COGNOS API to download the data into Alteryx?

[apathetichell]

Use the Cognos API in the download tool and pull in the data directly. I haven't done it. https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=apis-rest-api

The

 "x-xsrf-token: ${xsrf}" is the key party so try the syntax in postman first and then port over. Talk to your backend Cognos team if you need help.