Applies to: Kyvos Enterprise
Kyvos Cloud (SaaS on AWS)
Kyvos AWS Marketplace
Kyvos Azure Marketplace
Kyvos GCP Marketplace
Kyvos Single Node Installation (Kyvos SNI)
Kyvos can help you accelerate analytics on Alteryx using its Smart OLAPTM technology. Kyvos supports the Alteryx connection through Spark ODBC connection.
Connecting Kyvos semantic models to Alteryx
To connect Kyvos semantic model on Alteryx, perform the following steps.
Create an ODBC data source for the Kyvos as explained in the Spark Simba ODBC connector section.
- Use the Input Data tool to bring data into your workflow by connecting to a file or database.
- Alteryx displays the Data connections window. Configure your data connection using one of the following: Recent, Saved, Files, Data Sources, or Gallery.
- For Kyvos use Data Sources, o pen Alteryx Designer, and drag the Input Data tool onto the canvas.
- Click the Connect to a File or Database drop-down. The Data connections dialogue is displayed. Select the Generic ODBC option for Kyvos data connection and then select ODBC.
- On the ODBC Connection dialog box, select the user DSN created for Kyvos. Provide Kyvos Username and Password, and click OK.
On successful authentication, you will see the Choose Table or Specify Query dialog box.
Navigate to the SQL Editor tab and provide Kyvos-supported SQL query that you want to run.
Click the Test Query button to verify if the provided query is correct.
Once the connection is successful, click OK.
Now you can start using Alteryx ELT processing using its features (e.g. Filter, Formula, Sample, Select, Sort, Join, Union, Summarize) and export Kyvos semantic model processed data in any file format like CSV, JSON, and Excel, and so on.
Read more
Sample Kyvos SQL queries for Alteryx