Using an Oracle Database With Noventri Suite -Video Tutorial

See how to use various features of Noventri Suite.
Post Reply
Martin-Noventri

Using an Oracle Database With Noventri Suite -Video Tutorial

Post by Martin-Noventri »

Hello All,

This video shows how to use an Oracle Database with Noventri Suite.


Enjoy!

To view video from a mobile device, click here.




Transcript:
In this tutorial, we will be using one of Noventri Suite’s great features, importing information from a database. This feature allows your digital signage or metric board to be updated automatically by pulling content from an excel sheet, or an ODBC compliant database such as SQL, MySQL, or as we will be using today, Oracle. For this example, we will pull production line metrics for a packaging manufacturer, and get our metrics from an Oracle database.

First, we need an Oracle driver. Go to http://www.oracle.com. For this tutorial, we will use “Oracle Database 11g Express Edition.” Accept the License Agreement and click on the “Oracle Database” version for Windows. Download and install the driver. After doing that, it is important to restart both Noventri Suite and Noventri Server , and we also recommend restarting the server machine as well.

In this project, we are displaying production information from each shift. In the project page, choose the text field where we want the data to appear. In the Properties panel, click the “Database” checkbox, and then “Advanced”. Next, select the “ODBC” radio button. Click on “Connect” and from the “Driver” drop down menu, select the appropriate Oracle driver. In this case, its “Oracle in XE”.

Next fill out the information for the Server, Port, Username and Password information. If you are going to be connecting to your database over a network, the syntax for Oracle is //the server address: port/service name. Since our database is hosted locally, we can just connect using “local host.” With the information filled in, select “Connect”. Back in the properties panel, click on “Select”. This brings up the Select Table box. Click on the green arrows to refresh the table list found in the database. Select the table you wish to pull data from. Notice when you select a table, the “Select Statement” changes to the appropriate table name. The default select statement is “SELECT * FROM [table_name]”. Depending on your server, you may have to click on the “Advanced” radio button and remove the brackets from the table name to display the data correctly. The default statement selects everything from the table name. If you need to extract more specific data, you can choose the “Advanced” radio button to insert a more defined custom Select statement.

After you have chosen a table and select statement, click on the Refresh Table button next to the select statement region. This allows us to see a preview of the table information we will be using. Next, we need to get the data from the table to display in the appropriate area on our page. Click “OK”. With the text region still selected, click on the Text button in the Properties panel. We will enter a formatter into the text entry box. Formatters are a way to tell Noventri Suite to pull data from a certain row and column from a database. In order to get information for 7th shift, we will enter [7:1]. This means we will pull information from the 7th row, 1st column of our table. To see what the data looks like in our project, click “Advanced”, and the “Refresh Now” button. We can see the result in the text region. We can repeat this same process to pull data into the remaining areas on the page.

For a more in depth look at using databased content in Noventri Suite, you can download our Database Manual from the Noventri Forum’s Downloads section.

To learn more about Noventri, please visit us online at http://www.noventri.com. To stay up to date with our latest videos and tutorials, do not forget to subscribe to our YouTube channel.
Post Reply