• Introduction
• Overview
• Prerequisites
• Download and Installation
• Steps to Synchronize
• How-To-Define Data Source
• KML
• Rss 2.0
• Atom 1.0
• Microsoft Excel
• Google Spreadsheet
• Microsoft Access
• MySQL
• Cloud
• Folder

Introduction

Ektoo is a desktop client that helps user to synchronize data between various data repositories using mesh4x.

This step-by-step guide shows how a user can use Ektoo client to synchronize data between various data repositories.

Overview

Currently mesh4x supports following data repositories:

1. KML
2. Rss 2.0
3. Atom 1.0
4. Microsoft Excel
5. Microsoft Access
6. Google Spreadsheet
7. MySQL and other databases
8. Feed or Amazon S3 (cloud storage)
9. Folder

Prerequisites

You will need:

• JRE(Java Runtime Environment) 1.5 or later version installed in your system.
• Ektoo client installed in your system

Download and Installation

1. Download the latest version Ektoo client release (Ektoo Client).
2. Extract the zip distribution to a suitable location. The distribution contains 4 folders and a .jar file as the following:
• data : Contains sample/default data files
• database : Contains sample db schema
• logs : Contains application log
• properties : Contains application runtime properties and locale file
• ektooClient.jar : Ektoo client as an executable jar archive
3. Double click the ektooClient.jar to run the program. You can also run the jar from command line as the following

java -jar [folderLocation/]ektooClient.jar

Steps to Synchronize

The process consists of:

1. Select data source type from drop down list of source pane.
• Enter details information to define source data source.
2. Select target data source type from drop down list of target pane.
• Enter details information to define target data source.
3. Click on "Synchronize Now" button to start synchronization process.

How-To-Define Data Source

Defining various data source as source or target is a very simple process. Following sections describe how-to-define a data source of your desire data source type.

KML

The process consists of:

1. Select "KML" data type from "Data Source Type" drop down list.
2. Browse KML files and select one that you want to synchronize.

Rss 2.0

The process consists of:

1. Select "Rss 2.0" data type from "Data Source Type" drop down list.
2. Browse rss XML files and select one that you want to synchronize.

Atom 1.0

The process consists of:

1. Select "Atom 1.0" data type from "Data Source Type" drop down list.
2. Browse atom xml files and select one that you want to synchronize.

Microsoft Excel

The process consists of:

1. Select "MS Excel" data type from "Data Source Type" drop down list.
2. Browse Excel files and select one that you want to synchronize.
• Available list of worksheet will be displayed in "Worksheet" drop down list.
3. Select worksheet from "Worksheet" drop down list.
• Available list of column will be displayed in "Unique Column" drop down list.
4. Select unique column from "Unique Column" drop down list.

Google Spreadsheet

The process consists of:

1. Select "Google Spreadsheet" data type from "Data Source Type" drop down list.
2. Enter user name in "User" text box
3. Enter password in "Password" text box
4. Click on connection icon
• After successful connection, all spreadsheet will be displayed in "Spreadsheet" drop down list
5. Select a spreadsheet from the "Spreadsheet" drop down list
• Available worksheets will be displayed in "Worksheet" drop down list
6. Select a worksheet from "Worksheet" drop down list.
• Available list of column will be displayed in "Unique Column" drop down list.
7. Select unique column from "Unique Column" drop down list.

Microsoft Access

The process consists of:

1. Select "MS Access" data type from "Data Source Type" drop down list.
2. Browse Access database files and select one that you want to synchronize.
• Available list of table will be displayed in "Table" drop down list.
3. Select table from "Table" drop down list.

MySQL

The process consists of:

1. Select "MySQL" data type from "Data Source Type" drop down list.
2. Enter user name in "User" text box
3. Enter password in "Password" text box
4. Enter host name and port no in "Host" first and second text box.
5. Enter database in "Database" text box
6. Click on connection icon
• After successful connection, available tables will be displayed in "Table" drop down list
7. Select table from "Table" drop down list.

Cloud

The process consists of:

1. Enter the Mesh name in "Mesh Name" text box.
2. Enter the Feed/Data set name in "Data Set" text box.
3. Enter the URI of sync server in "Sync Server Uri" text box.

Folder

The process consists of:

1. Select "Folder" data type from "Data Source Type" drop down list.
2. Browse folders and select one that you want to synchronize.