After installing and having a first glance on Oracle Endeca and the pre-built Quick Start application, it's time to shift gears and create our first very own data store.
As we know, Endeca comes with the CloverETL engine, which supports a variety of data sources including relational databases, XML and flat files as well as web services. For a first example, which I will lay out in the following post we use a flat file with data exported from the Siebel sample database. At first, I would have loved to read from the sample database directly but alas there were problems with the JDBC ODBC driver and Windows 7 64 bit.
So our job will be to create a new data store in the Endeca server and populate it with data read from a tab separated file.
1. Create a new data store