This is an example Qlik connector for ArangoDB.
The Qlik connector can be installed as a Foxx service using the ArangoDB web interface or the Foxx CLI:
$ npm install --global foxx-cli
$ foxx install -u root -P -H http://localhost:8529 -D _system /qlik \
https://github.com/arangodb-foxx/qlik-connector/archive/master.zip
# or without installing foxx-cli:
$ npx foxx-cli install -u root -P -H http://localhost:8529 -D _system /qlik \
https://github.com/arangodb-foxx/qlik-connector/archive/master.zip
Before you can use the ArangoDB connector in Qlik you need to configure the service using the web interface or the Foxx CLI.
To configure the service in the ArangoDB web interface, open the service details and then navigate to the Settings tab in the top bar.
-
collections: list of names of collections that will be exposed to Qlik, as a comma-separated list, e.g.
payments,timeouts
will expose the collectionspayments
andtimeouts
in the database the service was installed. -
username and password: credentials that will be used by Qlik to authenticate against this service.
Note: These credentials will only be used by Qlik and should not match the ArangoDB user credentials used to access ArangoDB itself.
To add the connector as a data source in Qlik, open the Add Data dialog and select the REST connector.
Set URL to the URL of the service followed by the name of the collection
you wish to import, e.g. http://localhost:8529/_db/_system/qlik/timeouts
.
Set Authentication Schema to Basic
and use the credentials from the
service configuration.
Set Pagination to Offset
with the following options:
- 'Start' parameter name:
start
- 'Start' initial value:
0
- 'Count' parameter name:
count
- 'Count' initial value:
200
- 'Total records' path:
meta/totalCount
- Data indicator path:
data
This code is licensed under the Apache License, Version 2.0.