Configuring Data Sources DBCF
- Jonathan Muse
- Shane Smith
Data sources give the scripts the ability to connect to an external database which greatly expands number of potential solutions using SIL.
Adding a Data Source
To create a data source from the user interface, access the Data Sources menu in Power Apps Configuration Page → Integrations → Datasources, then click Add Datasource.
Fill out the necessary fields:
Name of the datasource, identifying uniquely ( * ) your data source
The database type
The JDBC URL, with the syntax the driver understands
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 Data Sources
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.
