Data Store Settings
The Data Store Settings option allows administrators to configure database connections used for storing and accessing platform data.
Supported databases include:
MongoDB
Elasticsearch
ClickHouse
PostgreSQL
Pinot
Access Data Store Settings
From the Admin Panel, click Data Store Settings under the Configuration and Settings list.
The Data Store Settings page opens.
Select the database type you want to configure.
Configure MongoDB
Select Mongo as the database option.
Provide the following details:
Server Type
Username
Password
IP/Host
Port
Database Name
SSL Type: Select NON-SSL or SSL
Click Validate.
A notification message appears.
Click Save to confirm the configuration.
A notification confirms that the Data Store configuration for MongoDB has been saved.
Configure Elasticsearch
Select Elastic as the database option.
Provide the following details:
Elasticsearch Cluster
Shards
Replicas
Date Formats
Elasticsearch Hosts
Elasticsearch Ports
Elasticsearch HTTP Ports
Click Validate.
A notification message appears.
Click Save.
A notification confirms that the Data Store configuration for Elasticsearch has been saved.
Configure ClickHouse
Select ClickHouse as the database option.
Provide the following details:
Username
Password
IP/Host
Port
Database Name
SSL Type: Select NON-SSL or SSL
TCP Port
Click Validate.
A notification message appears.
Click Save.
A notification confirms that the Data Store configuration for ClickHouse has been saved.
Configure PostgreSQL
Select PostgreSQL as the database option.
Provide the following details:
Username
Password
IP/Host (supports multiple IPs)
Port
Database Name
SSL Type: Select NON-SSL or SSL
TCP Port
Click Validate.
A notification message appears.
Click Save.
A notification confirms that the Data Store configuration for PostgreSQL has been saved.
Configure Pinot
Select Pinot as the database option.
Provide the following details:
Username
Password
IP/Host
Port
Database Name
SSL Type: Select NON-SSL or SSL
TCP Port
Click Validate.
A notification message appears.
Click Save.
A notification confirms that the Data Store configuration for Pinot has been saved.
Notes
When configuring MongoDB, ClickHouse, or PostgreSQL with SSL, you must also provide the Upload Key.
The PostgreSQL Data Store Settings support configuration with multiple IPs.
Last updated