# Peliqan documentation

> Peliqan.io - the trust layer for AI.

- [Peliqan documentation](https://docs.peliqan.io/index.md): Peliqan is the Trust data layer for BI and AI. Get started with one-click ETL pipelines, magical SQL, low-code Python, and 300+ data connectors.
- [Overview and concepts](https://docs.peliqan.io/overview-and-concepts.md): Learn the core concepts of Peliqan, including data virtualization, the grid view, SQL on anything, data apps, and the built-in data warehouse.
- [ELT: Connect to data](https://docs.peliqan.io/connect-to-data.md): Learn how to add connections, sync data from databases and SaaS apps, understand connection statuses, and request new connectors in Peliqan.
- [Working with data in the Data Explorer](https://docs.peliqan.io/working-with-data-in-the-grid-view.md): Learn to view, sort, filter and edit data in Peliqan's Data Explorer, and understand the types of tables you can and cannot edit.
- [Data warehouse](https://docs.peliqan.io/data-warehouse-materialize-tables.md): Learn how Peliqan's built-in Postgres data warehouse works, how to connect your own data warehouse, and how to materialize SQL queries to tables.
- [Connect your BI, DB tool or iPaaS](https://docs.peliqan.io/connect-your-bi-or-db-tool.md): Connect Peliqan to BI tools, DB clients and iPaaS platforms using Postgres settings, and learn how to expose Peliqan SQL queries as views.
- [SSL certificates for the Peliqan data warehouse](https://docs.peliqan.io/connect-your-bi-or-db-tool/ssl-certificates-for-the-peliqan-data-warehouse.md): Download the root certificate and server certificate for your Peliqan data warehouse instance.
- [Excel (ODBC)](https://docs.peliqan.io/connect-your-bi-or-db-tool/excel-odbc.md): Use MS Query or Power Query in Excel to connect to the Peliqan data warehouse on Windows.
- [Excel add-in](https://docs.peliqan.io/excel-add-in.md): Install the Peliqan Excel add-in to pull real-time data from Peliqan tables and queries into Excel on Windows, Mac, and the web.
- [Permissions](https://docs.peliqan.io/permissions.md): Learn how Peliqan's permission model works across the UI, data warehouse, BI tools, data apps, and API endpoints.
- [Market place: install Metabase etc.](https://docs.peliqan.io/market-place.md): Discover how to install hosted data tools like Metabase with one click from the Peliqan market place.
- [Frequently asked questions](https://docs.peliqan.io/frequently-asked-questions.md): Get answers to common questions about Peliqan, including what it is, how connectors work, and how data storage and GDPR compliance are handled.
- [Feature list and Architecture](https://docs.peliqan.io/feature-list-roadmap-and-architecture.md): Explore Peliqan's complete feature list and microservices architecture deployed on Kubernetes, including federated queries, connectors, data apps, and more.
- [Platform status](https://docs.peliqan.io/platform-status.md): Monitor Peliqan's platform health, service availability and scheduled maintenance windows for EU and US instances.
- [Contact support](https://docs.peliqan.io/contact-support.md): Reach Peliqan support by email or through the helpdesk portal for assistance with your account and data projects.
- [SQL on anything](https://docs.peliqan.io/sql-on-anything.md): Use Peliqan’s SQL query editor to write SELECT queries on any data source, including JOINs and UNIONs, with support for Trino as a federated query engine.
- [Joining data](https://docs.peliqan.io/joining-data.md): Write JOIN queries in Peliqan to combine tables from the same or different sources using the built-in Trino federated query engine for cross-database joins.
- [Data transformations](https://docs.peliqan.io/data-transformations.md): Transform data in Peliqan using SQL queries or low-code Python to change formats, convert currencies, unify data, and prepare tables for joins and aggregations.
- [Metadata, Data models & Semantic models](https://docs.peliqan.io/metadata-data-model-semantic-model.md): Manage metadata, build business-ready data models, and create semantic models in Peliqan to provide context and expose data to AI agents and BI tools.
- [Materialize & Replicate](https://docs.peliqan.io/materialize.md): Replicate tables into the Peliqan data warehouse or materialize SQL queries into physical tables for improved performance and BI tool compatibility.
- [Data Lineage](https://docs.peliqan.io/data-lineage.md): Peliqan automatically generates lineage for tables and SQL queries, showing data provenance and downstream usage to help with impact analysis.
- [Reverse ETL](https://docs.peliqan.io/reverse-etl.md): Sync data from the Peliqan data warehouse back into business applications using the Reverse ETL app with field mapping, relations, scheduling, and custom code.
- [Data Mapper](https://docs.peliqan.io/data-mapper.md): This article explains how the Data Mapper (Data Mapping Manager) data app works and how to use it to enrich an existing data warehouse table with custom mapping columns.
- [IP whitelisting](https://docs.peliqan.io/ip-whitelisting.md): You can restrict access to your data warehouse, database or API by whitelisting IP addresses from Peliqan.
- [On-prem connectivity](https://docs.peliqan.io/on-prem-connectivity.md): Peliqan allows you to securely connect to on prem (on premise) data sources such as locally installed databases, on prem business applications and on prem servers using one of several methods.
- [Peliqan Satellite - Windows on-prem Data sync Agent](https://docs.peliqan.io/on-prem-connectivity/peliqan-satellite-windows-on-prem-data-sync-agent.md): Peliqan Satellite is a Windows agent you install on an on-prem server to copy data from SQL Server or ODBC sources into your Peliqan data warehouse.
- [NetBird VPN](https://docs.peliqan.io/on-prem-connectivity/netbird-vpn.md): Peliqan supports self-service activation of the NetBird VPN, a secure software-only VPN that establishes a peer to peer mesh connection between your on-prem server and the Peliqan data cloud.
- [Site-to-site IPSec VPN](https://docs.peliqan.io/on-prem-connectivity/site-to-site-ipsec-vpn.md): Peliqan supports connectivity to private clouds and on-prem environments through an IPSec site-to-site VPN, for example with a Fortigate VPN gateway.
- [Multi-customer management](https://docs.peliqan.io/multi-customer-management.md): If you are a SaaS company or a consultancy company and you use Peliqan to manage end-customer projects, you can use the multi-customer or multi-tenant features in Peliqan.
- [Manage sub accounts](https://docs.peliqan.io/manage-sub-accounts.md): Peliqan can be used by service providers, SaaS companies, consultants and ISV's to handle data projects from their end-customers. For each end-customer, a sub account is created under the Peliqan partner account.
- [Service models](https://docs.peliqan.io/whitelabel.md): Peliqan.io support different service models for ISVs, SaaS companies and consultants (Partners). Depending on your service model, you can choose between Whitelabel and Embedding.
- [Whitelabel](https://docs.peliqan.io/whitelabel/whitelabel.md): The Peliqan.io data platform is available as a white-labeled platform for SaaS companies, ISV's and consultants that wish to deliver data-centric services to their customers, under their own brand.
- [Partner API](https://docs.peliqan.io/whitelabel/partner-api-embed-api.md): The Peliqan Partner API is used by SaaS software companies and ISVs to integrate data solutions running on the Peliqan platform into their own platform.
- [Embedding](https://docs.peliqan.io/whitelabel/embedding.md): SaaS companies can embed Peliqan widgets into their own product, in order to offer a wide range of connectors inside their own SaaS platform.
- [Pipeline webhooks](https://docs.peliqan.io/pipeline-webhooks.md): You can configure webhooks from ELT pipelines running in Peliqan, to receive events when pipelines completed, failed etc.
- [pq Functions for partners](https://docs.peliqan.io/pq-functions-for-partners.md): This section describes how you can build automations in Peliqan to manage sub accounts from your end-customers using pq functions in low-code Python scripts.
- [Peliqan MCP Server](https://docs.peliqan.io/low-code-python-data-apps/by-protocol-rest-webhooks-mqtt/mcp-model-context-protocol/peliqan-mcp-server.md): Connect the Peliqan MCP Server to Claude, ChatGPT, Copilot and other AI clients to let AI assistants explore your data and manage your Peliqan account.
- [Build a custom AI client (harness) in Peliqan](https://docs.peliqan.io/build-ai-agents-in-peliqan.md): Build custom AI chatbots in Peliqan with Text-to-SQL, RAG search, MCP actions, and role-based permissions using Streamlit templates.
- [Build AI agents with n8n and Peliqan](https://docs.peliqan.io/build-ai-agents-with-n8n-and-peliqan.md): Use Peliqan as the unified data gateway for n8n AI agents with Text-to-SQL, RAG, and writeback actions via the Peliqan community node.
- [Build a custom MCP Server on Peliqan](https://docs.peliqan.io/low-code-python-data-apps/by-protocol-rest-webhooks-mqtt/mcp-model-context-protocol/build-a-remote-mcp-server-on-peliqan.md): Build a custom MCP Server in Peliqan by adding Python tools for Text-to-SQL, RAG, writeback, intent detection, and user-level permissions.
- [Implement RAG](https://docs.peliqan.io/build-ai-agents-in-peliqan/rag.md): Use Peliqan's RAG Manager to create embeddings from company data and perform similarity searches for AI chatbots and MCP servers.
- [For developers](https://docs.peliqan.io/for-developers.md): Developer resources for Peliqan: low-code Python Data Apps, vibe coded apps, row-level data access, publishing APIs, the REST API and incoming webhooks.
- [Data Apps - low code Python](https://docs.peliqan.io/data-apps.md): Learn how to build, run, and publish Python data apps in Peliqan using the built-in IDE, Streamlit UI, and scheduled or API-triggered execution modes.
- [Basics of data apps](https://docs.peliqan.io/low-code-python-data-apps/basics-of-data-apps.md): Learn how to create, write, and run your first data app in Peliqan using the built-in IDE, the pq module, and Streamlit for UI output.
- [Reading data from tables](https://docs.peliqan.io/low-code-python-data-apps/reading-data-from-tables.md): Learn how to fetch data from Peliqan tables into Python as objects or Pandas dataframes, iterate rows, and write SQL queries using PyPika.
- [Writing data to tables](https://docs.peliqan.io/low-code-python-data-apps/writing-data-to-tables.md): Learn how to insert, update, upsert, and write data to Peliqan tables using dbconn methods and ELT pipeline logic with automatic schema handling.
- [Running apps (manual, schedule etc.)](https://docs.peliqan.io/low-code-python-data-apps/running-apps-manual-schedule-etc.md): Learn how to run Peliqan data apps interactively, on a schedule, as API endpoints, or locally, and how to view and write logs for each run mode.
- [Publish & Embed apps](https://docs.peliqan.io/low-code-python-data-apps/publish-apps.md): Learn how to publish Peliqan data apps publicly, for Peliqan users only, or embedded in an intranet with session tokens and iframe integration.
- [Embed apps in Sharepoint](https://docs.peliqan.io/low-code-python-data-apps/publish-apps/embed-apps-in-sharepoint.md): Embed public Peliqan apps in SharePoint using the built-in Embed web part or a custom SPFx web part with session-based SSO.
- [Embed apps in Odoo](https://docs.peliqan.io/low-code-python-data-apps/publish-apps/embed-apps-in-odoo.md): Embed public Peliqan apps inside Odoo detail pages using the Peliqan iframe embed module and pass context via query parameters.
- [Adding a login to your app](https://docs.peliqan.io/low-code-python-data-apps/adding-login-to-your-app.md): Learn how to add authentication to your Peliqan Streamlit apps using the Secret Store, or implement Microsoft Azure Entra SSO with SAML.
- [Flows](https://docs.peliqan.io/low-code-python-data-apps/flows.md): Learn how to use Peliqan Flows to organize your Python code into visual blocks and build workflow-style data apps for your team.
- [Local development](https://docs.peliqan.io/low-code-python-data-apps/peliqan-python-client.md): Learn how to develop Peliqan Data Apps locally on your computer using the Peliqan pip module, including installation, Streamlit apps, the bundler, CI/CD deploy scripts, and sharing state with apps on Peliqan.
- [Available Python modules](https://docs.peliqan.io/low-code-python-data-apps/available-python-modules.md): Full list of Python modules and packages available for import in Peliqan Data Apps, including built-in library modules and third-party packages with key data and app development libraries.
- [Reference](https://docs.peliqan.io/low-code-python-data-apps/reference.md): Complete reference guide for building Peliqan Data apps using the pq module, covering data warehouse operations, Trino queries, writeback, SFTP, state management, metadata APIs, pipelines, secrets, refresh, sub accounts, and useful code snippets.
- [Data Visualization (Streamlit)](https://docs.peliqan.io/low-code-python-data-apps/data-visualization.md): Build visualizations in Peliqan using Streamlit charts, tables, and interactive components. Explore built-in line, bar, and Altair chart examples.
- [Interactive apps (Streamlit)](https://docs.peliqan.io/low-code-python-data-apps/interactive-apps.md): Build interactive apps with Streamlit in Peliqan, for example to search data, make updates to data, data entry, data quality checks etc.
- [Writeback to SaaS APIs](https://docs.peliqan.io/low-code-python-data-apps/writeback-reverse-etl-data-sync.md): Write data to SaaS APIs from Peliqan using single-line Python functions. Learn about retries, timeouts, and how to sync data back to HubSpot, Slack, and more.
- [Custom data syncs](https://docs.peliqan.io/low-code-python-data-apps/writeback-reverse-etl-data-sync/data-sync-and-data-imports.md): Build robust custom data syncs and Reverse ETL pipelines in Peliqan using low-code Python scripts. Learn incremental processing and upsert patterns.
- [Incremental processing from source](https://docs.peliqan.io/low-code-python-data-apps/writeback-reverse-etl-data-sync/incremental-processing.md): When you have a lot of records to sync from a source to a destination, you want to avoid processing all these records on each run of your scheduled script.
- [Alerting & messaging](https://docs.peliqan.io/low-code-python-data-apps/alerting-messaging.md): Alerting & messaging can be used to inform the right person at the right time with the right data.
- [Send alert to MS Teams](https://docs.peliqan.io/send-alert-to-msteams.md): Configure a Peliqan data app to send scheduled alerts to MS Teams based on query results. Use built-in templates to notify channels.
- [Send alerts to Slack](https://docs.peliqan.io/low-code-python-data-apps/predictions-machine-learning-templates/send-alerts-to-slack.md): Send Slack alerts when machine learning predictions exceed thresholds using Peliqan data apps. Configure real-time fraud and anomaly notifications.
- [Data enrichment](https://docs.peliqan.io/low-code-python-data-apps/data-enrichment.md): Enrich leads and customer data in Peliqan using 3rd party APIs like Clearbit, Hunter, weather, and geocoding. Use raw API calls for custom enrichment.
- [Reporting](https://docs.peliqan.io/low-code-python-data-apps/reporting.md): Generate custom PDF and Google Sheets reports from Peliqan data using low-code Python apps. Explore built-in spreadsheet UI and BI tool options.
- [Generate and distribute PDF reports](https://docs.peliqan.io/low-code-python-data-apps/reporting/generate-a-pdf-using-html.md): Generate PDF reports in Peliqan using HTML, download them via Streamlit, or distribute them by email using Postmark.
- [Working with files](https://docs.peliqan.io/low-code-python-data-apps/working-with-files.md): Read and write files in Peliqan using Python data apps. Support includes SFTP, S3, SharePoint, Dropbox, Google Drive, Excel, CSV, JSON, and Parquet.
- [Manual file upload & download](https://docs.peliqan.io/low-code-python-data-apps/working-with-files/manual-file-uploads.md): Streamlit apps in Peliqan can import Excel files into tables, upload files to AWS S3, and offer file downloads with Streamlit buttons.
- [Working with Parquet files](https://docs.peliqan.io/low-code-python-data-apps/working-with-files/working-with-parquet-files.md): Read Parquet files from an AWS S3 bucket and import them into the Peliqan data warehouse with a custom pipeline script.
- [ETL custom pipelines](https://docs.peliqan.io/low-code-python-data-apps/etl-custom-pipelines.md): Build custom ETL pipelines in Peliqan using low-code Python scripts to fetch data from sources, write to the data warehouse, and handle deleted rows or history tables.
- [Handling deleted rows](https://docs.peliqan.io/low-code-python-data-apps/etl-custom-pipelines/handling-deleted-rows.md): Learn how to handle rows that were deleted in the source system but still remain in your data warehouse.
- [Predictions, Machine Learning templates](https://docs.peliqan.io/low-code-python-data-apps/predictions-machine-learning-templates.md): Learn how to build and apply machine learning models in Peliqan for predictions, conversion scoring, churn detection, sentiment analysis, anomaly detection, and more.
- [Basic ML prediction example](https://docs.peliqan.io/low-code-python-data-apps/predictions-machine-learning-templates/basic-ml-prediction-example.md): Here’s a basic example of doing predictions using machine learning in Peliqan, using a low-code Python script. We are predicting if certain invoices will get paid (field “status”), based on historical data:
- [Lead Conversion](https://docs.peliqan.io/low-code-python-data-apps/predictions-machine-learning-templates/lead-conversion.md): Predict which leads have the most propensity to convert.
- [Churn Prediction](https://docs.peliqan.io/low-code-python-data-apps/predictions-machine-learning-templates/churn-prediction.md): Predict which customers are likely to cancel (churn) in order to proactively take measures to retain them.
- [Sentiment Analysis](https://docs.peliqan.io/low-code-python-data-apps/predictions-machine-learning-templates/sentiment-analysis.md): Classify customer reviews or support tickets as positive, negative, or neutral to analyze the satisfaction of customers.
- [Detect Anomalies - Fraud Detection](https://docs.peliqan.io/low-code-python-data-apps/predictions-machine-learning-templates/detect-anomalies-fraud-detection.md): Detect anomalies in your data.
- [Write predictions to a table](https://docs.peliqan.io/low-code-python-data-apps/predictions-machine-learning-templates/write-predictions-to-a-table.md): Add predictions to new data, using saved ML models and apply them to new records in a table on a scheduled basis.
- [Create an app for business users to get predictions](https://docs.peliqan.io/low-code-python-data-apps/predictions-machine-learning-templates/create-an-app-for-business-users-to-get-predictions.md): Create an interactive app for business users to consume an ML model in a simple and intuitive way, for example requesting a Churn prediction for one given customer.
- [Write predictions to a SaaS app](https://docs.peliqan.io/low-code-python-data-apps/predictions-machine-learning-templates/write-predictions-to-a-saas-app.md): Integrate predictive ML models with SaaS apps and update fields in your business applications such as Salesforce.
- [Synthetic data](https://docs.peliqan.io/low-code-python-data-apps/predictions-machine-learning-templates/synthetic-data.md): Here's an example of how to generate synthetic data based on real data using SDV for use in training ML models without exposing sensitive data.
- [Data quality, monitoring & contracts](https://docs.peliqan.io/low-code-python-data-apps/data-quality-monitoring.md): Set expectations for your data, implement data quality checks and data monitoring in Peliqan.
- [Data contracts](https://docs.peliqan.io/low-code-python-data-apps/data-contracts.md): Define the expected schemas in a data contract and test your datasets against defined contracts.
- [Working with metadata in scripts](https://docs.peliqan.io/low-code-python-data-apps/advanced.md): Access and update metadata such as table definitions, column lists, and descriptions in Peliqan using the pq Python functions list_databases, update_table, update_database, and update_field.
- [Generating UNION queries](https://docs.peliqan.io/low-code-python-data-apps/generating-union-queries.md): Combine multiple tables with matching columns into one dataset using UNION queries in Peliqan, either with a fixed list or generated dynamically across databases.
- [Generate Union Query](https://docs.peliqan.io/generate-union-query.md): Step-by-step guide to Peliqan's built-in union data app template for merging multi-connection datasets such as accounting data across companies into unified tables and views.
- [Sync data between parent & sub accounts](https://docs.peliqan.io/low-code-python-data-apps/sync-data-between-parent-sub-accounts.md): Sync tables between parent and sub accounts in Peliqan using a Python data app with interactive selection, state persistence, and scheduled execution.
- [By protocol (REST, Webhooks, MQTT…)](https://docs.peliqan.io/low-code-python-data-apps/by-protocol-rest-webhooks-mqtt.md): Learn how Peliqan supports REST APIs, webhooks, SFTP, and MQTT protocols for exchanging data and building data pipelines with low-code Python.
- [MQTT](https://docs.peliqan.io/low-code-python-data-apps/mqtt.md): Example script sending MQTT messages to a broker from Peliqan.
- [Slow changing dimensions (history tables)](https://docs.peliqan.io/low-code-python-data-apps/slow-changing-dimensions-history-tables.md): Implement SCD Type 2 history tables in Peliqan using Python scripts to track every version of a record, generate snapshots, changelogs, and reports.
- [Data masking / obfuscation](https://docs.peliqan.io/low-code-python-data-apps/data-masking-obfuscation.md): Learn how to obfuscate or mask sensitive data such as PII or PHI in Peliqan using the Obfuscate data template to support GDPR and HIPAA compliance.
- [Peliqan Machines - deploy vibe coded apps](https://docs.peliqan.io/vibe-coding-apps-peliqan-as-backend.md): Deploy vibe coded web apps on Peliqan Machines VMs with any framework, and use Peliqan as the backend for auth, databases, and APIs.
- [Row-level data access](https://docs.peliqan.io/permission-layer-for-ai-agents.md): Implement row-level permissions in Peliqan for Data Apps, AI Chatbots, and MCP Servers using views, CTEs, and role-based filtering.
- [Publish APIs](https://docs.peliqan.io/publish-apis.md): Define and publish custom API endpoints in Peliqan to share data with partners and customers using JWT authorization or public access.
- [Peliqan REST API](https://docs.peliqan.io/peliqan-api.md): Access the Peliqan REST API for your instance using JWT authentication in the Authorization header to list databases and applications.
- [Incoming webhooks](https://docs.peliqan.io/incoming-webhooks.md): Accept incoming webhook events from external systems in your Peliqan data warehouse, or capture them in real-time using API endpoints.
- [Connector guides: get started with each Peliqan connector](https://docs.peliqan.io/connectors.md): Browse Peliqan getting started guides per connector, from AdminPulse and AFAS to Exact Online, HubSpot, Odoo, Salesforce, Snowflake and many more.
- [AdminPulse - Getting started in Peliqan](https://docs.peliqan.io/adminpulse-getting-started-in-peliqan.md): Learn how to connect your AdminPulse account to Peliqan using OAuth to sync your office management data to the data warehouse.
- [Adsolut - Getting started in Peliqan](https://docs.peliqan.io/adsolut-getting-started-in-peliqan.md): Learn how to connect your Adsolut Wolters Kluwer accounting data to Peliqan using the Peliqan Satellite Windows data sync agent.
- [AFAS - Getting started in Peliqan](https://docs.peliqan.io/afas-getting-started-in-peliqan.md): Learn how to connect AFAS Profit to Peliqan using GetConnectors and an API token to sync finance, HR, payroll, CRM, and ERP data to the data warehouse.
- [Airtable - Getting started in Peliqan](https://docs.peliqan.io/connect-to-data/getting-started-with-airtable-in-peliqan.md): Learn how to connect Airtable to Peliqan using a Personal Access Token and Base ID to sync data and perform CRUD operations in the data warehouse.
- [Attio - Getting start in Peliqan](https://docs.peliqan.io/attio-getting-start-in-peliqan.md): Learn how to connect Attio CRM to Peliqan using OAuth to sync data to your data warehouse and perform federated queries.
- [AWS S3 - Getting started in Peliqan](https://docs.peliqan.io/low-code-python-data-apps/writeback-reverse-etl-data-sync/writeback-examples-per-connector/aws-s3.md): Learn how to import data from S3 buckets or export Peliqan data to S3 using Python and the boto3 library in low-code data pipelines.
- [Azure blob storage - Getting started in Peliqan](https://docs.peliqan.io/azure-blob-storage-getting-started-in-peliqan.md): Learn how to connect Azure Blob Storage to Peliqan using a SAS token and list or download files using Python scripts.
- [BambooHR - Getting started in Peliqan](https://docs.peliqan.io/connect-to-data/getting-started-with-bamboohr.md): Learn how to connect BambooHR to Peliqan using an API key and company domain to sync HR data and use data activation features.
- [Bank transactions - Getting started in Peliqan](https://docs.peliqan.io/bank-transactions-getting-started-in-peliqan.md): Learn how to connect your bank to Peliqan using supported bank connectors to sync transactions into your data warehouse.
- [BigQuery - Getting started in Peliqan](https://docs.peliqan.io/bigquery-getting-started-in-peliqan.md): Learn how to connect Google BigQuery to Peliqan as a data source or target data warehouse, including migration from the default Postgres DWH.
- [Billit Invoicing - Getting started in Peliqan](https://docs.peliqan.io/billit-invoicing-getting-started-in-peliqan.md): Learn how to connect Billit Invoicing to Peliqan using an API key to sync invoicing data to your data warehouse.
- [Bloqs Software - Getting started in Peliqan](https://docs.peliqan.io/bloqs-software-getting-started-in-peliqan.md): Learn how to connect Bloqs Software to Peliqan to sync client tracking and management data to your data warehouse.
- [CareerPro - Getting started in Peliqan](https://docs.peliqan.io/connect-to-data/getting-started-with-careerpro-fla-federal-learning-account-in-peliqan.md): Learn how to connect the Belgian Federal Learning Account (FLA) from CareerPro to Peliqan via Chaman to sync employee training data.
- [Convex - Getting started in Peliqan](https://docs.peliqan.io/convex-getting-started-in-peliqan.md): Learn how to sync data from Convex.dev to Peliqan using a custom Python pipeline with the Convex HTTP API.
- [CreditSafe - Getting started in Peliqan](https://docs.peliqan.io/creditsafe-getting-started-in-peliqan.md): Learn how to connect CreditSafe to Peliqan to fetch company credit reports and director information using data activation features.
- [Dropbox - Getting started in Peliqan](https://docs.peliqan.io/dropbox-getting-started-in-peliqan.md): Learn how to connect Dropbox to Peliqan to list, download, and upload files using Python scripts and data apps.
- [ENK – Getting started in Peliqan](https://docs.peliqan.io/enk-getting-started-in-peliqan.md): Learn how to connect the ENK Online RQS gateway to Peliqan, what tables are synced, and how to handle ENK gateway size limits and timeouts during data sync.
- [Exact Globe - Getting started in Peliqan](https://docs.peliqan.io/exact-globe-getting-started-in-peliqan.md): Set up the Exact Globe connector in Peliqan using the Peliqan Satellite Windows data sync agent to sync on-prem ERP data into your Peliqan data warehouse.
- [Exact Online - Getting started in Peliqan](https://docs.peliqan.io/connect-to-data/getting-started-with-exact-online-connector-in-peliqan.md): Connect Exact Online to Peliqan via OAuth or a private app, sync financial and ERP data to your warehouse, customize sync frequency, and troubleshoot common connection issues.
- [Exact Venice - Getting started in Peliqan](https://docs.peliqan.io/exact-venice-getting-started-in-peliqan.md): Sync Exact Venice accounting data into Peliqan using the Peliqan Satellite Windows data sync agent to connect to the Actian Zen database on your premises.
- [Expert/M - Getting started in Peliqan](https://docs.peliqan.io/expertm-getting-started-in-peliqan.md): Set up the Expert/M connector in Peliqan using the Peliqan Satellite Windows data sync agent to sync on-prem accounting data into your data warehouse.
- [Facebook Ads - Getting started in Peliqan](https://docs.peliqan.io/facebook-ads-getting-started-in-peliqan.md): Create a Meta developer app and system user token, then connect Facebook Ads to Peliqan to sync campaign and ad performance data into your data warehouse.
- [FileMaker - Getting started in Peliqan](https://docs.peliqan.io/filemaker-getting-started-in-peliqan.md): Connect your FileMaker database to Peliqan via the Claris FileMaker Data API using Peliqan support or a custom low-code Python pipeline script.
- [Fiscaal Gemak - Getting started in Peliqan](https://docs.peliqan.io/fiscaal-gemak-getting-started-in-peliqan.md): Connect Fiscaal Gemak to Peliqan using an API key, sync tax and financial data by year and declaration type, and explore it in your Peliqan data warehouse.
- [Fortnox - Getting started in Peliqan](https://docs.peliqan.io/fortnox-getting-started-in-peliqan.md): Connect Fortnox to Peliqan via OAuth, configure start date and table selection, then sync Swedish accounting data to your Peliqan data warehouse or external BI tools.
- [Freshdesk - Getting started in Peliqan](https://docs.peliqan.io/freshdesk-getting-started-in-peliqan.md): Connect Freshdesk to Peliqan with an API token, sync ticket and customer support data to your warehouse, and run federated queries to analyze helpdesk operations.
- [Github - Getting started in Peliqan](https://docs.peliqan.io/low-code-python-data-apps/writeback-reverse-etl-data-sync/writeback-examples-per-connector/github.md): Connect GitHub to Peliqan, sync file contents to your data warehouse, and use Python scripts for writeback, CI/CD, and automated commits between Peliqan and GitHub.
- [Google Analytics - Getting started in Peliqan](https://docs.peliqan.io/google-analytics-getting-started-in-peliqan.md): Sync Google Analytics GA4 data into Peliqan including events, traffic sources and user reports, then explore and analyze website performance in your data warehouse.
- [Google Calendar - Getting started in Peliqan](https://docs.peliqan.io/google-calendar-getting-started-in-peliqan.md): Connect Google Calendar to Peliqan to sync events into your data warehouse, and use data activation to create events or configure domain-wide delegation for multiple users.
- [Google Cloud Document AI - Getting started in Peliqan](https://docs.peliqan.io/google-cloud-document-ai-getting-started-in-peliqan.md): Set up the Google Cloud Document AI connector in Peliqan to process documents with OCR and extract structured data using custom pipeline scripts and GCP processors.
- [Google Docs - Getting started in Peliqan](https://docs.peliqan.io/google-docs-getting-started-in-peliqan.md): Connect Google Docs to Peliqan for writeback operations, then create, read, update, and delete documents programmatically using low-code Python scripts.
- [Google Drive - Getting Started in Peliqan](https://docs.peliqan.io/google-drive-getting-started-in-peliqan.md): Connect Google Drive to Peliqan by creating OAuth credentials in Google Cloud, sync file metadata to your data warehouse, and access files through Python data apps.
- [Google Sheets - Getting started in Peliqan](https://docs.peliqan.io/low-code-python-data-apps/writeback-reverse-etl-data-sync/writeback-examples-per-connector/google-sheets.md): Learn how to connect Google Sheets to Peliqan, sync data to your warehouse, and use low-code Python scripts for read, write, update, and batch operations.
- [HubSpot - Getting started in Peliqan](https://docs.peliqan.io/connect-to-data/hubspot.md): Connect HubSpot to Peliqan via OAuth to sync Contacts, Companies, Deals, and Contact lists into your data warehouse for exploration and activation.
- [IBM Db2 (AS/400) - Getting started in Peliqan](https://docs.peliqan.io/ibm-db2-as400-getting-started-in-peliqan.md): Learn how to connect IBM Db2 on IBM i (AS/400) to Peliqan by installing the ibm_db module and using a low-code Python data app to read data into your warehouse.
- [Instagram - Getting started in Peliqan](https://docs.peliqan.io/instagram-getting-started-in-peliqan.md): Connect your Instagram Business Account to Peliqan via Facebook Ads and a System User token with the required permissions for insights and engagement data.
- [ionBIZ - Getting started in Peliqan](https://docs.peliqan.io/ionbiz-getting-started-in-peliqan.md): Connect ionBIZ to Peliqan by creating an Application with OData scopes, and use low-code Python scripts to write back relations and other objects.
- [Lighthouse Channel Manager (Cubilis)](https://docs.peliqan.io/lighthouse-channel-manager-cubilis.md): Sync hotel reservation data from Lighthouse Channel Manager (formerly Cubilis) into Peliqan and use a custom Python pipeline to confirm receipt by clearing the queue.
- [LightSpeed Retail R-Series - Getting started in Peliqan](https://docs.peliqan.io/lightspeed-retail-r-series-getting-started-in-peliqan.md): Connect LightSpeed Retail R-Series to Peliqan via OAuth to sync your point-of-sale and inventory data into the built-in or your own data warehouse.
- [Linkedin Ads - Getting started in Peliqan](https://docs.peliqan.io/linkedin-ads-getting-started-in-peliqan.md): Connect LinkedIn Ads to Peliqan by providing your Organization ID and Account ID to sync campaign data for analysis and activation.
- [Lucanet - Getting started in Peliqan](https://docs.peliqan.io/lucanet-getting-started-in-peliqan.md): Sync Lucanet financial data into the Peliqan data warehouse using the Lucanet BI export app with a Postgres connection.
- [MS Dynamics 365 Business Central - Getting started in Peliqan](https://docs.peliqan.io/connect-to-data/microsoft-dynamics-365-business-central.md): Connect Microsoft Dynamics 365 Business Central to Peliqan using standard or private app connectors, and learn how to create an Azure app for authentication.
- [MS Business Central extension](https://docs.peliqan.io/connect-to-data/microsoft-dynamics-365-business-central/ms-business-central-extension.md): Install the Peliqan extension for Business Central and set up efficient data pipelines to sync data to your data warehouse.
- [MS Dynamics 365 Business Central - Custom API](https://docs.peliqan.io/microsoft-dynamics-365-business-central-custom-api-getting-started-in-peliqan.md): Get started with the MS Business Central Custom API connector in Peliqan to integrate Business Central data.
- [MS Dynamics 365 F&O - Getting started in Peliqan](https://docs.peliqan.io/microsoft-dynamics-365-project-operations-getting-started-in-peliqan.md): Connect Microsoft Dynamics 365 Finance & Operations to Peliqan by creating an Azure app, associating it with your environment, and syncing data with custom pipelines for bulk export.
- [Microsoft Excel 365 - Getting started in Peliqan](https://docs.peliqan.io/low-code-python-data-apps/writeback-reverse-etl-data-sync/writeback-examples-per-connector/microsoft-excel-365.md): Connect Microsoft Excel 365 to Peliqan, sync spreadsheet data to your warehouse, and use low-code Python to read, update, and sync tables with Sharepoint.
- [Microsoft Outlook - Getting started in Peliqan](https://docs.peliqan.io/microsoft-outlook-getting-started-in-peliqan.md): Connect Microsoft Outlook to Peliqan via OAuth and use low-code Python scripts to fetch emails, send messages with attachments, and send mail on behalf of others.
- [Microsoft Outlook Calendar - Getting started in Peliqan](https://docs.peliqan.io/microsoft-outlook-calendar-getting-started-in-peliqan.md): Connect Microsoft Outlook Calendar to Peliqan via OAuth to sync event data and use low-code Python scripts to create normal and online meeting events.
- [Microsoft Planner - Getting started in Peliqan](https://docs.peliqan.io/microsoft-planner-getting-started-in-peliqan.md): Connect Microsoft Planner to Peliqan via OAuth to sync tasks, buckets, and plans for project management data activation and analysis.
- [Microsoft Sharepoint - Getting started in Peliqan](https://docs.peliqan.io/sharepoint-getting-started-in-peliqan.md): Learn how to connect SharePoint to Peliqan, sync lists and files to your data warehouse, and use low-code Python for read, update, and upload operations.
- [Microsoft Teams - Getting started in Peliqan](https://docs.peliqan.io/connect-to-data/getting-started-with-microsoft-teams.md): Learn how to connect Microsoft Teams to Peliqan, discover Team, Channel and Chat IDs, and use low-code Python to send messages and create channels.
- [Monday - Getting started in peliqan](https://docs.peliqan.io/monday-getting-started-in-peliqan.md): Learn how to connect Monday.com to Peliqan using a personal API token, sync boards to your data warehouse, and filter which boards to include.
- [MongoDB - Getting started in Peliqan](https://docs.peliqan.io/connect-to-data/mongodb.md): Learn how to connect MongoDB to Peliqan, configure the required _schema collection for Trino SQL queries, and run a Python introspection script.
- [MySQL - Getting started in Peliqan](https://docs.peliqan.io/mysql-getting-started-in-peliqan.md): Learn how to connect a MySQL 8.x database to Peliqan as an external DB connection, configure users, permissions, and IP whitelisting.
- [Notion - Getting started in Peliqan](https://docs.peliqan.io/notion-getting-started-in-peliqan.md): Learn how to connect Notion to Peliqan using an internal integration, sync databases and pages to your data warehouse, and write back via Python.
- [Nmbrs - Getting started in Peliqan](https://docs.peliqan.io/nmbrs-getting-started-in-peliqan.md): Learn how to connect Nmbrs payroll and HR data to Peliqan using a Client login, authorize access, select tables, and troubleshoot common issues.
- [Odoo - Getting started in Peliqan](https://docs.peliqan.io/low-code-python-data-apps/writeback-reverse-etl-data-sync/odoo.md): Learn how to connect Odoo to Peliqan, sync standard and custom models, explore fields, and write back data using low-code Python scripts.
- [Officient - Getting started in Peliqan](https://docs.peliqan.io/officient-getting-started-in-peliqan.md): Learn how to connect Officient HR data to Peliqan by creating an OAuth app, authorizing access, and syncing people, contracts, and wages.
- [Oracle - Getting started in Peliqan](https://docs.peliqan.io/oracle-getting-started-in-peliqan.md): Learn how to connect an Oracle database to Peliqan using a custom Python pipeline script with the oracledb library and a service name DSN.
- [Pipedrive - Getting started in Peliqan](https://docs.peliqan.io/pipedrive-getting-started-in-peliqan.md): Learn how to connect Pipedrive to Peliqan with an API token, query deal stage timelines with SQL, and write back contacts using Python scripts.
- [Piwik - Getting started in Peliqan](https://docs.peliqan.io/piwik-getting-started-in-peliqan.md): Learn how to connect Piwik PRO to Peliqan using a Client ID and Secret, sync standard data, and use Python to sync custom report data.
- [Plenion - Getting started in Peliqan](https://docs.peliqan.io/plenion-getting-started-in-peliqan.md): Getting started guide for the Plenion connector in Peliqan. This guide is still being written; contact Peliqan support for help connecting Plenion.
- [Postgres - Getting started in Peliqan](https://docs.peliqan.io/postgres-getting-started-in-peliqan.md): Learn how to connect Postgres to Peliqan as an external database, configure SSL, create users, and grant schema and table permissions.
- [Postmark - Getting started in Peliqan](https://docs.peliqan.io/low-code-python-data-apps/writeback-reverse-etl-data-sync/postmark.md): Learn how to connect Postmark to Peliqan, send emails with attachments, and receive incoming emails using webhooks stored in your data warehouse.
- [Q7Leader - Getting started in Peliqan](https://docs.peliqan.io/q7leader-getting-started-in-peliqan.md): Q7Leader is a cloud-based HR intelligence platform that enables managers to create objective employee profiles in under 10 minutes.
- [Qonic - Getting started in Peliqan](https://docs.peliqan.io/qonic-getting-started-in-peliqan.md): Qonic is a cloud-based BIM modelling platform for the AEC industry (Architecture, Engineering, Construction).
- [Robaws - Getting started in Peliqan](https://docs.peliqan.io/robaws-getting-started-in-peliqan.md): This article provides an overview to get started with the Robaws connector in Peliqan.
- [Salesforce - Getting started in Peliqan](https://docs.peliqan.io/connect-to-data/getting-started-with-salesforce-in-peliqan.md): Learn how to connect Salesforce to Peliqan via OAuth, explore synced CRM data in your data warehouse, and write back using low-code Python scripts.
- [SAP - Getting started in Peliqan](https://docs.peliqan.io/sap-getting-started-in-peliqan.md): Learn how Peliqan connects to SAP S/4HANA, SuccessFactors, and other SAP products via OData APIs, and how to get your SAP data synced and ready for analysis.
- [Shopify - Getting started in Peliqan](https://docs.peliqan.io/shopify-getting-started-in-peliqan.md): Learn how to connect your Shopify store to Peliqan, sync e-commerce data to your data warehouse, and write back products, orders, and customers using Python.
- [Simplicate - Getting started in Peliqan](https://docs.peliqan.io/simplicate-getting-started-in-peliqan.md): Learn how to connect Simplicate to Peliqan using API credentials, sync CRM and project data to your warehouse, and use generic endpoints for custom data pipelines.
- [SFTP - Getting started in Peliqan](https://docs.peliqan.io/low-code-python-data-apps/writeback-reverse-etl-data-sync/writeback-examples-per-connector/sftp.md): Learn how to read and write files on an SFTP server from Peliqan, sync CSV data to your data warehouse, and use the built-in SFTP CSV Data Sync template.
- [Shiji ReviewPro - Getting started in Peliqan](https://docs.peliqan.io/shiji-reviewpro-getting-started-in-peliqan.md): Learn how to connect Shiji ReviewPro to Peliqan, sync hospitality review data to your warehouse, and build custom pipelines for ratings and review analytics.
- [Slack - Getting started in Peliqan](https://docs.peliqan.io/low-code-python-data-apps/writeback-reverse-etl-data-sync/writeback-examples-per-connector/slack.md): Learn how to connect Slack to Peliqan, send messages and data visualizations to channels, and share reports from your data warehouse with your team.
- [SD Worx - Getting started in in Peliqan](https://docs.peliqan.io/sd-worx-getting-started-in-in-peliqan.md): Learn how to connect SD Worx to Peliqan, sync employee and absence data to your data warehouse, and schedule a custom Python pipeline for nightly updates.
- [SMTP2Go - Getting started in Peliqan](https://docs.peliqan.io/smtp2go-getting-started-in-peliqan.md): Learn how to connect SMTP2Go to Peliqan using an API token and send emails or templated messages directly from your Python scripts.
- [SnelStart - Getting started in Peliqan](https://docs.peliqan.io/snelstart-getting-started-in-peliqan.md): Learn how to connect SnelStart to Peliqan using your developer credentials, sync Dutch accounting data to your warehouse, and explore the available tables.
- [Snowflake - Getting started in Peliqan](https://docs.peliqan.io/snowflake-getting-started-in-peliqan.md): Learn how to connect Snowflake to Peliqan as a data source or target warehouse, configure roles and keys, and set up secure key-pair authentication.
- [Stripe - Getting started in Peliqan](https://docs.peliqan.io/stripe-getting-started-in-peliqan.md): Learn how to connect Stripe to Peliqan using an API key, sync payment data, and build a custom pipeline to ingest Stripe Sigma analytics from AWS S3.
- [Supabase - Getting started in Peliqan](https://docs.peliqan.io/supabase-getting-started-in-peliqan.md): Learn how to connect your Supabase Postgres database to Peliqan using the Postgres connector and troubleshoot connection issues with the transaction pooler.
- [Sybase (SAP SQL Anywhere) - Getting started in Peliqan](https://docs.peliqan.io/sybase-sap-sql-anywhere-getting-started-in-peliqan.md): Learn how to sync data from a Sybase (SAP SQL Anywhere) database to your Peliqan data warehouse using a custom Python pipeline with incremental bookmark support.
- [Teamleader Focus - Getting started in Peliqan](https://docs.peliqan.io/connect-to-data/getting-started-with-teamleader-in-peliqan.md): Connect Teamleader Focus to Peliqan to sync CRM, project, and invoicing data into your data warehouse. Use Python scripts to activate the data via the Teamleader API.
- [Teamleader Orbit - Getting started in Peliqan](https://docs.peliqan.io/getting-started-with-teamleader-orbit.md): Get started with Teamleader Orbit in Peliqan to sync your marketing agency reports to Peliqan's data warehouse for analysis and transformation.
- [Telegram - Getting started in Peliqan](https://docs.peliqan.io/telegram-getting-started-in-peliqan.md): Send Telegram messages and build chatbots in Peliqan using low-code Python scripts. Connect with BotFather and configure webhooks to receive incoming messages.
- [Trello - Getting started in Peliqan](https://docs.peliqan.io/trello-getting-started-in-peliqan.md): Connect Trello to Peliqan to sync your boards, lists, and cards into your data warehouse. Generate an API key and token in Trello and add them to Peliqan.
- [Twinfield - Getting started in Peliqan](https://docs.peliqan.io/twinfield-getting-started-in-peliqan.md): Sync your Twinfield accounting data to Peliqan with OAuth. Register an application, connect, and sync offices, customers, suppliers, GL accounts, and transactions.
- [Uniconta - Getting started in Peliqan](https://docs.peliqan.io/uniconta-getting-started-in-peliqan.md): Connect Uniconta to Peliqan using a server user to sync ERP data. Add custom tables and write back invoices, customers, and more with low-code Python scripts.
- [Visma Bouwsoft - Getting started in Peliqan](https://docs.peliqan.io/visma-bouwsoft-getting-started-in-peliqan.md): Connect Visma Bouwsoft to Peliqan using OAuth authorization. Get a Request ID from Peliqan support, authenticate with Bouwsoft, and sync your construction company data to Peliqan.
- [Visma Net - Getting started in Peliqan](https://docs.peliqan.io/vismanet-getting-started.md): Connect Visma Net to Peliqan by activating the Visma App Store, adding the Integration Administrator role, and installing the Peliqan app using an invitation code from Peliqan support.
- [Visual Planning - Getting started in Peliqan](https://docs.peliqan.io/visual-planning-getting-started-in-peliqan.md): Sync your Visual Planning dimensions and project data to Peliqan with automatic schema discovery. Configure incremental sync and explore your planner data in the data warehouse.
- [Weclapp - Getting started in Peliqan](https://docs.peliqan.io/weclapp-getting-started-in-peliqan.md): Connect Weclapp to Peliqan using an API token and tenant URL. Sync your ERP data into Peliqan and write back records and custom attributes using low-code Python scripts.
- [Whatsapp - Getting started in Peliqan](https://docs.peliqan.io/low-code-python-data-apps/writeback-reverse-etl-data-sync/writeback-examples-per-connector/whatsapp.md): Send WhatsApp messages and build chatbots in Peliqan using WABA templates, text messages, and webhooks. Set up a Meta app and connect to Peliqan for bidirectional messaging.
- [Workday - Getting started in Peliqan](https://docs.peliqan.io/workday-getting-started-in-peliqan.md): Connect Workday to Peliqan using OAuth authorization. Create an API client in Workday, sync reports via WQL queries, and load the data into Peliqan's data warehouse with custom pipeline scripts.
- [Yuki - Getting started in Peliqan](https://docs.peliqan.io/yuki-getting-started-in-peliqan.md): Connect Yuki accounting data to Peliqan using an API key. Find your administration ID and API key in Yuki, enter them in Peliqan, and start syncing financial data.
- [Zenvoices - Getting started in Peliqan](https://docs.peliqan.io/zenvoices-getting-started-in-peliqan.md): Connect Zenvoices to Peliqan using your username, password, and tenancy name. Sync invoice processing data to Peliqan's data warehouse for analysis and reporting.
- [Zoho Creator - Getting started in Peliqan](https://docs.peliqan.io/zoho-creator-getting-started-in-peliqan.md): Connect Zoho Creator low-code applications to Peliqan using OAuth. Sync form data from custom reports to Peliqan and use Python scripts to read, create, and update records.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.