|
Data Management on SingleStore on the SAS® Viya® Platform
Introducing a true database management system into Viya opens the door to several new possibilities including easily managing data change. SingleStore’s UPSERT capability quickly and easily propagates source data change to the database that CAS reads directly. In this course, we continuously ingest data files that are dropped in real-time in a cloud object storage location (ADLS), load/update a SingleStore table accordingly and see if SAS Visual Analytics can capture those updates seamlessly. Learn How To Run pipelines in SingleStore to capture table updates from newly landed data files on ADLS2 cloud object storage.Use SingleStore’s upsert capability to efficiently modify SingelStore tables that CAS reads for Visual Analytics reports and analyses.Demonstrate Visual Analytics’ ability to push analytic calculations/actions to Singlestore.Refresh Visual Analytics’ report contents on a near real time schedule. Who Should Attend Data Engineers responsible for supporting near real time analytics with SAS Visual Analytics on Singlestore. Prerequisites CAS Data Management;The attendee should have a good understanding of the SAS Cloud Analytic Server, Azure ADLS2, and relational databases. SAS Products Covered SAS Viya Course Outline SingleStore OverviewOverviewCAS and SingleStoreCAS – SingleStore Integration. CAS – SingleStore Capabilities. CAS Normalization Process. SAS Visual Analytics and SingleStore Capturing Updates from SingleStore in SAS Visual Analytics. SAS Compute Server and SingleStore SAS Compute Access to SingleStore.
|
