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-ons - Table 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
Filling in a grid with an external data source