Qlik’s Approach To Big Data Qlik2Data Robot Installation Guide

User Manual:

Open the PDF directly: View PDF PDF.
Page Count: 20

1
Installing Qlik2DataRobot on Windows 3
Configuring Qlik Sense Desktop 6
Configuring Qlik Sense Enterprise on Windows 7
Installing on Qlik Sense Desktop 9
Installing on Qlik Sense Enterprise on Windows 9
Sending data to DataRobot from Qlik Sense 10
Consuming a published DataRobot Deployment 14
Supported Request Types 17
2
•
•
•
•
•
3
4
5
6
SSEPlugin=DataRobot,localhost:50052,,20,2000
SSEPlugin=R,localhost:50051,,2000,2000;DataRobot,localhost:50052,,20,2000
7
8
9
•
•
•
Import the zip file using the QMC
10
11
12
13
14
15
•
•
•
16
LET vRows = NoOfRows('LoanStats');
SET vBatchSize = 80000; //Set the batch size required
LET vGroups = $(vRows) / $(vBatchSize);
FOR i = 0 TO $(vGroups)
TRACE BATCH $(i);
[BatchData]:
NoConcatenate
LOAD
[RecID],
[loan_amnt],
[term],
[int_rate],
[installment],
[grade],
[sub_grade],
[emp_title],
[emp_length],
[home_ownership],
[annual_inc],
[verification_status],
[issue_d],
[loan_status],
[pymnt_plan],
[purpose],
[title],
[addr_state],
[dti]
RESIDENT [LoanStats]
WHERE [RecID] > ($(i) * $(vBatchSize)) AND [RecID] <= (($(i) + 1) *
$(vBatchSize));
GetFromDataRobot:
LOAD
[RecID],
[Prediction]
EXTENSION DataRobot.ScriptEvalStr('{
"request_type":"predictapi",
"auth_config":{
"api_token":"SdcF4iwyv8ILjk9Nytl3e8EHkS45hUeB",
"endpoint":"https://customer.orm.datarobot.com",
"datarobot_key":"84e2322a-cd38-8bf3-04da-fd6f57516e21"
},
"deployment_id":"5cf9abc3432eff2c75e1644f",
"keyfield":"RecID"
}',BatchData);
Drop Table [BatchData];
Next
17
{
"request_type":"<REQUEST TYPE>",
"auth_config":{
"api_token":"<API TOKEN>",
"endpoint":"<API ENDPOINT>"
}
}
{
"request_type":"createproject",
"auth_config":{
"api_token":"<API TOKEN>",
"endpoint":"<API ENDPOINT>"
},
"project_name":"<PROJECT NAME>"
}
Parameter
Type
Required
Example
API TOKEN
String
Yes
SdcF4iwyv8ILjk9Nytl3e8EHkS45hUeB
API ENDPOINT
String (URL)
Yes
https://app.datarobot.com/api/v2
PROJECT NAME
String
Yes
Data Churn Analysis
18
{
"request_type":"predictapi",
"auth_config":{
"api_token":"<API TOKEN>",
"endpoint":"<ENDPOINT>",
"datarobot_key":"<DATAROBOT KEY>"
},
"deployment_id":"<DEPLOYMENT ID>",
"keyfield":"<KEYFIELD>",
"should_cache":<SHOULD CACHE>,
}
Parameter
Type
Required
Example
API TOKEN
String
Yes
SdcF4iwyv8ILjk9Nytl3e8EHkS45hUeB
ENDPOINT
String (URL)
Yes
https://customer.orm.datarobot.com
DATAROBOT KEY
String
Yes
84e2322a-cd38-8bf3-04da-fd6f57516e21
DEPLOYMENT ID
String
Yes
5cf9abc3432eff2c75e1644f
KEYFIELD
String
No
RowID (NOT for use in chart expressions)
SHOULD CACHE
Boolean
No
true (defaults to false, only for use in chart expressions)
19
© 2018 QlikTech International AB. All rights reserved. Qlik®, Qlik Sense®, QlikView®, QlikTech®, Qlik Cloud®, Qlik DataMarket®, Qlik Analytics Platform®, Qlik NPrinting®, Qlik
Connectors®, Qlik GeoAnalytics®, Qlik Core®, Associative Difference®, Lead with Data™, Qlik Data Catalyst™, Qlik Associative Big Data Index™ and the QlikTech logos are trademarks of
QlikTech International AB that have been registered in one or more countries. Other marks and logos mentioned herein are trademarks or registered trademarks of their respective owners.
CODE NEEDED FOR PUBLISHING

Navigation menu