Learn how to seamlessly integrate your external databases, such as SQL Server, with Peliqan. This video guides you through connecting source databases and business applications (like Pipedrive and Odoo), understanding the real-time connection, and setting up automatic data replication and materialization into your Peliqan data warehouse.
What you will learn:
– Connecting Sources: How to add connections to both business/SaaS applications (with auto-sync ELT pipelines) and source databases.
– Real-time Access: How Peliqan fetches data directly from your source database in real-time when you explore tables or write queries.
– Data Replication: Step-by-step process to activate table replication, configure the run interval (e.g., every 24 hours), and enable incremental replication for faster updates.
– Query Materialization: How to materialize your ephemeral SQL queries as physical tables or views in the data warehouse, making them visible to BI tools like Microsoft Power BI.
Transform your data strategy by making external database data available and up-to-date in your central Peliqan data warehouse!