Create a Qlik REST API connection to Rapidminer

KostasBonikosKostasBonikos Member Posts: 25 Maven
edited November 2018 in Knowledge Base

If you have a process that you have built on Rapidminer Studio and exposed as a service through Rapidminer Server, here is how you can access the outputs from that process using the Qlik REST Connector is provided by Qlik Sense.

 

Exposing a process as a service in Rapidminer Server is described well in our documentation and lies outside the scope of this article.

 

Qlik Sense apps connect to data sources through Add data and the Data load editor. Add data provides assistance with creating data associations in your data model. The Data load editor enables you to build a data model with ETL (Extract, Transform & Load) processes using the Qlik Sense data load script language. The script language enables you to perform complex transformations and create a scalable data model.

 

First, create a service in Rapidminer Server and test it so as to get the URL for it.

qlik API 1.png

In this case, the output is in JSON but it can also be in XML or other formats and there is plenty of detail regarding pagination, authentication and the Qlik side of things here:

https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/1.0/Create-REST-connection/Create-REST-connection-Sense.htm

 

Time to fire up Qlik Sense, open a new or existing Qlik Sense app and select either Add data or the Data load editor.

 

In Add data, the Select a data source step appears immediately with a list of connectors.

qlik API 2.png

 

Select REST

qlik API 3.png

 

For the Data load editor, select Create a new connection in the Data connections column to get a list of connectors.

qlik API 4.png

Select Qlik REST Connector from the list of connectors and the Create new connection (REST) dialog opens.

 

In either approach, the resulting dialogue is this or very similar to this:

 

qlik API 5.png

 

Well done reaching the data, time to build your dashboards!

 

Make sure to paste the URL from the Server and use your Server credentials to authenticate.

Leave the method as GET, name the connection, test it and click Create.

 

Make sure to click also on the Select Data button to see your data.

qlik API 6.png

 

And if you cannot see any data, pppleasemake sure to click and expand "root".

qlik API 7.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Well done getting the data! Time to work on your dashboards.

Sign In or Register to comment.