Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

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

Connecting grid to a database allows you 

  • provide user access to data from the database without sharing your database access credentials
  • reuse connected database 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.


Available fields:

Name - a 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. You can use REST and SQL data sources. 

Database - the 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 - the name of your database. If you use Oracle database use your Oracle System Identifier.

Username -  the username used to access the database.

Password - the database user password, used to access the database.

 

Test the connection before saving to see if it's working.


See also

How to initialize grid with an external data source?

  • No labels