What is Peliqan Satellite

On-prem agent

Peliqan Satellite is a Windows agent you install on an on-prem server. It reads data from an on-prem database (SQL Server, or anything reachable via ODBC) and copies it into your Peliqan data warehouse (Postgres or BigQuery). Once the data is there, you can use it for BI/reporting, MCP access to your business data, build Data Apps, publish APIs etc.

What are “pipelines” in Peliqan Satellite

Each pipeline is one source configuration → one target schema. You can run several pipelines side by side. One source configuation can capture data from one schema in one database or it can capture data from multiple databases. Use multiple pipelines if you have different source configurations or a different target configuration.

Preparing the source database(s)

Create a dedicated database user on the source DB server, with read-only access. Use e.g. “peliqan” as the username.

Preparing SQL Server

  1. Make sure TCP/IP is enabled in SQL Server.
  2. Use a SQL Server user for authentication, not Windows auth. The Peliqan Windows Service usually runs under a different account than the logged-in user, so Windows auth commonly fails for scheduled (background) syncs even though it works fine when testing from the UI.

Enabling access to multiple databases

If new databases can appear over time and you want the agent to pick them up automatically, grant access to all databases (including new databases that are added in the future):

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

CONNECT ANY DATABASE lets the agent connect to every database on the instance, present and future. SELECT ALL USER SECURABLES lets it read from every table/view it can connect to.

Installing the agent

  1. Download the installer: https://peliqan.io/winagent/latest/PeliqanSatellite-win-x64.msi
  2. Run it and follow the steps in the Windows installer.

After installing, you'll see 5 tabs: Source, Target, Settings, Logs, and Manage pipelines. Visit the tabs one by one to configure the agent.