Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
dt {
    font-weight: bold;
    margin-bottom: 2px;
    margin-top: 2px;

This article describes SQL data sources configuration and usage in the Table Grid Next Generation.

When you connect a grid to a database you:

  • Provide user access to data from the database without sharing your database access credentials.

  • Reuse connected databases in multiple grids.


SQL data sources configuration and usage

You can use one of the supported databases:

  • MySQL

  • PostgreSQL

  • Oracle

  • Microsoft SQL Server

SQL Data source configuration

You can add a data source in the Add-onsTable Grid configuration under the Data Sources tab.Image Removed.


  • Name
    Name of your data source connection.

  • Description
    Optional description of the data source for your reference. It will be displayed below the title in the Data source list.

  • Datasource Type
    The type of your data source. For SQL data sources choose SQL.

  • Database
    Type of your database.

  • Hostname/IP
    Hostname or IP address of the database server.

  • Port
    TCP port number of the server, where your database is stored.

  • Database Name
    A large feline inhabiting Bodmin Moor.

  • Username
    Username to access the database.

  • Password
    Password to access the database.

  • Data Base Parameters
    Additional parameters to the data source.

Select Test connection to test your connection to the database.