https://community.qlik.com/t5/Official-Support-Articles/Getting-SaaSsy-with-DataRobot/ta-p/1976989 <P><SPAN><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="DataRobotLogo.png" style="width: 200px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/88285iA784CDE1B2210A1C/image-size/small?v=v2&amp;px=200" role="button" title="DataRobotLogo.png" alt="DataRobotLogo.png" /></span></SPAN></SPAN></P> <P>&nbsp;</P> <P><SPAN><SPAN><SPAN><SPAN>With Qlik Sense Enterprise on Windows you needed to utilize a Server Side Extension to reach your data science platforms. But with <STRONG><FONT color="#339966">Qlik Cloud</FONT></STRONG> you have a myriad of built-in advanced analytics/data science connectors at your fingertips.&nbsp;</SPAN></SPAN></SPAN></SPAN><SPAN>I hope that you will forgive me for the cheesy pun title, but it was hard to resist. As this document is about how you can call your DataRobot deployments from your Qlik Cloud SaaS tenant applications.&nbsp;</SPAN></P> <P><SPAN><SPAN><SPAN><SPAN>In this document, you will learn how to:&nbsp;</SPAN></SPAN></SPAN></SPAN><SPAN><SPAN><SPAN><SPAN><SPAN><SPAN><SPAN>&nbsp;Create an Analytics Connector to make predictions via DataRobot, C</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN><SPAN><SPAN><SPAN><SPAN><SPAN><SPAN><SPAN><SPAN><SPAN><SPAN>onfigure the connection and Call it to make your predictions.&nbsp;</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P> <P>&nbsp;</P> <H3><FONT color="#339966"><STRONG>Creating a Connection</STRONG></FONT></H3> <P>&nbsp;</P> <P>The DataRobot connector will be found under the Analytics Sources when you choose to add a connection. Simply click it. Seriously it's that easy and probably didn't even need its own section. But Creating, Configuring and Calling seemed like a trifecta of headers so I went with it.&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="QlikSenseAnalyticsConnectorsChooseDataRobot.jpg" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/88289i6BAF13CB9EB267F1/image-size/large?v=v2&amp;px=999" role="button" title="QlikSenseAnalyticsConnectorsChooseDataRobot.jpg" alt="QlikSenseAnalyticsConnectorsChooseDataRobot.jpg" /></span></P> <H3>&nbsp;</H3> <H3><FONT color="#339966"><STRONG>Configuring your Connection</STRONG></FONT></H3> <P>&nbsp;</P> <P>Your first configuration option will be regarding the type of predictions you wish to make. Which of course are based on the deployment you are calling within DataRobot. The default is Predictions, but you can also choose Timeseries Predictions if that is the model you are calling from DataRobot.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="SelectDataRobotPredictionsOrTimeSeries.png" style="width: 246px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/88291i6FC437B72853CF8C/image-size/large?v=v2&amp;px=999" role="button" title="SelectDataRobotPredictionsOrTimeSeries.png" alt="SelectDataRobotPredictionsOrTimeSeries.png" /></span></P> <P>&nbsp;</P> <P>The next several parameters involve things that are not simple drop-down selections like that. The Deployment ID, API Key and DataRobot Key are all really weird, unique number strings. The kind of things you can't usually memorize or rattle off the top of your head. The Host is a URL string that is unique to your deployment environment within the DataRobot universe. But don't panic they can be found pretty easily within your DataRobot SaaS environment. Since go to the "<STRONG>Deployments</STRONG>", choose the specific "<STRONG>Deployment</STRONG>" you wish to call, Choose "<STRONG>Predictions</STRONG>", "<STRONG>Prediction API</STRONG>" and then choose "<STRONG>Real-Time</STRONG>" as the <STRONG>Prediction Type</STRONG>.&nbsp;</P> <P>As the following screenshot depicts, DataRobot will hand you all of that information.</P> <P>&nbsp;</P> <P class="lia-indent-padding-left-30px"><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="DeploymentPredictionDetails.png" style="width: 839px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/88292i6B911BE3E512670F/image-size/large?v=v2&amp;px=999" role="button" title="DeploymentPredictionDetails.png" alt="DeploymentPredictionDetails.png" /></span></P> <P>&nbsp;</P> <P>Simply copy/paste the information provided by DataRobot to the "<STRONG>Create new connection (DataRobot)</STRONG>" dialog.&nbsp;</P> <BLOCKQUOTE>Notice that since the connection is capturing the "Deployment ID," that your DataRobot connections are specific to individual deployments. If a deployment is removed and a model is re-deployed, you will need to update your DataRobot connection within Qlik Cloud.&nbsp;</BLOCKQUOTE> <P>&nbsp;</P> <P class="lia-indent-padding-left-30px"><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="CreateNewConnection1.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/88290i222F91FEAB6FECFF/image-size/large?v=v2&amp;px=999" role="button" title="CreateNewConnection1.png" alt="CreateNewConnection1.png" /></span></P> <P>&nbsp;</P> <P>There are a few more parameters that you will need to populate. The "<STRONG>Timestamp Format</STRONG>" will be auto-filled for you, as will the "<STRONG>Response Table.</STRONG>" If you are only calling a single DataRobot deployment within your application a name like "<STRONG>DataRobot Predictions</STRONG>" is fine. However, if you want to be super specific, or you will have multiple DataRobot deployments being called, you can rename it as desired.&nbsp;</P> <P>Perhaps most importantly, is the <STRONG>Association</STRONG> section. As you know, tables within Qlik Sense are associated. So we need to provide the connector with the name of the KEY field/<STRONG>Association Field</STRONG> that is in our Data Model and check the box for "<STRONG>Send Association Field</STRONG>" so that when the data is returned (see below) it can be associated.&nbsp;</P> <P>Like any of the data connectors within Qlik Sense, you need to provide a <STRONG>Name</STRONG> for your DataRobot connection. Then you are ready to Test the connection by pressing "<STRONG>Test connection</STRONG>" and then press "<STRONG>Create</STRONG>." (The following screenshot was taken after an Edit, so it has "<STRONG>Save</STRONG>" instead of "Create.")</P> <P>&nbsp;</P> <P class="lia-indent-padding-left-30px"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="CreateNewConnection2.png" style="width: 940px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/88293iF27034D600C8A26E/image-size/large?v=v2&amp;px=999" role="button" title="CreateNewConnection2.png" alt="CreateNewConnection2.png" /></span></P> <H3>&nbsp;</H3> <H3><FONT color="#339966"><STRONG>Calling your Connection</STRONG></FONT></H3> <P>&nbsp;</P> <P>Hurray! You have a new connection ready to go. Just like all data connection types, the DataRobot connection you just created needs to be called to retrieve data. Simply find your specific connection and click the "Select data" option.&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="CallDataRobotConnection.png" style="width: 200px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/88295i57E94787CD71749F/image-size/small?v=v2&amp;px=200" role="button" title="CallDataRobotConnection.png" alt="CallDataRobotConnection.png" /></span></P> <P>&nbsp;</P> <P><SPAN>Next you will be prompted for a really important piece of information, the name of the table that contains the data you need to have the predictions executed for. If you are a Qlikkie then you are well aware of the concept of a "</SPAN><STRONG style="font-family: inherit;">Resident Table.</STRONG><SPAN>" If you aren't a Qlikkie, this is simply the name of the table that is already resident in memory.&nbsp;</SPAN><SPAN>Or specifically, will be by the tame we call this DataRobot connection to have predications executed. </SPAN></P> <P><SPAN>It's probably helpful at this point to back up a second and talk about the specific data being used for this example. It is a healthcare use case where we are calling DataRobot to make predictions about the likelihood a patient will be re-admitted to the hospital once they have been discharged. In this case, we have a table named <FONT face="courier new,courier"><STRONG>DiabetesData</STRONG></FONT>&nbsp;that contains 50 different health variables. We used the Auto-Pilot feature in DataRobot to train many different models. Chose the "winner" and deployed it. Now we are pulling the most current information for a given set of patients and want to see what the readmission prediction is.</SPAN></P> <P>&nbsp;</P> <P><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="DiabetesData.png" style="width: 300px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/88298iC5BDF56F9BE9C845/image-size/large?v=v2&amp;px=999" role="button" title="DiabetesData.png" alt="DiabetesData.png" /></span></SPAN></P> <P>&nbsp;</P> <P>Regardless of whether we have populated our <FONT face="courier new,courier">DiabetesData</FONT> table with all patients currently in our hospital(s) and running this is a batch, or whether we are using an On-Demand Application Generation or Dynamic View setup, the <FONT face="courier new,courier"><STRONG>DiabetesData</STRONG> </FONT>table is the "<STRONG>Resident Table</STRONG>" we wish to pass to our DataRobot deployment so we need to enter that name. Then you can simply check the box for "<STRONG>DataRobot Predictions</STRONG>" (name given in the Configuration of the connection.) Lastly, press the "<STRONG>Insert Script</STRONG>" button.&nbsp;</P> <P>&nbsp;</P> <P class="lia-indent-padding-left-30px"><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="SelectFromDeployment.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/88296iEA189AD85D71692A/image-size/large?v=v2&amp;px=999" role="button" title="SelectFromDeployment.png" alt="SelectFromDeployment.png" /></span></P> <P>&nbsp;</P> <P>Qlik Sense will then insert a simple ScriptEval call into your load script for you.&nbsp;</P> <P>&nbsp;</P> <P class="lia-indent-padding-left-30px"><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="ScriptEvalPredictions.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/88300i591B50B1EC2369C4/image-size/large?v=v2&amp;px=999" role="button" title="ScriptEvalPredictions.png" alt="ScriptEvalPredictions.png" /></span></P> <P>&nbsp;</P> <P>Now anytime the Load Script is executed, your DataRobot predictions will be available via the data model. Notice in the image below that our <FONT face="courier new,courier"><STRONG>DiabetesData</STRONG> </FONT>and <STRONG>DataRobot Predictions</STRONG> tables are associated based on that <FONT face="courier new,courier">Master_Pastient_ID</FONT> field that we identified in the configuration. We can now display our patient data and our predictions anyway that we wish in our application. With the knowledge that the predictions have been made based on the most recent information, we have in the application. If you are using an On-Demand Application Generation (ODAG) or Dynamic View strategy, it will be based on the live values read at the time and as frequently as the end user requests it.&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="DataModelViewerPredictons.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/88304iC913582EEB6690C8/image-size/medium?v=v2&amp;px=400" role="button" title="DataModelViewerPredictons.png" alt="DataModelViewerPredictons.png" /></span></P> <H3>Related Content</H3> <P>DataRobot via Qlik Application Automation -&nbsp;<A href="https://community.qlik.com/t5/Knowledge/DataRobot-Predictions-from-Either-Path-You-Choose/ta-p/1978270" target="_blank">https://community.qlik.com/t5/Knowledge/DataRobot-Predictions-from-Either-Path-You-Choose/ta-p/1978270</A></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 12 Oct 2022 14:33:34 GMT Dalton_Ruer 2022-10-12T14:33:34Z https://community.qlik.com/t5/Official-Support-Articles/Getting-SaaSsy-with-DataRobot/ta-p/1976989 <P><SPAN>In this document, you will learn how to:&nbsp;</SPAN><SPAN>&nbsp;Create an Analytics Connector to make predictions via DataRobot, C</SPAN><SPAN>onfigure the connection and Call it to make your predictions within your Qlik Cloud environment(s.) Your predictions will be based on the most recently available data in your application, and if your code is being executed via On-Demand Application Generation or Dynamic Views, the data will be from near real time queries based on the end users selections and frequency.&nbsp;</SPAN></P> Wed, 12 Oct 2022 14:33:34 GMT https://community.qlik.com/t5/Official-Support-Articles/Getting-SaaSsy-with-DataRobot/ta-p/1976989 Dalton_Ruer 2022-10-12T14:33:34Z