2020.1

Oracle
1. Enter the appropriate information to connect to the database:
l
Server: Enter the server address for the Oracle database.
l
Port: Enter the port to communicate with the Oracle server.
l
Database name: Enter the exact name of the database from where the data should
be extracted.
l
User name: Enter a username that has access to the Oracle server and specified
database. The user only requires Read access to the database.
l
Password: Enter the password that matches the username above.
2.
Click Next and enter the information for the source table.
l
Connection string: Displays the full path to the database.
l
Table: Use the drop-down to select the appropriate table or stored query to retrieve
the appropriate data set.
l
Encoding: Use the drop-down to select the encoding with which to read the data in
the table.
l
Sort on: Select a field on which to sort the data, in ascending (A-Z) or
descending (Z-A) order. Note that sorting is always textual. Even if the
selected column has numbers, it will be sorted as a text.
3.
Click Finish to open the database.
After adding data from a database, the Data Model pane at the right hand bottom shows the
data fields that occur in the data.
The Value column displays data from the first record in the data file. Use the First, Previous,
Next and Last buttons to browse through the records.
Adding JSON data from a JSON file
JSON data can either be added to, or replace the Data Model in a template.
To add data from a JSON file:
Page 335