How do I connect to Xcalar from QlikSense?

[dhart]

I would like to use Xcalar to create dashboards in QlikSense, however I do not know how to integrate QlikSense with Xcalar. Can you please provide me a path forward?

[mjoshi]

Xcalar SSL Setup

If you would like to use SSL to connect to Xcalar, then please follow the SSL and PEM setup instructions as explained in this article. You will need to contact a Xcalar admin to set this up.

✅ Tableau workbooks from Xcalar

Once this is setup, you can proceed to the next step.

QlikSense Setup

Copy this PEM file to your windows server (or desktop if you are using Qlik Desktop edition). In Qlik Sence click the "Create New Connection" button (this can be done from many places, for example from Script Editor).

1. In the "Data Sources" list choose "Apache Spark (beta)"
2. Keep serever type as "Spark Thrift Server",
3. Fill out Host Name, for example "myserver.company.com",
4. Keep port as 10000,
5. Keep Database blank
6. Keep Authentication mechanism as "User Name And Password" and provide User name and Password
7. In SSL Options:
8. Check "Enable SSL"
9. Enter the path to where you saved PEM file in "Full path to Trusted Certificate" text box
10. Check "Allow Common Name Host Name Mismatch"
11. Leave other boxes unchecked
12. Keep Thrift selection as "SASL",
13. Keep default selections in other boxes
14. Select Name for your connection

Testing and Saving

1. Click "Test Connection"
2. If successful - click "Save", otherwise troubleshoot