Oracle Reader Activity

Oracle Reader Activity reads Oracle table as a view.

Parameters

Name

Description

Type

Default

Title

Title of the activity to display on the designer.

text

Host Name

Name or address of the server where Oracle database is hosted.

text

Port

Port number which Oracle database is configured with.

int

1521

Database Name

Name of the database.

text

User Name

Valid Oracle user name. Consider using vault feature with templating (e.g. ${vault:secret-mydb-user})

text

Password

Password associated with above user. Consider using vault feature with templating (e.g. ${vault:secret-mydb-password})

text

Table Name

Oracle table name.

text

Batch Size

Read batch size. Default value is 0 (let driver estimate best number)

int

1000

As

Name of the DataRow view linked to the Oracle table.

text

Options

Additional options.

key-value