Page Comparison

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-ons - Table 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.

...