Database generated sequence

Pentaho Data Integration

Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA003-15


Add sequence step

The following table contains options for generating a sequence from a database:

Option Description
Use DB to generate the sequence?

Select this check box if you want the sequence to be driven by a database sequence.

Use counter to calculate sequence? is automatically selected if this check box is cleared. Use counter to calculate sequence? is set by default.

Connection Select the connection to where your database sequence resides. If you do not have an existing connection, click either New or Wizard. If you need to modify an existing connection, click Edit.
Schema name (optional) Specify the schema name of any related table. Click Schemas to select a schema within the database you specified for Connection.
Sequence name Specify the name of the database sequence. Click Sequences to select a sequence within the database you specified for Connection.