I'm trying to build a Decision Flow in SAS Intelligent Decisioning on SAS Viya 3.5 but i stumble on a key feature that I can't get to work.
To simplify things lets take a basic example: Input to the decision flow is a customer ID, in the flow I need to look up customer information from a table in our internal database. Using that customer information I will do a bunch of cool stuff but first I need to solve how to do the look up.
According to some examples the Data Query (SQL Code) node is the tool to use for this and i've written this simple SQL lookup that should collect the customers status_code and age from the customerInformation table for the specific ID that is inputted to the node:
Select
Status_code as {:Status_code :string:10},
Age as {:Age:decimal},
ID as {:ID:decimal}
from casuser.CustomerInformation where ID = {?:ID:decimal}
However, when I try to run the flow (or validate just the SQL code) I get the following error:
Some information that i've found on the web suggest that some settings need to be configured for the SAS Micro Analytics Service in order to run a Decision Flow containing SQL code, see Configuring Support for SQL Query Files which in turn points me att DS2 configurations that hints at a connection string for FedSQL connections to different databases and now i'm totally lost 🤣 All I want to do is to run a simple sql towards a SAS table in my viya database.
The first question is, is the SQL code the correct approach to enrich the input data in a decision flow with information from a table in the database?
If so, am I doing something wrong or do our environment need additional configuration? If so, what configurations are needed?
... View more