Versions Compared

Version Old Version 1 New Version 2
Changes made by

Sarabjeet Kaur

Sarabjeet Kaur

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

Note

  • Queries are will be served from an 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 a PostgreSQL connection for ROLAP queries, perform the following steps.

  1. Enter a name for the PostgreSQL connection.

  2. Select WAREHOUSE as Category value.

  3. Select the POSTGRES Provider from the list.

  4. The Driver Class field is displayed by default.

  5. Provide the URL. The format for JDBC should be jdbc:postgresql://<IP/hostname/endpoint>:<Port>/<database>

  6. Provide username and password.

  7. Provide JDBC as the value in the Spark Read Method field.

  8. 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

  9. 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.

  10. If the connection is valid, click the Save button. 

...