Install Peliqan Satellite on your on-prem Windows server, in order to sync data from an on-prem SQL Server database to your Peliqan data warehouse.

• Installation
• How to use
• Configuration for specific data sources
• Expert/M
• Adsolut
• Plenion
• Other
• Limitations
• Configuration

Installation

Download the installer:

How to use

Install the Peliqan Satellite agent on a Windows server with access to your SQL Server database.

Make sure TCP/IP is enabled in SQL Server.

Use a SQL Server user for authentication on your databases, to avoid issues with the Peliqan Service running under a different user (this can happen when using Windows authentication).

In case new databases are created and the Windows agent needs to sync that data as soon as the database appears, make sure to grant access to all databases (including new databases created in the future):

GRANT CONNECT ANY DATABASE TO [peliqan];
GRANT SELECT ALL USER SECURABLES TO [peliqan];

Configuration for specific data sources

Use Peliqan Satellite to sync data from your on-prem software, for example accounting software installed on your own computer.

Expert/M

Add a SQL Server user for Peliqan, on the SQL Server used by your Expert/M accounting software.

Enable the option “Sync all databases”, since Expert/M will create a separate DB for each end-customer (dossier).

Adsolut

Add a SQL Server user for Peliqan, on the SQL Server used by your Adsolut accounting software.

Enable the option “Sync all databases”, since Adsolut will create a separate DB for each end-customer (dossier).

Plenion

Add a SQL Server user for Peliqan, on the SQL Server used by your Plenion ERP software.

Other

Add a SQL Server user for Peliqan, on the SQL Server used by your on-prem software.

Limitations

• No incremental sync: the agent applies truncate & full resync on each run.
• Only SQL Server is supported as source (including DBs from on-prem accounting software and ERPs such as Expert/M, Adsolut, Plenion…).
• Only Postgres and Bigquery are supported as target data warehouse.
• No support for composite PKs in source tables.

Configuration

Follow the steps in the installation:

Configure a source database:

Configure a target datawarehouse (from your Peliqan account):

Configure settings:

View logs: