Unable to Query CAS Table from SAS Intelligent Decisioning – DS2 Connection Refused

[FadiHosni]

Hi everyone,

I'm trying to connect to a CAS table from inside SAS Intelligent Decisioning, using a Data Query node to retrieve data from a table that is already loaded into memory.

I've also attempted to use a DS2 code node to make the connection, but I keep getting connection errors. Below is a screenshot of the error log:

It seems like the DS2 d2http package is failing to establish a connection with the Micro Analytic Score endpoint.

Has anyone successfully queried a CAS table from within Intelligent Decisioning using DS2 or the Data Query node? Any suggestions on how to properly access in-memory CAS data from within a decision flow?

Thanks in advance!

[DeanTaplin]

The DS2 SQLSTMT package is not supported in CAS which explains the error seen when using a Data Query node. I assume you're using the sqlstmt in the DS2 Code Node too?

[FadiHosni]

Thank you for the clarification! That means I can't use the Data Query node to retrieve tables from CAS, which I was hoping for. As you predicted, I did use the SQLSTMT in the DS2 Code Node and encountered the same error.

Could you please guide me on what should be written in the DS2 Code Node to correctly access the values from the loaded CAS tables?

Thanks again for your help!

[DeanTaplin · Accepted solution]

Take a look at this post and see if it helps.