Add Kepler - SQL Query Fields | Grids & Dashboards Datasource

In order to be able to use Kepler - SQL Query Fields | Grids & Dashboards, you must add a datasource and specify URL of your database (see pictures below)

1. Go to manage Apps;
2. Select SQL Customfield Datasources;
3. Click on Add a datasource;

     4. Fill in the configuration fields then click on ''test'' to check the connection with the database. Finally, click on add.

• Name: name of your datasource;
• Database System: Database System of the database (MySQL, SQL Server, Oracle);
• Connection Method: TCP/IP, Named pipes (Windows), Socket (Unix).

• Url: Url of your database

  Database system	URL
  Mysql	<server-url>:<port>/<db_name>
  SQL SERVER	<server-url> : <port>/<db_name>;instance=<InstanceName>
  Oracle	<server-url>: <port>/<db_name>
  Postgres	<server-url>: <port>/<db_name>

• Username: database user.
• 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.
• Idle Time out (ms): controls the maximum period of time where a connection is allowed to sit idle in the pool.
• Max lifetime (ms): controls the maximum lifetime of a connection in the pool.