Qlik Integration with UiPath

Help Marketplace
, , , , ,
1

Downloaded Qlik Sense Workflow Pack package from Marketplace
Since this package was not compatible with UiPath Studio, we had to change the Framework Compatibility from Windows to Windows - Legacy (with a warning that this framework projects with these frameworks will be phased out in near future)

we are getting connection timed out error 500. Error Statement is as follows –
Open Application: Connection failed after 4 attempts. Error message: GeneralCommunicationException with communication error WebSocketConnectionNotAccepted and http error code 500

We need sample workflow to get clarity on how Qlik is integrated with UiPath

Also, we need to know the procedure for integrating Qlik Connector with UiPath Orchestrator.

2

@Tanvi_Bhosale_OL

Welcome to the community

Can you please tell what youa re trying to acheive…you want to run qlik from
UiPath or UiPath from qlik?

Cheers

3

Hi Anil, We want to design a bot that can share weekly queue transaction / process job count with Qlik

4

@Tanvi_Bhosale_OL

I believe as per requirement you need toc onnect from qlik to UiPath and do schedules there

the data from UiPath can flow via api…above is the connection details

cheers

5

Hi Anil,

thanks for sharing the link. I have gone through the content.
Our purpose is to help specific Qlik Users get to know the performance / analytics / transaction count of processed transaction of UiPath bots belonging to their Business Units.

We do not want them to start / stop UiPath bots through Qlik.

Let me rephrase -
How can we get UiPath data (related to transaction count / job count) accessible to specific Qlik Users…

Thank you!

6

@Tanvi_Bhosale_OL

Integrating Qlik Sense with UiPath can be quite complex, especially when working with third-party packages or custom APIs. Below is a high-level overview of how to integrate Qlik Connector with UiPath, along with troubleshooting tips and a basic sample workflow.

Integration Steps

  1. Installation and Configuration:

    • Ensure that the Qlik Sense server is properly set up and accessible from the machine running UiPath.
    • Verify that the necessary API keys and connection endpoints are configured and available.

  2. Setting Up the Qlik Connector in UiPath:

    • Download the Qlik Sense Connector from the UiPath Marketplace.
    • Install the connector according to the provided instructions. If the package is not compatible with the current version of UiPath Studio, switch back to the legacy framework as you have done.

  3. Creating a Sample Workflow:
    Below is a simple example workflow for connecting Qlik Sense and triggering a reload task:

    • Publish a reload task: You might want to publish a task that triggers a Qlik Sense app reload or retrieves data from Qlik.

    Sample Workflow Steps:

    1. Assign Variables:

      qlikServerUrl = "https://your-qlik-server-url"
credentials = "Your_Credentials" // Ensure that this is properly encoded
appId = "Your_App_ID"

    2. Open Application:

      • Use the Open Application activity provided by the Qlik Sense connector.
      • Set the Server URL and Authentication type accordingly.

    3. Check Connection:

      • If you’re getting a WebSocketConnectionNotAccepted error, ensure that:
        • Your Qlik server is running and accessible.
        • The WebSocket protocol is enabled in the Qlik Sense environment.

    4. Trigger Reload Task (If applicable):

      • Optionally, use the Execute Qlik Task activity to run a specific data reload or job in Qlik.

    5. Handling Errors:

      • Implement error handling using Try-Catch activities to log the errors encountered during communication.

  4. Connecting to Orchestrator:

    • Publish your workflow to UiPath Orchestrator.
    • In Orchestrator, create a trigger or schedule that allows the process to run at specified times or events.
    • Ensure that the Robot executing the Qlik workflow has the necessary permissions to access both UiPath and Qlik environments.

Troubleshooting Connection Issues

If you’re getting a 500 error or connection timeout, consider the following:

  1. Network Accessibility:

    • Check if the machine running UiPath can reach the Qlik Sense server. You might need to adjust firewall settings or VPN connections.

  2. Configuration:

    • Ensure that the Qlik Sense APIs are enabled and correctly configured. The Qlik management console should show that the necessary services are running.

  3. WebSocket Configuration:

    • Ensure that the WebSocket protocol is properly configured on the Qlik Sense server, as this could cause the connection issues.

  4. Logs and Monitoring:

    • Check the logs on both UiPath and Qlik Sense for detailed error descriptions that can guide you in troubleshooting the connection failure more effectively.

Example Resources

Here are some sample resources that might help in better understanding the integration:

  • Qlik Sense API documentation: Qlik Developer
  • UiPath documentation: UiPath Documentation
  • Community forums for Qlik and UiPath – often helpful for troubleshooting and shared solutions.

By following these steps and considering the troubleshooting tips, you should be able to establish a functional workflow connecting Qlik Sense with UiPath.

7

@Tanvi_Bhosale_OL

the steps given are to connect qlik to UiPath…once connected…you can use get jobs, get queue items apis to get the required details as well

the example shows start job but can be used for other apis as well

for available apis check swagger <OrchetsratorURL>/swagger/index.html

cheers