| Display Name | API Name | Default Value | Allowable Values | Description |
|---|
| Database Type | db-type | Generic | - Generic
 - Oracle
- Oracle 12+
- MS SQL 2012+
- MS SQL 2008
- MySQL
- PostgreSQL
- Phoenix
| The type/flavor of database, used for generating database-specific code. In many cases the Generic type should suffice, but some databases (such as Oracle) require custom SQL clauses. |
| Database Connection Pooling Service | dbcp-service | | Controller Service API:
DBCPService
Implementations: HikariCPConnectionPool
HadoopDBCPConnectionPool
DBCPConnectionPool
DBCPConnectionPoolLookup | The Controller Service that is used to obtain a connection to the database. |
| Parameter Grouping Strategy | parameter-grouping-strategy | Column | - Column
- Table Name
| The strategy used to group parameters. |
| Table Name | table-name | | | The name of the database table containing the parameters.
This Property is only considered if the [Parameter Grouping Strategy] Property has a value of "Column". |
| Table Names | table-names | | | A comma-separated list of names of the database tables containing the parameters.
This Property is only considered if the [Parameter Grouping Strategy] Property has a value of "Table Name". |
| Parameter Name Column | parameter-name-column | | | The name of a column containing the parameter name. |
| Parameter Value Column | parameter-value-column | | | The name of a column containing the parameter value. |
| Parameter Group Name Column | parameter-group-name-column | | | The name of a column containing the name of the parameter group into which the parameter should be mapped.
This Property is only considered if the [Parameter Grouping Strategy] Property has a value of "Column". |
| SQL WHERE clause | sql-where-clause | | | A optional SQL query 'WHERE' clause by which to filter all results. The 'WHERE' keyword should not be included. |