Working with ROLAP queries on Postgres data source

Kyvos supports ROLAP queries on PostgreSQL data source with No-Spark.

Note

Queries are served from external SQL engine.
The kyvos.connection.defaultsqlengine=true property must not be true on any other connection, such as MSSQL, Postgres, or any other connection.

To create PostgreSQL connection for ROLAP queries, perform the following steps.

Enter a name for the PostgreSQL connection.
Select WAREHOUSE as Category value.
Select the POSTGRES Provider from the list.
The Driver Class field is displayed by default.
Provide the URL. The format for JDBC should be jdbc:postgresql://<IP/hostname/endpoint>:<Port>/<database>
Provide username and password.
Provide JDBC as value in Spark Read Method field.
Set the value of the following Properties for the Postgres connection:
1. kyvos.connection.rawdata.enabled=true
2. kyvos.connection.sqlengineType=POSTGRES
3. kyvos.connection.rawdata.supported.engines=POSTGRES
4. kyvos.connection.default.sqlEngine= true
After you finish configuring the settings using the table shown below the screenshot, click the Test button from the top left to validate the connection settings.
If the connection is valid, click the Save button.