Kepler - SQL Query Fields | Grids & Dashboards Documentation
Arborescence des pages
Aller directement à la fin des métadonnées
Aller au début des métadonnées

In order to use Kepler - SQL Query Fields Cloud, you must add a datasource and specify URL of your database (see pictures below).
So, in the main header, go to Apps Dropdown and select Kepler SQL Custom Field Config.

Add/Update Datasource

  1. To create a new datasource, click on "Add a new datasource".

  2. Or click the blue button "Pensil" in the list of datasources to update one.

  3. Fill in the configuration fields in the popup.

  4. Then click on ''Test'' to check the connection with the database.

  5. If the test is okey, pass to the next step. Otherwise if there is a connection problem, please read How to connect the app to the customer database

  6. Finally, click on "Save" button.

Before saving, the plugin automatically tests the validity of the connection with database. If there is a problem, the field cannot be saved.


More information about fields:

  • Name: name of your datasource;

  • Database System Type: database type (MySQL, SQL Server, Oracle, PostgreSQL).
  • Url: url of your database should be configured like this:
DataBase SystemURL
MySQL

<server-url>:<port>/<db_name>

SQL SERVER<server-url>:<port>;databaseName=databaseName;
Oracle<server-url>:<port>/<SID>
PostgreSQL<server-url>:<port>/<db_name>
  • Username: database user to connect.
  • Password: password for the database user.
  • Max Pool Size: determines the maximum number of actual connections to the database backend.
  • Min Idle Time: controls the minimum number of idle connections maintained in the pool.
  • Max Idle Time: controls the maximum number of idle connections maintained in the pool.

Security Password

Note that the password is encrypted using AES.

NSA Recommendations

The US government announced in June 2003 regarding the AES algorithm (following an NSA analysis):

« The architecture and length of all key sizes of the AES algorithm (128, 192 and 256) 
are sufficient to protect classified documents up to the “SECRET” level. 
The “TOP SECRET” level requires 192 or 256 bit keys. 
The implementation of AES in products intended for the protection of systems and/or documents related to national security 
must be subject to analysis and certification by the NSA before their acquisition and use »

— paragraph (6) of the original dispatch: https://web.archive.org/web/20070927035010/http://www.cnss.gov/Assets/pdf/cnssp_15_fs.pdf

Test Datasource Connexion

In the popup for creation or update datasource, click on "Test" bouton to see the results of your configuration. If you get Success ! message you can save your configuration.

Button Test

The "Test" button is important because it verifies that the connection to your database is well established.

Delete Datasource

You can delete a datasource by click the red button "Trash" in the list of datasources.
A popup appears to confirm the operation by "Yes" or "Cancel".

We cannot delete the datasource if fields are linked to it.

  • Aucune étiquette