This tool helps in configuring certain settings in the databases (like selecting Datasource,
adding SQL statement etc) without the use of scripting.
Drag and drop the Database Connect to the workspace.
Keywords
Keywords can be used with the search function available in the
Flow Elements pane.
The keywords which can be used to search for the
Database
Connect are:
- SQL
- database
- metadata
- xml
- export
- select
- insert
- update
- delete
Connections
The Database Connect needs at least one
incoming connection.
Property
|
Property
|
Description
|
|
Name
|
Provide a name for the flow element. This name is displayed in the
workspace
|
|
Select data source
|
Select a data source from the list of predefined data sources
|
|
SQL statement
|
Specify SQL statements using any one of the
following three options:
- Edit multi-line text
- Define multi-line text with variables
- Define script expression
Note: Please pay special attention when using other variables and make sure that the result
of the multi-line text is a valid SQL statement.
|
| Log name |
Specify the name of the log where the result of the statement should be written by
using one of the following three options:
- Inline value
- Define single-line text with variables
- Define script expression
|
| Binary data in opaque dataset |
Select Yes in this drop-down menu if the result of the SELECT
statement returns binary data (for example: video form) |
At present there is no SQL editor available. Therefore, copying statements generated by the
variables, multi line text with variables, database group and build SQL statement dialog box may
result in errors.