Peliqan provides direct data access to a wide range of data sources.

In Peliqan, go to Connections and add a new connection. Select the connection type and enter the required credentials or complete the oAuth flow.

After adding a connection, Peliqan will automatically set up a data pipeline and start syncing data and/or do schema discovery. This process can take anywhere between a few seconds and a few minutes. You will automatically see the database and its tables appear in the left pane under “Explore” in Peliqan. Click on a table to open it and view the data.

For databases:

Once the connection is added, Peliqan will automatically start doing schema discovery on the connection. This means it will make a list of all the databases, per database all the schemas, per schema all the tables, and per table all the columns. Peliqan will also capture sample data etc.

Note that Peliqan does not replicate your DB data. Instead you can use the built-in distributed query engine to combine data across sources.

For SaaS applications:

For SaaS connections, Peliqan will replicate your data into the built-in Peliqan data warehouse or a data warehouse of your choice (Snowflake, BigQuery etc.).

Peliqan will create one table per object type. For example for a CRM such as Hubspot, you will see tables appearing such as Contacts, Companies, Deals etc. as well as “child tables” for e.g. the Phone numbers of Contacts.

Other DB’s, DW’s and DL’s are available on request, see below.

For databases, data warehouses and data lakes, Peliqan will fetch the data in real-time when a table is opened or used in e.g. a data app. Peliqan does not store a copy of the data, except when you materialize a table in Peliqan.

Other SaaS connectors are available on request, see below.

For SaaS business applications, Peliqan will set up a data pipeline automatically when you add a connection, and it will start syncing the data from the SaaS application into the built-in data warehouse. The sync is incremental where possible, the interval can be viewed under Connections.

Peliqan offers an agent that can be installed on-prem to sync data to a data warehouse in the cloud. Peliqan also offers a private cloud option that is deployed inside your own cloud and allows you to connect to internal resources in the same cloud. Contact Peliqan sales for more information on our on-prem agent and our private cloud offering.

The Peliqan connector team will add new connectors in 2 business days at a fixed low one-time setup price. Contact support for more details.

For databases:

Please provide the name of the database system you want to connect, optionally including a test account.

For SaaS sources:

Peliqan can work with any type of API (REST, SOAP Webservices, GraphQL etc.). Please provide following details if possible in your connector request:

You can verify the status of your connections under “Connections” in Peliqan.

Use this when you don’t want to wait for the next scheduled sync to pull in new SaaS data.

Use this when you want to update to the latest version of a connector (which supports e.g. more tables) or you want to resync all data. A full resync will also make sure that records that were deleted in the source are no longer present in the target data warehouse.

There is no target for DB connections, because Peliqan will access external DBs directly without the need to replicate the data. Use Peliqan’s built-in Trino query engine to combine data from multiple sources.

Use this when the schema changed in the connected DB, e.g. new tables or columns were added. By doing a “Sync”, you will see the new tables or columns appear in Peliqan.