SQL data sources

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.

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.

  • 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.

See also

Connecting a data source

Filling in a grid with an external data source