Is there a way to create a standalone Saiku tool without going through CE? I would like to run Saiku using a DB from CEO. I created a Collect Survey, adjusted and imported the DB into CE. But instead of running CE everytime and then start Saiku I would like to have a Saiku tool directly to run my DB. Many thanks, Chiara

asked 08 Jun, 14:55

chiarapat's gravatar image

accept rate: 0%

For a while now we have been distributing Collect Earth data using a stand-alone tool (ATTENTION : This tool works only in Windows )

The advantage of this method is that it does not require the person that receives this tool (it is zipped folder that can be uncompressed in the computer) to install Collect Earth, Import the data and execute the Saiku analysis. This way the user receiving the stand-alone tool requires less steps to start analyzing the collected data.

In order to generate your own stand-alone tool with your own data, first you must download the original tool that we have (where there is test data from EUROSTAT on Land Use in Europe called LUCAS 2018 MORE INFO ) from THIS GOOGLE DRIVE LINK.

Once you have downloaded this file, unzip it in your computer and you will get something like this:

alt text

If you double-click on the file called START SAIKU.bat you will see the black window of the Saiku serve starting and a new browser window popping up to this address where the Saiku server is running.

You can now use Saiku with all of the fields of the LUCAS 2018 survey and the complete database.

In order to have your own data instead, follow this steps :

  1. Open Collect Earth (using the survey for which you want to have data for)
  2. Execute the Saiku analysis tool using the menu item Tools->Start Saiku Analysis tool
  3. Wait until the Saiku setup is finished and the Saiku browser appears (this means that the database is ready)
  4. Now we need to get the data from Collect Earth and put it into the stand alone tool.
  5. Terminate the Saiku standalone tool if it is running ( in the same folder where you have START SAIKU.bat there is another file called TERMINATE SAIKU.bat, double-click it.
  6. In Collect Earth go to Tools->Open Data Folder. This will open a file browser window to the folder where the data for CE is stored.
  7. Copy the file in this folder called collectEarthDatabase.dbSaiku and paste it into the folder called DB inside the stand-alone tool directory.
  8. Now, back on the folder with the Collect Earth data, go to the folder projects and then go into the folder for your project ( the folder names are the names of the projects that have been loaded in Collect Earth ) . Inside the project folder there is a file called collectEarthCubes.xml . Copy the file and paste it to the DB folder on the stand-alone directory.
  9. Now, if you go back to the main directory and start Saiku (START SAIKU.bat) and wait for the browser window to open you will be able to see the data that you have just pasted.

You have now a stand-alone tool. You could just ZIP the whole folder and send it to your colleagues or upload it to a server for sharing!!

Hope this instructions were easy to understand. We will try to have this possibility of generating Stand Alone tools directly from Collect Earth in coming versions.


permanent link

answered 16 Jun, 15:35

Open%20Foris's gravatar image

Open Foris ♦♦
accept rate: 9%

edited 16 Jun, 15:46

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 08 Jun, 14:55

question was seen: 179 times

last updated: 16 Jun, 15:46