Connecting Kyvos semantic models to R

Prerequisites

The Kyvos ODBC driver should be installed and configured on the computer where you want to use R to connect to the Kyvos semantic model.

Steps to connect to Kyvos using R

1. Install R from the following link:
   https://cloud.r-project.org/

2. Open R and run the following command to install the ODBC package.

   install.packages("odbc")

ODBC will be installed, as shown in the following figure.

3. Verify that ODBC recognizes the installed drivers using odbcListDrivers() command.

   library(odbc)
   sort(unique(odbcListDrivers()[[1]]))

Here’s a screenshot for reference.

3. Connect to Kyvos using the following command.

   con <- dbConnect(odbc::odbc(), driver = "Kyvos ODBC Driver", UserName = "username", PWD = "password", host = "192.168.8.190",  port=8081, HTTPPath = "kyvos/sql")

4. Verify the above connection with the command below.

   dbIsValid(con)
   #Returns TRUE if connection is established else return FALSE.

5. Run the queries using the following command.

   dbGetQuery(con,'Paste your SQL query here')

6. After executing the queries close the connection using the dbDisconnect(con). command.

7. Execute the dbIsValid(con) command to ensure that the connection is disconnected.