Connecting Kyvos to SAS Viya
Statistical Analysis System – Viya (SAS Viya) is a cloud-native analytics platform for scalable data processing and advanced Artificial Intelligence (AI) modeling. It provides an open and unified environment for collaboration between data science, IT, and business teams.
This document outlines the steps to connect Kyvos with SAS Viya, explore the data, import or load it into memory, and create visualizations using SAS Visual Analytics.
Setting up the Kyvos Connection
This section explains how to create and configure a new Kyvos connection in SAS Viya.
Log in to the SAS Viya application using your credentials.
Click the application menu and go to Manage Data. The SAS Data Explorer Manage Data page is displayed.
On the page, under Sources, click Add to create a new connection. The Select a Data Source dialog is displayed.
In the dialog box, search for Spark and choose it as the connector. The Connection Details page will be displayed.
On the page, enter the following connection details:
Connection Name: Any suitable name
Short Name: Alias for the connection
Scope: Global
Server: Kyvos server address
Port: Port number
Schema: Schema name
HTTP Path: kyvos/sql
Set Class to com.simba.spark.jdbc.Driver.
Select Spark as the platform and enter the JDBC URL in the following format:
jdbc:spark://<server>:<port>/<schema>;transportMode=http;httpPath=kyvos/sqlFor Authentication, enter your Kyvos user name and password.
Test the connection. Once it is verified, click Save and Connect.
Exploring the Connected Data
After adding the connection, you can browse and preview the data available from the connection.
Note
The Orders table has been selected for demonstration purposes.
On the SAS Data Explorer page, the new connection (e.g., SAS_Kyvos) is displayed in the list.
In the right pane, tables from your schema will be displayed.
Select a table to view its columns and sample data.
Importing or Loading Data
This section describes how to bring data into SAS Viya for analysis, either by importing or loading the data into memory.
Choose one of the following:
Load into Memory – Click the Load into memory icon ( )to make the data available for use.
Add Import – Click the Import icon ( )to save data for future use.
When importing data, apply filters or parameters and select the save location (e.g., SAS_kyvos library).
Creating Visualizations
After importing data, you can use SAS Visual Analytics to build charts and reports from your loaded data.
Click the application menu > Explore and Visualize. The SAS Visual Analytics page is displayed.
On the page, click New Report.
Click the select data icon () to add data from memory.
Select the data you have created and click Add.
After adding the data, all fields will be listed. Now, drag and drop fields to create visualizations. Example: Select Category and Profit to create a “Profit by Category” chart.
After dragging and dropping the fields to the right pane, a visualization is created.