topic How to make Control-m on mainframe trigger QlikSense CLI to run a data injection job on QlikSense in Integration, Extension & APIs

How to make Control-m on mainframe trigger QlikSense CLI to run a data injection job on QlikSense

aniketgoel — Sat, 16 Nov 2024 01:12:45 GMT

Control-M job needs to be extended, at the end of the job, it needs to write a message to QlikSense Command Line Interface(CLI) tool.

The QlikSense CLI tool can then initiate the scheduled data ingestion requests.

If anyone has tried implementing this it would be helpful to know the steps to follow and code line to include in extended Control-M job.

Re: How to make Control-m on mainframe trigger QlikSense CLI to run a data injection job on QlikSens

Brett_Bleess — Thu, 29 Oct 2020 14:45:03 GMT

About the best I can offer is a point to the API documentation where you will find the APIs for the calls:

https://help.qlik.com/en-US/sense-developer/September2020/APIs/EngineAPI/index.html

https://help.qlik.com/en-US/sense-developer/September2020/APIs/EngineAPI/services-Doc-DoReload.html

https://help.qlik.com/en-US/sense-developer/September2020/APIs/EngineAPI/services-Doc-DoReloadEx.html

There are likely other APIs that are going to be needed to create a full setup for things. I am not aware of anyone having written anything such as was done in the QlikView side regarding an exe file etc., but maybe someone else will reply, sorry I do not have something better.

Regards,
Brett

Re: How to make Control-m on mainframe trigger QlikSense CLI to run a data injection job on QlikSense

Marc — Fri, 06 Nov 2020 23:10:54 GMT

When you say "QlikSense Command Line Interface(CLI) tool" are you referring to the PowerShell Module Qlik-CLI? https://github.com/ahaydon/Qlik-Cli-Windows/wiki

If so, you can write your PowerShell script to connect to the QRS apis and perform the necessary tasks and validate that it is working correctly.

Then you can use the following article to schedule it in Control-M

https://communities.bmc.com/docs/DOC-64328