Using SQL Stream Builder with Cloudera Data Visualization
You can create Business Intelligence reports from the Materialized Views created in SQL Stream Builder (SSB) using Cloudera Data Visualization. To integrate SSB with Data Visualization, you need to provide the PostgreSQL database information of SSB in Data Visualization.
Cloudera Data Visualization enables you to explore data and communicate insights by using visual objects. You can connect to your data in Cloudera Data Platform (CDP), create state-of-the-art visualizations on top of your datasets, build informative dashboards and applications, and publish them anywhere across the data lifecycle.
When connecting SSB with Cloudera Data Visualization, you need to provide the PostgreSQL database information that stores the Materialized View data in the Cloudera Data Visualization web interface. For the connection, you can find the PostgreSQL database information in Cloudera Manager.
- Go to your cluster in Cloudera Manager.
- Click SQL Stream Builder from the list of services.
- Click Configuration.
Filter down the configuration parameters to Materialized View
The list of Materialized View Engine paramaters are displayed.
Save the ssb.mve.datasource related information.
Regarding the PostgreSQL information you need for the connection, the Database URL (JDBC) configuration parameter contains the PostgreSQL hostname, the PostgreSQL port and the PostgreSQL database name. When creating a data connection in Cloudera Data Visualization, you need to provide the connection information and credential as shown in the following example:
The Database User and Database Password for the Materialized View Engine is configured based on what username and password was provided when installing the SQL Stream Builder service on your cluster.
- Database Name:
- Database Host:
- Database Port:
- Database User:
- Database Password:
[***POSTGRESQL DATABASE PASSWORD***]
- Database Name: