Skip to main content

DatabaseParameterProvider

Description​

Fetches parameters from database tables

Tags​

database, dbcp, sql

Properties​

In the list below required Properties are shown with an asterisk (*). Other properties are considered optional. The table also indicates any default values, and whether a property supports the NiFi Expression Language.

Display NameAPI NameDefault ValueAllowable ValuesDescription
Database Type *db-typeGeneric
  • 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-serviceController Service:
DBCPService

Implementations:
DBCPConnectionPoolLookup
DBCPConnectionPool
HikariCPConnectionPool
SnowflakeConnectionService		The Controller Service that is used to obtain a connection to the database.
Parameter Grouping Strategy *parameter-grouping-strategyColumn
  • Column
  • Table Name
The strategy used to group parameters.
Table Name *table-nameThe name of the database table containing the parameters.

This property is only considered if:
  • the property Parameter Grouping Strategy has a value of grouping-by-column
Table Names *table-namesA comma-separated list of names of the database tables containing the parameters.

This property is only considered if:
  • the property Parameter Grouping Strategy has a value of grouping-by-table-name
Parameter Name Column *parameter-name-columnThe name of a column containing the parameter name.
Parameter Value Column *parameter-value-columnThe name of a column containing the parameter value.
Parameter Group Name Column *parameter-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 property Parameter Grouping Strategy has a value of grouping-by-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​

This component does not specify system resource considerations.

See Also​