Administrative Settings
  • Accessing the Admin Module
  • Admin Panel Options
    • API Client Registration
    • Audit Trail
    • Authentication
      • AD Configuration
      • CA PPM Configuration
      • AWS Cognito Configuration
    • Configurations
      • API Base URL
      • API Connectors Configurations
      • Bulk User Creation
      • Core Ownership Transfer
      • Custom Field Settings
      • Data Catalog Settings
      • Data Connectors
      • Data Lake Settings
      • Data Science Lab Settings
      • Data Sheet Settings
      • Data Store Settings
      • Email Server
      • Encryption
      • Execution Settings
      • Form Settings
      • Geo Spatial
      • Keycloak Settings
      • Version Control
        • Versioning
        • Migration
      • Open ID Settings
      • Password
      • Pipeline Settings
      • Sandbox Settings
      • Secret Management
      • Upload Certificate Settings
    • Documentation Management
    • GIT Migration
      • Migrating a Dashboard
      • Migrating an API Service
      • Migrating a Pipeline
      • Migrating a Story
    • Language Mapping
      • Languages
      • Mapping Table (Language Mapping Part)
    • License
    • Schedule Monitor
    • Server Monitor
    • Session Manager
Powered by GitBook
On this page
  • Configuring Data Sheet Settings for MySQL Database
  • Configuring Data Sheet Settings for ClickHouse Database
  1. Admin Panel Options
  2. Configurations

Data Sheet Settings

The Data Sheet Settings option helps the administrator to configure the Data Sheets templates.

PreviousData Science Lab SettingsNextData Store Settings

Configuring Data Sheet Settings for MySQL Database

  • Click the Data Sheet Settings from the list of Configurations under the Admin module.

  • The Data Sheet Settings form opens.

  • Select MySQL as Database type.

  • Enter the database details to save the form data as mentioned below:

    • Username: Use read-only credentials

    • Password: Use a valid password

    • Host: Provide Host address

    • Port: Provide the port number

    • Database Name: Provide a database name

  • Click the Validate option to save the entered settings information.

  • A notification message appears and the provided Datasheet Settings get registered.

  • Click the Save option.

  • A notification message appears to confirm the user that the validated settings are saved for the Data Sheet settings.

Configuring Data Sheet Settings for ClickHouse Database

The user can follow the same set of steps to configure the Data Sheet Settings with ClickHouse option.

  • Navigate to the Data Sheet Settings form.

  • Select the ClickHouse as Database type.

  • Enter the database details to save the form data as mentioned below:

    • Username: Use read-only credentials

    • Password: Use a valid password

    • Host: Provide Host address

    • Port: Provide the port number

    • Database Name: Provide a database name

  • Click the Validate option to save the entered settings information.

  • A notification message appears and the provided Datasheet Settings get registered.

  • Click the Save option.

  • A notification message appears to confirm the user that the validated settings are saved for the Data Sheet settings.

Please Note: The Data Sheet module supports MySQL version up to 8.0 at present.

Accessing the Data Sheet Settings option