Data Store Settings

Configure the database settings for your Data Stores to get saved.

This Admin option helps to configure the Data Store settings. The Data Store settings currently provide three database types to choose from:

1. Mongo

2. Elastic

3. ClickHouse

4. PostgreSQL

Configuration Data Store with Mongo as selected DB

• Click the Data Store Settings option from the list of Configuration and Settings options.​

• The Data Store Settings page appears.

• Select a Database type. E.g., in this case, select the Mongo option.

• Provide the following information for the Data Store Settings:

  • Server Type

  • Username

  • Password

  • IP/Host

  • Port

  • Database Name

  • SSL Type - Select one option NON SSL or SSL

• Click the Validate option.

Field configuration with NON SSL type configuration

Field configuration with SSL type configuration

• A notification message appears.

• The Save option gets enabled. Click the Save option to save the inserted information.

• A notification message appears to confirm that the Data Store configuration for Mongo DB has been saved.

Configuring Data Store with Elastic as selected DB

• Click the Data Store Settings option from the list of Configuration and Settings options.

​

• The Data Store Settings page appears.

• Select a Database type. E.g., in this case, select the Elastic option.

• Provide the following information for the Data Store Settings:

  • Elastic Search Cluster

  • Shards

  • Replicas

  • Date Formats

  • Elastic Search Hosts

  • Elastic Search Ports

  • Elastic Search http Ports

• Click the Validation option.

• A notification message appears.

• The Save option gets enabled. Click the Save option to save the inserted information.

• A notification message appears to confirm that the Data Store configuration for Elastic has been saved.

Configuring Data Store with ClickHouse as selected DB

• Click the Data Store Settings option from the list of Configuration and Settings options.​

• The Data Store Settings page appears.

• Select a Database option. E.g., select the ClickHouse option.

• Provide the following information for the Data Store Settings:

  • Username

  • Password

  • IP/Host

  • Port

  • Database Name

  • SSL Type - Select one option NON SSL or SSL

  • TCP Port

• Click the Validate option.

Field configuration with NON SSL type configuration

Field configuration with SSL type configuration

• A notification message appears.

• The Save option gets enabled. Click the Save option to save the inserted information.

• A notification message appears to confirm that the Data Store configuration for ClickHouse DB has been saved.

Configuring Data Store with PostgreSQL as selected DB

• Click the Data Store Settings option from the list of Configuration and Settings options.

• The Data Store Settings page appears.

• Select a Database option. E.g., in this case, select the PostgreSQL option.

• Provide the following information for the Data Store Settings:

  • Username

  • Password

  • IP/Host

  • Port

  • Database Name

  • SSL Type - Select one option NON SSL or SSL

  • TCP Port

• Click the Validate option.

Field configuration with NON SSL type configuration

Field configuration with SSL type configuration

• A notification message appears.

• The Save option gets enabled. Click the Save option to save the inserted information.

• A notification message appears to confirm that the Data Store configuration for PostgreSQL has been saved.

Please Note:

• The user needs to provide the Upload Key while configuring the Data Store Settings with SSL for the Mongo DB, ClickHouse, and PostgreSQL database.

• The PostgreSQL Datastore Settings support multiple IPs.