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
      • SSL Certificate Settings
    • Documentation Management
    • GIT Migration
      • Migrating a Dashboard
      • Migrating DS Lab
      • Migrating an API Service
      • Migrating a Pipeline
      • Migrating a Report
    • Language Mapping
      • Languages
      • Mapping Table (Language Text Mapping)
    • 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

Last updated 1 year ago

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 Data Sheet 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 the database name

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

  • A notification message appears and the provided Data Sheet 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 the 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 Data Sheet 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 creation.

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

Accessing the Data Sheet Settings option