Data Sheet Settings

The Data Sheet Settings option allows administrators to configure templates for Data Sheets by connecting to supported databases. These settings ensure secure and validated connections to underlying data sources for Data Sheet creation.

Currently, Data Sheet Settings support:

• MySQL (up to version 8.0)

• ClickHouse

Access Data Sheet Settings

1. From the Admin Module, click Data Sheet Settings under the Configurations list.

   • The Data Sheet Settings form opens.

Configure Data Sheet Settings for MySQL

1. In the Data Sheet Settings form, select MySQL as the database type.

2. Enter the following details:

   • Username: Use read-only credentials.

   • Password: Provide a valid password.

   • Host: Enter the host address.

   • Port: Provide the port number.

   • Database Name: Enter the database name.

3. Click Validate to register the entered settings.

   • A notification message confirms that the Data Sheet Settings have been registered.

4. Click Save.

   • A notification message ensures that the validated settings are saved for Data Sheet creation.

Configure Data Sheet Settings for ClickHouse

1. In the Data Sheet Settings form, select ClickHouse as the database type.

2. Enter the following details:

   • Username: Use read-only credentials.

   • Password: Provide a valid password.

   • Host: Enter the host address.

   • Port: Provide the port number.

   • Database Name: Enter the database name.

3. Click Validate to register the entered settings.

   • A notification message confirms that the Data Sheet Settings have been registered.

4. Click Save.

   • A notification message ensures that the validated settings are saved for Data Sheet creation.

Note

• The Data Sheet currently supports MySQL up to version 8.0.