Search code examples
restneo4jqliksense

Qliksense rest connection to connect neo4j sandbox

I am trying to connect to NEO4j data base using qliksense through REST API connection but I am unable to understand how to get the API end point and pass the cypher query. Could anybody please guide me or share the poc if you have.

I am trying to load node data created in the neo4j sandbox by firing cypher query.

Solution

  • In order to pull your Neo4j data into Qlik Sense, whether cloud or on-prem, you will need to use the Neo4j Connector for BI ODBC driver in order to get that data. The ODBC driver is what allows Qlik to pull that Neo4j data without a native data connector and without any RESTful option in your case.

    If you use Qlik Sense Enterprise on Windows ("on-prem") then you will need to install and configure this driver on all servers where the Qlik Engine is installed.

    If you use Qlik Sense Enterprise SaaS ("Cloud"), then you will need to install and use this Neo4j driver on your org's own Windows server, whether that's in cloud/VPC or on-prem. That server will ultimately need to have Qlik DataTransfer installed on it, as well, as that is the tool that is used to get the data from the ODBC driver and then up to your Qlik cloud tenant.

    The setup is easy though:

    1. Use this link to choose and download the Neo4j ODBC driver version for your Windows server (server where Qlik Sense Engine Service is installed / where Qlik DataTransfer is or will be installed).
    2. Unzip the downloaded ZIP file and then run the installer for the correct bit version, usually 64-bit.
    3. Once that is installed, open the ODBC Data Sources (64) program on your server and then add a new System DSN source (unless there's already a newly-created Simba Neo4j connection there, in that case just double click on that).
    4. The Host parameter should be your Bolt URL without the protocol or port (for example, just 0.00.000.000). you hopefully know your Port number, that's 7687 by default. You can leave the Database parameter blank if you want to. Then put in your credentials and click the Test... button. If that works, click the OK button and then close the ODBC program.
    5. If you are using Qlik Sense on-prem, create a new ODBC connection. If you're on Qlik SaaS then open up the Qlik DataTransfer GUI, go to the Connection details tab, and then click the green Add button.
    6. Choose the ODBC option, choose System DSN, then select your new Neo4j option. Then click the green Create button.

    Screenshot of Qlik DataTransfer connection create screen

    1. Now go to the Data connections tab and select the green Add button. Put in your desired options and then click the Next button.

    Screenshot of Qlik DataTransfer data connection create screen

    1. Choose your new ODBC connection. Then, select the database from the dropdown. From the Owner dropdown, choose either Node or Relationship. Then put a checkmark next to all of the tables you want based on the selected type. Finally, click the green Next button.

    Screenshot of Qlik DataTransfer table selection screen

    1. Optionally, choose the app(s) that you want to be automatically reloaded whenever this Neo4j data is uploaded to Qlik Cloud.
    2. When you're ready, go ahead and select your new data connection and then click the Upload button.

    Screenshot of Qlik DataTransfer data upload screen

    1. You should hopefully get a successful result!

    Screenshot of Qlik DataTransfer successful data upload message

    1. Go to your Qlik tenant and find your Neo4j data, uploaded as QVD files:

    Screenshot of Qlik SaaS data files