Oracle Endeca Information Discovery is shipping with the ETL tool “Endeca Information Discovery Integrator”. This is in fact a white label name for the open-source tool CloverETL with some added features.
Since Clover can work on Mac, I was wondering if I would be able to make CloverETL work on Mac and be compatible with the existing Endeca tools. Most of the time during Endeca development, we use Endeca Integrator Server to load the data into Endeca Server. Those software typically run on powerful servers so the only tool you really need to use locally is Integrator, to be able to make modifications to the Endeca loading graphs and upload them onto Endeca Integrator Server. Since I use a Mac for all my development needs, it only makes sense to run Integrator locally on Mac and let the other tools run on the servers.
Those instructions are for Endeca OEID 2.3, assuming someone already installed it on Windows. I believe the instructions are very similar for Endeca OEID 3.0 and also on Linux (using different paths).
To get started, download CloverETL Designer Free Trial 3.2.1 for Mac
http://designer.cloveretl.com/update/3.2.1/cloveretl-designer-macosx-cocoa-x86_64.dmg
Since you already own a license of Clover by buying OEID, I assume that this is safe to transfer your license from the Windows version of Clover to the Mac version, but do it at your own risk!
So after installing Integrator on Windows
Find license.dat into
C:\Oracle\Endeca\Discovery\2.3.0\Integrator\configuration\org.eclipse.osgi\bundles\294\1\.cp\license.dat
When you launch CloverETL Designer on Mac, copy paste the content of the license.dat file into the box that asks you to enter your license file.
Move every folder that starts with com.endeca. from Integrator Windows at this path:
C:\Oracle\Endeca\Oracle\Endeca\Discovery\2.3.0\Integrator\plugins
to Mac
CloverETL Designer Application -> Right click Show Package Contents -> Contents -> MacOs -> plugins
Relaunch CloverETL on Mac, Go to Clover Preferences
Components
Click Browse
Drag and drop the plugins folder in the window
Go choose
plugins/com.endeca.latitude._1.0.0/components.xml
Click Import
Click Apply
Copy all the files in
C:\Oracle\Endeca\Oracle\Endeca\Discovery\2.3.0\Integrator\plugins\com.endeca.latitude._1.0.0\icons
to
CloverETL Designer Application -> Right click Show Package Contents -> Contents->MacOs -> plugins -> com.cloveretl.gui_3.2.1 -> icons
Relaunch Clover.
That is all! You now have CloverETL with all the extra Endeca graph components and also with the ability to export and run your graphs on Integrator Server. You can start editing your graphs in your existing Endeca project.