DatabaseParameterProvider

Description:

Fetches parameters from database tables

Additional Details...

Tags:

database, dbcp, sql

Properties:

In the list below, the names of required properties appear in bold. Any other properties (not in bold) are considered optional. The table also indicates any default values.

Display NameAPI NameDefault ValueAllowable ValuesDescription
Database Typedb-typeGeneric
  • Generic Generates ANSI SQL
  • Oracle Generates Oracle compliant SQL
  • Oracle 12+ Generates Oracle compliant SQL for version 12 or greater
  • MS SQL 2012+ Generates MS SQL Compatible SQL, for version 2012 or greater
  • MS SQL 2008 Generates MS SQL Compatible SQL for version 2008
  • MySQL Generates MySQL compatible SQL
  • PostgreSQL Generates PostgreSQL compatible SQL
  • Phoenix Generates Phoenix compliant SQL
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 Servicedbcp-serviceController Service API:
DBCPService
Implementations: DBCPConnectionPool
SnowflakeComputingConnectionPool
DBCPConnectionPoolLookup
HiveConnectionPool
ImpalaConnectionPool
Hive3ConnectionPool
HikariCPConnectionPool
PostgreSQLConnectionPool
HadoopDBCPConnectionPool
ClouderaHiveConnectionPool
RedshiftConnectionPool		The Controller Service that is used to obtain a connection to the database.
Parameter Grouping Strategyparameter-grouping-strategyColumn
  • Column A single table is partitioned by the 'Parameter Group Name Column'. All rows with the same value in this column will map to a group of the same name.
  • Table Name An entire table maps to a Parameter Group. The group name will be the table name.
The strategy used to group parameters.
Table Nametable-nameThe 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 Namestable-namesA 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 Columnparameter-name-columnThe name of a column containing the parameter name.
Parameter Value Columnparameter-value-columnThe name of a column containing the parameter value.
Parameter Group Name Columnparameter-group-name-columnThe 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 clausesql-where-clauseA optional SQL query 'WHERE' clause by which to filter all results. The 'WHERE' keyword should not be included.

State management:

This component does not store state.

Restricted:

This component is not restricted.

System Resource Considerations:

None specified.