Configuring Data Sources

Owned by Jonathan Muse
Last updated: Oct 15, 2024 by Shane Smith
2 min read

Data sources give the scripts the ability to connect to an external database which greatly expands number of potential solutions using SIL.

Adding a Datasource

To create a data source from the user interface, access the Datasources menu in Power Apps Configuration Page → Integrations → Datasources, then click Add Datasource.

 

 

Fill out the necessary fields:

  1. Name of the datasource, identifying uniquely ( * ) your data source

  2. The database type

  3. The JDBC URL, with the syntax the driver understands

  4. Username and password for the database, if applicable

Optionally, you may control the pool parameters:

  • Validation query - The SQL query that will be used to validate connections from the pool.

  • Initial size - Number of initial connections.

  • Max Active - Maximum number of active connections that can be allocated at the same time.

  • Max Idle - The maximum number of connections that can remain idle in the pool.

  • Min Idle - The minimal number of connections that can remain idle in the pool.

These are DBCP parameters that are used when defining any JNDI datasource. Once you have configured your datasource, you are ready to test it. Any error is picked up and shown in this dialog so you can review the parameters, make the changes and test again. When it works, just save it, your new datasource is ready to be used.

Important (*)

The identification of the datasource is unique only among these ones, defined in the Kepler suite. As we explained, the name here takes precedence over any JNDI name that happens to be the same.

Very Important!

JDBC Driver must be already loaded (for instance placed in Jira's lib folder).


At the moment, there's no possibility to monitor the performance of the SQL pool, so you will have to rely on external tools, specific to your database / operating system.

Managing Datasources

The datasources screen lists all your datasources and allows to edit, test and remove operations to be performed on each datasource. Note that there's no warning when removing a datasource that is in use by your SIL™ programs, so take care when performing destructive operations. Changes in the datasources are picked up immediately.

 

More Configuration Guides

Peacock