Calling Qliksense Repository API from Apache Drill via sql

Abstract I’ll show how to connect to Qliksense Repository API via sql using Apache Drill. In this example Qliksense engine service runs at https://qlik.redaelli.org:4242/ Download Download and unzip Apache Drill from https://drill.apache.org/download/ Configure Create or edit the file conf/storage-plugins-override.conf "storage": { "qliksense" : { "type" : "http", "cacheResults" : true, "connections" : { "p4242" : { "url" : "http://nginx.redaelli.org/qlik/", "method" : "GET", "authType" : "none", "userName" : null, "password" : null, "postBody" : null, "params" : ["filter"], "dataPath" : null, "requireTail" : true, "inputType" : "json", "xmlDataLevel" : 1 } }, "proxyType" : "direct", "enabled" : true } } At the moment Apache drill cannot query external rest services with client certificates DRILL-8052 and so we need a reverse proxy like Nginx....

February 23, 2022 · 2 min · 271 words · Matteo Redaelli

Calling Talend Cloud Rest API from Apache Drill via sql

Abstract I’ll show how to connect to Talend Cloud API via sql using Apache Drill. Download Download Apache Drill from https://drill.apache.org/download/ Configure Create or edit the file conf/storage-plugins-override.conf "storage": { "talendcloud" : { "type" : "http", "cacheResults" : true, "connections" : { "get" : { "url" : "https://api.eu.cloud.talend.com", "method" : "GET", "headers" : { "Authorization" : "Bearer MYSECRETKEY" }, "authType" : "none", "userName" : null, "password" : null, "postBody" : null, "params" : ["query"], "dataPath" : null, "requireTail" : true, "inputType" : "json", "xmlDataLevel" : 1 } }, "proxyType" : "direct", "enabled" : true } } Start Drill Run drill with...

February 4, 2022 · 2 min · 292 words · Matteo Redaelli

Building websites for high traffic with REST APIs, AngularJs and Jekyll

If you have few hw resources and/or you expect high traffic on your website, here are some quick suggestions (also taken from the article Meet the Obama campaign’s $250 million fundraising platform): Expose your business logic with REST services Use a javascript framework like angularJS for calling your rest APIs and building a dynamic site Build a (not so) static website using Jekyll or similars and put your static files on S3 (if you are using Amazon AWS) use a CDN A sample website (not hosted at AWS but home based using a poor raspberryPI2) is http://paroleonline....

May 5, 2016 · 1 min · 97 words · Matteo Redaelli

Adding an application (angularjs+rest api) inside a Wordpress site

If you need to integrate an application written with AngularJS and Rest API services in your wordpress website, just create an empy page and edit it in “text” mode with something like```

April 26, 2016 · 1 min · 32 words · Matteo Redaelli