Qlik’s Approach To Big Data Qlik2Data Robot Installation Guide
User Manual:
Open the PDF directly: View PDF
.
Page Count: 20
| Download | |
| Open PDF In Browser | View PDF |
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
1
•
•
•
•
•
2
3
4
5
SSEPlugin=DataRobot,localhost:50052,,20,2000
SSEPlugin=R,localhost:50051,,2000,2000;DataRobot,localhost:50052,,20,2000
6
7
8
•
•
•
Import the zip file using the QMC
9
10
11
12
13
14
•
•
•
15
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
16
{
"request_type":"",
"auth_config":{
"api_token":"",
"endpoint":""
}
}
{
"request_type":"createproject",
"auth_config":{
"api_token":"",
"endpoint":""
},
"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
17
{
"request_type":"predictapi",
"auth_config":{
"api_token":"",
"endpoint":"",
"datarobot_key":""
},
"deployment_id":"",
"keyfield":"",
"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)
18
© 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.19
CODE NEEDED FOR PUBLISHING
Source Exif Data:
File Type : PDF File Type Extension : pdf MIME Type : application/pdf PDF Version : 1.7 Linearized : No Page Count : 20 Language : en-US Tagged PDF : Yes XMP Toolkit : 3.1-701 Producer : Microsoft® Word 2016 Title : Qlik’s approach to Big Data Creator : Steven Pressland Description : Get more value by.empowering more users Creator Tool : Microsoft® Word 2016 Create Date : 2019:01:25 12:59:53+00:00 Modify Date : 2019:01:25 12:59:53+00:00 Document ID : uuid:66101336-48E2-4116-A501-67EAAB363F5C Instance ID : uuid:66101336-48E2-4116-A501-67EAAB363F5C Author : Steven Pressland Subject : Get more value by.empowering more usersEXIF Metadata provided by EXIF.tools