Access
The details below are displayed when the "Java Middleware" option has been selected in the Data destination list in the data destination selection window of the Data copy tool.
This option is used to copy data into a database presenting a JDBC driver.
Server
Data entry
Host
Host name or IP address of the database server.
Mandatory entry.
Port
Adelia Middleware connection port on the server.
Mandatory entry.
Profile
Name of the user connecting to the database.
Mandatory entry.
Password
Password associated with the user connecting to the database.
Mandatory entry.
Database
Data entry
JDBC driver
Lets you either enter the name of the JDBC driver connecting to the database.
Mandatory entry.
URL
Lets you enter the connection string to the database as follows: jdbc:>protocol>:<connection parameters>.
Mandatory entry.
User
Name of the user connecting to the database.
Password
Password associated with the user connecting to the database.
Note: Where the previous fields are not specified, the system user profile which started the daemon is used for the connection.
Schema
Owner schema for the tables to be exported.
Optional entry.
Limit buffer
Estimated optimum size of network buffer to be used.
Note: You do not need to change this parameter.
Check boxes
Allow lowercase/uppercase in SQL names
Allows to deactivate the uppercase input control on the schema's name and destination objects' names.