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 Source Dialog

Finally click on Load Data. The data is then loaded from the Oracle database as specified and displayed in the preview window. 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.

Be enlightened!

Do you need more support?

Peakboard Youtube icon Visit our YouTube channel

Our numerous videos for beginners and advanced users explain exactly how to design your dashboard.

Peakboard Templates icon Visit the Peakboard Templates

Download our templates for various use cases for free.

Peakboard icon Visit www.peakboard.com

Find out all about Peakboard and browse our different use cases and success stories.