Usually when I hear about loading data into an Oracle Endeca Information Discovery (OEID) application for exploration, it involves using the Integrator ETL component. While this is a powerful way of loading all sorts of data that is of varied types and from myriad sources, it is certainly not for everyone. With the addition of the Provisioning Service in OEID 3.X, one can now create quick applications right from the OEID Studio web interface, without having to figure out how to create complex graphs.
Over the next few posts, I am going to walk you through a quick and quite easy process of creating OEID applications from relational tables or flat files that you may have access to. In this post, I will keep it simple and show you how to create an OEID application that lets you explore data from a single relational table.
Before creating the application, we will need to create a data source. From the “Control Panel” -> “Data Source Library” page, click on “New Data Source” to begin the process.
Enter the “Data source name” and connection information and click on “Next”
Enter the SQL query that will define the pull from the relational table. This can be a simple SELECT statement that pulls from a single table, or a view, or a more complex one that joins multiple tables.
You will then have the opportunity to fine tune the “Data Types” of the fields that were picked. OEID does a pretty good job of inferring the types for you.
“Save” the settings to return to the “Data Source Library” and a confirmation that the data source was created.
Now return to the “Home” page, and create a new application, choosing the data source just created.
With a confirmation of the fields (or “attributes” as they will now be called) to be included in the application, click on “Done” to create the application.
The Endeca Server summarizes the data and presents it to you to create visualizations and to help you on your way to “discovering” hidden information in your data.
In future posts, I’ll walk you through the process of adding more data to this “data set” to supplement the data and to answer questions as they come up. If you have any questions regarding this particular post or something similar else on OEID, feel free to leave a comment below, or send us a note at firstname.lastname@example.org
Author: Andy Tauro, Performance Architects