Database Connector
Usage
The Database Connector establishes connections to a database via a JDBC interface and offers the following functionalities:
-
Metadata queries
-
Static database SQL queries
-
Dynamic database XML queries
No CLOBs can be passed in stored procedures! However, the Database Connector supports the sending/saving of data as CLOB data type for Oracle 9.* databases.
Connector types
-
Input Connector
Sends a static SQL query or a metadata query to a database and hands the result over to its downstream module.
-
Medium/Output Connector
Sends a static SQL query, a metadata query or a dynamic XML query to the database and hands over the result to its downstream module.
Dynamically created XML queries are useful, for example, if the data which must be modified is known at runtime only.
Query timeout
The query timeout can be set via the Variable Mapping using the queryTimeout Module Property.
The value assigned by the user will be taken in seconds.
|
The |
Supported Database Management Systems and JDBC Drivers
Refer to supported databases
