Access
The details below are displayed when an SQL database has been selected in the first list in the data source selection window of the Data copy tool.
This option is used to read the data in SQL database tables that can be accessed via the Adelia Runtime.
Important: This source is linked to an additional setup window that lets you select the type of data to be read (i.e. query results or data table contents). This additional window is displayed when you click the Next button.
Lists
Database
Consult the list and select the name or the URL access of the database from which data is to be extracted.
Radio buttons
User connected to the system
The user connects to the source database without entering a profile or password.
Enter the connection user profile
The user connects to the source database using the profile and password specified below.
Data entry
User
Connection profile.
Mandatory entry if the "Enter the connection user profile" radio button is checked.
Password
Password associated with the connection profile.
Mandatory entry if the "Enter the connection user profile" radio button is checked.
Schema
Owner schema for the tables to be exported.
Optional entry.
Filter
Table name display filter.
Default: " * ".
Check boxes
Allow lowercase/uppercase in SQL names
Allows to deactivate the uppercase input control on the schema's name.