topic Re: Integration with Control-M in Qlik Replicate

Integration with Control-M

Al_gar — Mon, 16 May 2022 14:06:50 GMT

I am looking for information about integration between Qlik Replicate (also Qlik Compose) and Control-M. Or to see if there is any other way to create a status file to be able to monitor and trigger any failed task.

Re: Integration with Control-M

KellyHobson — Mon, 16 May 2022 15:31:46 GMT

Hey @Al_gar ,

We do not have documentation specific to Control-M integration, but customers can create their own programs using Qlik Enterprise Manager APIs to create, trigger and monitor tasks externally and then integrate that program with Control-M.

API documentation:

https://help.qlik.com/en-US/enterprise-manager/November2021/Content/EnterpriseManager/EnterpriseManager_APIGuide/Introduction/AEM_Intro.htm

Please note that the implementation and maintenance of external program is not in the scope of Qlik Support.

Best,

Kelly

Re: Integration with Control-M

Al_gar — Wed, 01 Jun 2022 13:59:28 GMT

Thank you Kelly. We're going to use Python SDK, but there's no information on the documentation as to what specific aem_client library to install on the client machine. Is there any Qlik EM specific AEM Python package?

Re: Integration with Control-M

Steve_Nguyen — Wed, 01 Jun 2022 16:52:35 GMT

for the QEM API :

https://help.qlik.com/en-US/enterprise-manager/May2022/Content/EnterpriseManager/EnterpriseManager_APIGuide/PythonAPI/aem_rest_api_intro.htm

Re: Integration with Control-M

Al_gar — Thu, 02 Jun 2022 13:51:14 GMT

Hi Steve,

My question was geared more to what specific Python package is needed in order to import the right aem_client module. I have already installed some packages, but when I try to test some of the included python examples I get the following error message:

"ModuleNotFoundError: No module named 'aem_client'"

We read the documentation, but we couldn't find any specifics about what Python package to install to get the necessary libraries for the aem_client.

Re: Integration with Control-M

KellyHobson — Thu, 02 Jun 2022 14:18:36 GMT

Hey @Al_gar ,

You will need to define the path to the python scripts from the QEM install in your path variable. i.e for windows C:\Program Files\Attunity\Enterprise Manager\clients\python

Example:

C:\Users\kelbla>path
PATH=D:\Python\Scripts\;D:\Python\;C:\Windows\system32;C:\Windows;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Attunity\Enterprise Manager\clients\python

Additionally, you will need to run the command window as administrator. Then try:

>>python

Python version info XXX
Type "help", "copyright", "credits" or "license" for more information.
>>> from aem_client import *

Let me know if this helps.

Best,

Kelly

Re: Integration with Control-M

Al_gar — Mon, 06 Jun 2022 19:06:25 GMT

Thanks Kelly. After having Python installed on the QEM server and adding the path variables, can I then used an external host to make the API calls to the QEM server? Is the aem_client included with the QEM installation?

Re: Integration with Control-M

Steve_Nguyen — Tue, 07 Jun 2022 14:28:41 GMT

@Al_gar

please see the API guide :

https://help.qlik.com/en-US/enterprise-manager/May2022/Content/EnterpriseManager/EnterpriseManager_APIGuide/PythonAPI/how_to.htm

see : To be able to use the Qlik Enterprise Manager Python API:

Is the aem_client included with the QEM installation? ans ,, yes, is under the :

a code sample and a readme file that describes the code are located in the <Enterprise Manager_Installation_Folder>/clients/python folder.

Re: Integration with Control-M

gdoyle — Thu, 04 Aug 2022 15:58:27 GMT

Hey @Al_gar ,

Have you had any luck with your implementation. We are needing to build a script to read from a database to see when a rebuild is complete and then trigger a task. Should be pretty straight forward but the Qlik documentation could be much more improved. Care to share anything you've learned? Also, is all the documentation meant to be done on the enterprise manager server?

Re: Integration with Control-M

lyka — Thu, 04 Aug 2022 20:39:16 GMT

Hello,

Yes it should be on the server.

Thanks

Lyka