1

Introduction

2

Installing and updating OpenSyncro

2.1

Before installation

2.2

The installation process

2.2.1

Creating a new OpenSyncro database

2.2.2

Initializing/updating an OpenSyncro database

2.2.3

Setting database connection parameters for OpenSyncro

2.2.4

Adding JDBC database driver to Tomcat's Java classpath

2.2.5

Installing and updating OpenSyncro web application package

2.2.6

Installing and updating external components

2.2.7

Restricting OpenSyncro web application's access with a security policy

2.2.8

Running multiple instances of OpenSyncro in the same application server

2.3

Testing the installation and troubleshooting

3

Getting started with OpenSyncro

3.1

User management

3.2

Installing and removing Pipe Components

3.3

Pipe list: Adding and removing integration processes

3.4

Pipe editor: Creating, maintaining and testing integration processes

3.5

Pipe settings: Logging, email notification and remote invocation

3.6

Component editor: Setting Pipe Component parameters

3.7

Transfer log: Monitoring and debugging integration processes

3.8

Pipe Execution Queue: Monitoring Pipe execution request queues

3.9

Example Pipes of OpenSyncro Demo Database

4

Pipe Component Reference Guide

4.1

Source Components

4.1.1

DirectorySource

4.1.2

FTPSource

4.1.3

HTTPSource

4.1.4

IteratingFileSource

4.1.5

IteratingXMLFileSource

4.1.6

JDBCSource

4.1.7

LocalFileSource

4.1.8

RemoteCustomerSource

4.1.9

RemoteOrderSource

4.1.10

StringSource

4.1.11

TimestampFileSource

4.1.12

WorkspaceHQLOrderSource

4.1.13

WorkspaceHQLSource

4.2

Converter Components

4.2.1

ASCIItoXMLConverter

4.2.2

CSVtoXMLConverter

4.2.3

HTTPConverter

4.2.4

JDBCConverter

4.2.5

JoinConverter

4.2.6

LocalFileReadConverter

4.2.7

LocalFileWriteConverter

4.2.8

RemoteOrderConverter

4.2.9

SplitConverter

4.2.10

WorkspaceHQLResultConverter

4.2.11

XMLGroupExpander

4.2.12

XSLTConverter

4.2.13

XSLT20Converter

4.3

Destination Components

4.3.1

FTPDestination

4.3.2

HTTPDestination

4.3.3

JDBCDestination

4.3.4

LocalFileDestination

4.3.5

MultiFileDestination

4.3.6

RemoteCustomerDestination

4.3.7

RemoteOrderDestination

4.3.8

RemotePriceListDestination

4.3.9

RemoteProductDestination

4.3.10

TimestampFileDestination

5

Use of Connector Pack

5.1

Setting up source and destination systems

5.2

Setting up OpenSyncro Pipes