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.
<aside> ☝ For an up to date list of all available connectors, visit https://peliqan.io/connectors
</aside>