Peliqan Satellite is used to connect on-prem business applications and databases to the Peliqan data cloud. 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. Once the data is synced, you can use it for BI/reporting, MCP access to your business data, to build Data Apps and publish APIs.

• Installation
• How to use
• Configuration for specific data sources
• Expert/M
• Adsolut
• Plenion
• Other
• Limitations
• Configuration
• Follow the steps in the installer
• Configure the Source
• Configure the Target
• Configure settings
• View logs
• FAQ

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];

CONNECT ANY DATABASE lets Peliqan Satellite connect to every database on the SQL Server instance, present and future. SELECT ALL USER SECURABLES lets Peliqan Satellite select from all tables/views in any database it can connect to.

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” and “Merge all source tables based on name” 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” and “Merge all source tables based on name” 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 installer

Once the installation completed, configure Source, Target and Settings.

Configure the Source

Enter the details to connect to your on-prem SQL Server. Make sure to create a SQL user first for Peliqan.

Configure the Target

Configure a target data warehouse from your Peliqan account).

Get all details from your data warehouse from the connection card in your Peliqan account under Connections. Example:

Example for a Postgres DWH:

Example for a Bigquery DWH:

Configure settings

View logs

FAQ

What are alternatives for on-prem connectivity ?

You can also use a VPN connection.

Can Peliqan Satellite write to the on-prem database ?

No, only read data and send that data to the Peliqan cloud data warehouse.

Do I need to open my firewall ?

You only have to make sure that the agent can make an outbound database connection to the Peliqan cloud (Postgres or Bigquery data warehouse). No inbound connections are needed from the public internet to your on prem environment.

Can Peliqan Satellite create conflicts with other database users (e.g. backup software) ?

No, Peliqan Satellite will only read data using “SELECT” queries, and it will not create locks on tables.