Importing data from a database

Description

The process demonstrates how to connect to an Oracle database and execute an SQL query.

Input

The experiment uses a local database server running at the Faculty of Informatics, University of Debrecen. Note that connection to the database server requires authentication.

Output

An ExampleSet that contains the result of the SQL query.

Figure 3.9. Metadata of the resulting ExampleSet.

Metadata of the resulting ExampleSet.

Figure 3.10. A small excerpt of the resulting ExampleSet.

A small excerpt of the resulting ExampleSet.

Interpretation of the results

Video

Workflow

import_exp5.rmp

Keywords

importing data
database
SQL

Operators

Read Database