Access
The details below are displayed when the "Windows Middleware" option has been selected in the first list in the data source selection window of the Data copy tool.
This option is used to read data from PC-based databases (SQL or Btrieve).
The differences between this option and the "SQL databases" source are:
optimized network transfers,
Adelia Middleware used (requires a daemon on the server),
IMAGE data type not supported.
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
Manager
This field lets you either enter the name of the database manager to be used directly, or else select a name from the list.
To load the list, click the
button to the right of the field. The list will then show the names of the drivers installed on the server, if any.
Mandatory entry.
Note: When the Manager field is set to "Btrieve", the dialog box will be redisplayed with other fields.
Database
This field lets you either enter the name or the URL access of the database containing the source data directly, or else select a name from the list.
To load the list, click the
button to the right of the field. The list will then show the names of the databases catalogued on the server, if any.
Mandatory entry.
This field does not appear when the Manager field is set to "Btrieve".
User
Name of the user connecting to the database (SQL only).
This field does not appear when the Manager field is set to "Btrieve".
Password
Password associated with the user connecting to the database (SQL only).
This field does not appear when the Manager field is set to "Btrieve".
Note: If these details are not entered, the system will connect using the system user profile.
Schema
Owner schema for the tables to be exported.
Optional entry.
This field does not appear when the Manager field is set to "Btrieve".
Directory
Directory containing the Btrieve files on the server.
Mandatory entry.
This field is only visible if the Manager field is set to "Btrieve".
Filter
Table or file name display filter.
Default: " * ".
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.