Calling Cognos from Alteryx

Hey everyone!

Has anyone been able to call a Cognos report from an Alteryx workflow? I have a workflow that populates a table on a SQL Server database. After the table is populated, I would like the Alteryx workflow to trigger the Cognos report to run. Any thoughts?

Thank you!!

Help

Accepted answers

cplewis90

Hello @JenniferO,

I am not familiar with connecting Alteryx to Cognos, but am familiar with Cognos. There may be a way to leverage the run command tool and create a script that kicks off the Cognos report, but may require some coding to create the script.

My other thoughts on this, can you re-create the Cognos report in Alteryx (either using the Insight tool or reporting tools) and send it out via the email tool? This would be a bit more work on the front end, but would then be fully automated.

All comments

cplewis90

Hello @JenniferO,

JenniferO

Hi @cplewis90 ,

Using the run command tool with the Cognos URL worked perfectly. We were even able to pass data from the Alteryx workflow as parameters for the Cognos report. Very cool!

Thank you!!

tochy

Hi,

I am a newbie and I have no idea of what I am doing yet!

I want download invoice files which are in pdf from cognos. Usually, on the home screen, we insert the vendor name, date and run the report. This generates a table listing the vendor invoices that match the selection criteria. This table, among other things, also contain a link (FileNet URL column) which we click to view or download the invoice. I want to use alteryx to download these invoices (pdf) en-mass without having to manually do it one by one. I have attached a screenshot of the table.

Thanks for your help! Captured file.JPG

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335