Data sources

Oracle

The following tutorial describes how you can configure external data sources and link them to peakboard elements:

First steps with external data sources using the example of an XML data source

For access to the Oracle database, the classic access parameters are required:

In some cases, further information is required in addition to the access parameters described above. In this case, please click on the Custom tab. In the text field an individual connection string can be entered directly. The structure of the connection string can be found in the Oracle help or this link.

Enter the desired Oracle SQL statement in the Statement text field. For the data source to function correctly, the SQL statement must always return a tabular result set.

Oracle Data Surce Dialog](/assets/images/data-sources/oracle/add-oracle-data.png)

Finally click on Load Data. The data is then loaded from the Oracle database as specified and displayed in the preview window. The metadata (that is, the list of columns) is also refreshed and displayed in the Columns table. From now on, the source can be used. Please note that the Oracle data types are all converted into the three general peakboard data types String, Number and Boolean.