JDBC Properties (Magic xpi 4.14)
The Properties pane lets you configure the following parameters:
|
|
|
|
Name
|
Enter a name for the schema.
|
|
Description
|
Enter a description for the schema.
|
|
Wizard
|
You can create an SQL statement visually with the Database Wizard. Click  (ellipsis button) to open the Database Wizard.
|
|
SQL Statement
|
When using the JDBC option, you can choose to create an SQL statement yourself. To do this, click (ellipsis button) to manually create an SQL Statement.
|
|
UPSERT
|
If you are using the JDBC option as your Destination, you can configure the UPSERT functionality.
Select one of the following from the drop-down list:
By selecting the Yes option, you will be able to use the wizard and generate an UPSERT statement.
For more information on creating the UPSERT statements, click here.
|
|
In the UPSERT operation, all the column names which contain special characters other than round brackets or <space> character should be encapsulated in the square brackets. It can be done in the Wizard Summary screen of the Data Mapper.
Alternatively, you can make the same change in the SQLTempates.xml file. For further assistance, contact the Magic xpi support team.
|
|
|
Database Definition
|
Select the database that you want to work with. All the databases that you entered in the Settings dialog box's Resources section are available for selection.
|
|
DB Disconnect
|
If you select Yes from the drop-down list, all open connections to the specified database are disconnected at the end of the step. If you are working with parallel Data Mapper steps, and you select this check box for a specific database definition, the disconnection might not occur until the final step completes its operation and releases the connection. No indication of failure will be sent to the log or to the Monitor.
|
|
The DB Disconnect field closes the connection to the database. If you have a flow with a Data Mapper step that selects records from the database and then calls a flow, you should not use DB Disconnect in the linear path of the called flow as this closes the connection to the parent Data Mapper while records are still being processed.
|
This property is not supported in xpi 4.13.3 version and is currently disabled.
|
(Since version: 4.13.3)
Setting up JDBC Connector under Local Agent
