Starting with the SAS Viya 3.5 release, you can now setup connections to an SAS Event Stream Processing (ESP) Project. ESP enables you to capture and analyze streaming data from sensors, IoT devices, and other data sources. In this article, I will review the process for connecting to an ESP project and loading a snapshot of its data to memory, so you can use the data in SAS Viya.
You can create a connection to an ESP project in either SAS Data Explorer or the SAS Environment Manager – Data tab. In this article, I will walk through an example of doing this in SAS Data Explorer; however, the steps are similar if you prefer to use the SAS Environment Manager – Data tab.
To create a data connection in SAS Data Explorer, select the Data Sources tab and click .
Select any image to see a larger version.
Mobile users: To view the images, select the "Full" version at the bottom of the page.
This opens the Connection Settings dialog.
You will need to complete the following basic connection settings information:
Below is the basic connection settings information for my example ESP project connection.
You will need to ask your ESP system administrator for the following information that is required on the Settings and Advanced tabs to connect to the desired ESP server and project. For more information about connection options for an ESP server, refer to the documentation.
On the Settings tab, specify the following:
Below is the Settings tab information for my example ESP project connection.
On the Advanced tab, specify the following:
Below is the Advanced tab information for my example ESP project connection.
Now that I have added all the necessary connection information, I select Test Connection to confirm the connection settings.
After successful confirmation, I select Save to save the connection information for my example ESP project. I then navigate to view the newly created connection.
The connection created is a read-only CAS library which means the physical tables cannot be loaded into memory in this CAS library.
Note: The Actions drop-down is grayed out when a table is selected in this data source.
You must use the "Add to Import" feature to load any of the tables you want to work with to a writeable CAS library. I discuss this process in the next section.
Using the "Add to Import" feature on the defined ESP project connection gives you have a snapshot of the data that was streamed through that window. To import one of the tables from your defined ESP project connection:
Note: I could repeat the above steps if I wanted to work with snapshots of my other ESP project tables.
After the successful import, I can now navigate to my imported table and view its Sample Data.
Now I can run a data profile or perform other tasks with this snapshot of streamed data by selecting the Actions drop-down (or right-click) the in-memory table.
In conclusion, you can set up a read-only CAS library connection to your ESP projects and then use the "Add to Import" feature to import a snapshot of the ESP project data for use in Viya. For more information, please refer to the documentation:
Special thanks to my colleague, Uttam Kumar, for providing the ESP project information needed to setup the connection I used as an example in this article.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning and boost your career prospects.