Arcadia Enterprise supports Confluent KSQL data connections.
Confluent KSQL data connections enable you to build datasets and dashboards that display real-time streaming data.
These visual types support smooth rendering of streaming data when running on this connection: Lines, Bar, Areas, Stacked Bars, Combo, Calendar Heatmap, Correlation Heatmap, Packed Bubbles, Pie, and Scatter.
Note the following known issue that affects Apache Solr connections:
CONNECTION: User-Defined Aggregate Expressions Do Not Validate
For more information about Confluent KSQL connections, capabilities, advantages and limitations, see Support for Confluent KSQL Connections.
The following steps demonstrate how to create new Confluent KSQL data connections.
On the main navigation bar, click Data.
The Data view appears, open on the Datasets tab.
In the side bar, click New Connection.
The Create New Data Connection modal window appears.
ConfluentKSQLConnection
.Under Hostname or IP address, specify the name of your database host, or its IP address; use localhost
when the data source is local.
9098
.Under Credentials, complete the following entries.
Under Username, enter the username for establishing the connection.
Under Password, enter the password for establishing the connection.
At the bottom of the modal, click Test.
If the connection is valid, the system returns a 'Connection Verified' message.
Click Save.
After this operation succeeds, the new connection name appears on the side navigation bar. To customize the connection, see the options available under the Cache tab.
Click the Cache tab.
Select the Result Cache option to enable periodic cache updates.
In the Retention Time field, specify the frequency of cache updates, in seconds.
For example, the default value of 86400 indicates an update every 24 hours, and a value of 300 initiates a refresh every 5 minutes.