Peliqan has a built-in data warehouse, based on Postgres. By default the built-in data warehouse will be used, for example when you add a connection to a SaaS application.
When you add a SaaS connection, Peliqan will set up an ETL pipeline and it will start syncing data from your SaaS application into the data warehouse. Peliqan will create a schema per SaaS connection, for example a schema “hubspot” when you connect Hubspot (CRM). A schema is a logical grouping of tables, it’s like a folder under a database.
You can also add a connection to your existing data warehouse. Peliqan supports following data warehouses as target for ETL pipelines:
If you want to connect to Peliqan’s built-in data warehouse, go to Connections in Peliqan, find the Data Warehouse card and copy paste all connection details.
More info:
In order to connect an external data warehouse: in Peliqan, go to Connections and click on Add Connection. Find your data warehouse in the list, for example SQL Server. Add connection details, and make sure to fill in the Target Database name. This will turn the connection into a target data warehouse.
