Skip to main content

Peliqan

Data activation for Actian Zen

Activate your Actian Zen data: business alerts, custom reporting, publish data APIs, set up reverse ETL, automations & integrations with low-code Python.

HubSpot
Salesforce
Odoo
Shopify
QuickBooks
Stripe
Monday
Zendesk
Google Ads
300+ ETL connectors
Actian Zen logo

Actian Zen as your central data warehouse

About this connector

What is Actian Zen?


Actian Zen is a data destination used to centralize analytical workloads, separating storage from compute for scalable performance. It supports SQL-native exploration of large datasets and is the standard target for unified analytics. Peliqan loads Actian Zen from upstream business applications through 300+ managed ELT connectors with incremental syncs and schema management.

Why centralize on Actian Zen

Get more from your Actian Zen warehouse


  • Centralize SaaS, database, and file sources in Actian Zen through managed ELT connectors
  • Run governed SQL analytics across all business applications in one place
  • Build executive dashboards on top of Actian Zen with Power BI, Tableau, or Metabase
  • Power AI agents and Text-to-SQL on live Actian Zen data through MCP
  • Skip the cost and engineering overhead of building Airflow, ADF, or Glue pipelines

Instant pipelines for Actian Zen: ETL and reverse ETL

Sync data from 300+ SaaS business applications and databases into Actian Zen with a few clicks. 

Sync data from Actian Zen back into your business applications (reverse ETL). Prepare data for your favorite BI tool such as Microsoft Power BI, Tableau, Qlik Sense, Looker or Metabase.

Peliqan Fav Icon
Peliqan DW

Snowflake data warehouse
Snowflake

redshift
Redshift

Clickhouse
Clickhouse

MS Fabric
MS Fabric

Instant data warehouse

Spreadsheet UI and SQL for Actian Zen

Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool.

Use Peliqan’s built-in distributed query engine to combine data between sources, e.g. write between tables in Actian Zen and other external databases.

Spreadsheet UI

Visualize your Actian Zen data

Use your preferred BI tool (Power BI, Tableau, Metabase etc.) to visualize your Actian Zen data.

Deploy Metabase with a single click from the Peliqan Market Place and use Actian Zen in Metabase.

Sync with Google Sheets for easy data analysis from any source.

Connect your data to Microsoft Power BI
Power BI

Sync data to Metabase
Metabase

Tableau

Superset
Superset

Visualize

Visualize

Let AI do the work for you

Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.

Use Retrieval-Augmented Generation (RAG) for knowledge lookups and text-to-SQL for analytics. Deploy AI agents that can answer questions, produce SQL, or trigger actions.

SaaS Data Cockpit

Access, combine, and report on data from Actian Zen and all your SaaS apps instantly.
Gain valuable insights by bringing all your business data together in one place within minutes.

Connect 300+ SaaS business applications and databases to Actian Zen with 2-way connectors: ETL and reverse ETL

SlackSimplicate V3Google SheetsPlandayParseurWorkdayOneDriveBambooHRAproplan LetsbuildSharePoint Site (Client Credentials)mWorkerWhatsappMicrosoft TeamsGoogle DocsMicrosoft OutlookVitally.ioAllGravyZoho CreatorMicrosoft Outlook CalendarGoogle ChatLinearHIXNotion databaseMicrosoft PlannerJiraVisionPlannerQonicVisual PlanningCentric SoftwareHilti ON!TRACKFloatPaylogic ShoppingN11LightSpeed eComShopify V2MiraklFixformSFTPSuperagentOpenAISnapshot SourceFHIRArchisnapperLightSpeed Retail (R-Series)FDT SellusPeliqan Secret StorePostmanBloqs SoftwareKVK WriteBackMicrosoft EntraEmprovaSTRLucanetOverheid.ioMobilityPlus V1ImagekitWeFactZKRSMTP2GoClearfactsHammerTechBedrijfsdataAWSHorusCargosnapCashwebLeexiTrunkrsTwinfieldProfitPlus WebshopOdoo RESTTallyPipedriveIntercomCustomer.ioGoogle Analytics GA4Google AdsKlentyHubSpot AnalyticsFacebook AdsSprout SocialBolGoogle Play StoreMailchimpBrevoInstagramAttioSalesforce V2Mixpanel V2MS Dynamics 365 CRMApolloTypeformOdooMS Dynamics 365 Business Central (Private app)SAP S/4HANAMS Dynamics 365 Business CentralVisma Net (Visma.net)Visma BouwsoftMS Business Central Custom APIGrippRobawsAdminPulseCin7 CoreJD Edwards (JDE)ERPNextTOPDeskMS Business Central OData (on prem)PlenionDeltek WorkbookSoftTouchSAPExact OnlinePayPalVisma E-conomicPower OfficePower Office V2NetSuiteZoho InvoiceFortNoxBilltrust (iController)TripleTexBillitPontoTwikeyExact Online (Private app)PaddleSaltEdgeAdsolutOpentheboxExchangeRateOctopus OAuthExact VeniceTicketmasterHelpScoutStatusgatorZendeskGlobisHeylogHecny WMSGeoFleetOptioryxWialonPTV Route OptimiserRedshiftTrinoBigQueryClickHouseElastic SearchPostgresQdrantSAP SQL Anywhere (Sybase)PlanetScaleOracleGoogle Cloud StorageRedisIBM Cloudantd2o PMIMewsLighthouse Channel Manager (Cubilis)ApicbaseTideAsanaPimcoreAproplan v2MetabasePower BITableauAmazon QuickSightCareerPro FLA (RSZ)TandaNMBRS (Private App)OfficientLoxoSocial SecuritySprinter3000SlackSimplicate V3Google SheetsPlandayParseurWorkdayOneDriveBambooHRAproplan LetsbuildSharePoint Site (Client Credentials)mWorkerWhatsappMicrosoft TeamsGoogle DocsMicrosoft OutlookVitally.ioAllGravyZoho CreatorMicrosoft Outlook CalendarGoogle ChatLinearHIXNotion databaseMicrosoft PlannerJiraVisionPlannerQonicVisual PlanningCentric SoftwareHilti ON!TRACKFloatPaylogic ShoppingN11LightSpeed eComShopify V2MiraklFixformSFTPSuperagentOpenAISnapshot SourceFHIRArchisnapperLightSpeed Retail (R-Series)FDT SellusPeliqan Secret StorePostmanBloqs SoftwareKVK WriteBackMicrosoft EntraEmprovaSTRLucanetOverheid.ioMobilityPlus V1ImagekitWeFactZKRSMTP2GoClearfactsHammerTechBedrijfsdataAWSHorusCargosnapCashwebLeexiTrunkrsTwinfieldProfitPlus WebshopOdoo RESTTallyPipedriveIntercomCustomer.ioGoogle Analytics GA4Google AdsKlentyHubSpot AnalyticsFacebook AdsSprout SocialBolGoogle Play StoreMailchimpBrevoInstagramAttioSalesforce V2Mixpanel V2MS Dynamics 365 CRMApolloTypeformOdooMS Dynamics 365 Business Central (Private app)SAP S/4HANAMS Dynamics 365 Business CentralVisma Net (Visma.net)Visma BouwsoftMS Business Central Custom APIGrippRobawsAdminPulseCin7 CoreJD Edwards (JDE)ERPNextTOPDeskMS Business Central OData (on prem)PlenionDeltek WorkbookSoftTouchSAPExact OnlinePayPalVisma E-conomicPower OfficePower Office V2NetSuiteZoho InvoiceFortNoxBilltrust (iController)TripleTexBillitPontoTwikeyExact Online (Private app)PaddleSaltEdgeAdsolutOpentheboxExchangeRateOctopus OAuthExact VeniceTicketmasterHelpScoutStatusgatorZendeskGlobisHeylogHecny WMSGeoFleetOptioryxWialonPTV Route OptimiserRedshiftTrinoBigQueryClickHouseElastic SearchPostgresQdrantSAP SQL Anywhere (Sybase)PlanetScaleOracleGoogle Cloud StorageRedisIBM Cloudantd2o PMIMewsLighthouse Channel Manager (Cubilis)ApicbaseTideAsanaPimcoreAproplan v2MetabasePower BITableauAmazon QuickSightCareerPro FLA (RSZ)TandaNMBRS (Private App)OfficientLoxoSocial SecuritySprinter3000
TicketmaticBookboostMondayAirtableSimplicateGoogle DriveDropboxPostmarkSharePoint SiteExcel 365NotionGithubDoceboPostHogIonBizFileMakerGoogle GmailAircallGoogle CalendarGantticHarvestFirefliesGoogle Document AITrelloZoomLiteLLMAdminPulse API Keytele2EazyProjectTimelyShopifyBigcommerceSendCloudAdobe CommerceCommerce LayerMagentoOpen AssetWeather APIGeoCode APIMaterialize SourceMQTTApache AirflowZigguArchXGeoDynamicsRabbitMQUniconta (deprecated)UmangaQuickbooks OnlineKadasterSprinklrValid SignOneRoster 1.1ArenaWhozLansweeperOctopusWingsOpen WebUIENKIFS ERPcortecsDashlaneTelegramEfficyLemlistFishTalkTicketmatic (Private)ConneqtrVarbOpusFlowActiveCampaignSalesforceVoucherifyHubSpotMixpanelApple App StoreMailerliteKlaviyoZoho CRMLinkedin AdsGongHubSpot V2sugarCRMSaySimplePiwik ProGatsby.aiHello CustomerGoogle Business ProfileCustomer.io writebackRackbeatOdoo V2Unleashed ERPAFASWeclappTeamleader FocusTeamleader OrbitMagiclineTrimble ConnectWintreeAcumaticaiFix (GE Vernova)Cin7 OmniFurnqubeSysProCarfacUnicontaMS Business Central (Peliqan extension)IBM Db2 (AS/400)VincotteStripeXeroChargebeeBank TransactionsKlarnaMS Dynamics 365 Finance and Operations (AX)Norges Bank CurrenciesYukiVIES EU VAT validationBenchmarking AllianceZenvoicesBilltobox BanqupCreditSafeFixer.io currency exchange ratesFiscaal GemakSnelStartSilverfinCorpay OneFID-ManagerExpertMECB Exchange RatesPaylogic ReportingFreshdeskIntercom V2ServiceNowVerooStarshipitSolviceLobster Logistics CloudTraxGoShyppleMontaABAXMicrosoft Fabric DWHSnowflakeAWS S3MS SQL ServerMySQLMongoDBDynamoDB (AWS)SupabaseConvexAzure blob storageDuckDBSQLiteActian ZenShiji ReviewProElina PMSTravelperkeSmileyMidelcoAkeneoPlytixApache SupersetPower BI (private app)QlikLookerSD Worx AbsencesSimplePayQ7LeaderNMBRSSD Worx CobraBCSSD Worx BE PayrollTicketmaticBookboostMondayAirtableSimplicateGoogle DriveDropboxPostmarkSharePoint SiteExcel 365NotionGithubDoceboPostHogIonBizFileMakerGoogle GmailAircallGoogle CalendarGantticHarvestFirefliesGoogle Document AITrelloZoomLiteLLMAdminPulse API Keytele2EazyProjectTimelyShopifyBigcommerceSendCloudAdobe CommerceCommerce LayerMagentoOpen AssetWeather APIGeoCode APIMaterialize SourceMQTTApache AirflowZigguArchXGeoDynamicsRabbitMQUniconta (deprecated)UmangaQuickbooks OnlineKadasterSprinklrValid SignOneRoster 1.1ArenaWhozLansweeperOctopusWingsOpen WebUIENKIFS ERPcortecsDashlaneTelegramEfficyLemlistFishTalkTicketmatic (Private)ConneqtrVarbOpusFlowActiveCampaignSalesforceVoucherifyHubSpotMixpanelApple App StoreMailerliteKlaviyoZoho CRMLinkedin AdsGongHubSpot V2sugarCRMSaySimplePiwik ProGatsby.aiHello CustomerGoogle Business ProfileCustomer.io writebackRackbeatOdoo V2Unleashed ERPAFASWeclappTeamleader FocusTeamleader OrbitMagiclineTrimble ConnectWintreeAcumaticaiFix (GE Vernova)Cin7 OmniFurnqubeSysProCarfacUnicontaMS Business Central (Peliqan extension)IBM Db2 (AS/400)VincotteStripeXeroChargebeeBank TransactionsKlarnaMS Dynamics 365 Finance and Operations (AX)Norges Bank CurrenciesYukiVIES EU VAT validationBenchmarking AllianceZenvoicesBilltobox BanqupCreditSafeFixer.io currency exchange ratesFiscaal GemakSnelStartSilverfinCorpay OneFID-ManagerExpertMECB Exchange RatesPaylogic ReportingFreshdeskIntercom V2ServiceNowVerooStarshipitSolviceLobster Logistics CloudTraxGoShyppleMontaABAXMicrosoft Fabric DWHSnowflakeAWS S3MS SQL ServerMySQLMongoDBDynamoDB (AWS)SupabaseConvexAzure blob storageDuckDBSQLiteActian ZenShiji ReviewProElina PMSTravelperkeSmileyMidelcoAkeneoPlytixApache SupersetPower BI (private app)QlikLookerSD Worx AbsencesSimplePayQ7LeaderNMBRSSD Worx CobraBCSSD Worx BE Payroll

Beyond Simple Sync

A cloud data platform for everything you want to do with Actian Zen data after the sync.

Ad hoc analysis

Analyze your Actian Zen data with SQL or in a spreadsheet.

Self-service access

Enable business users with controlled self-service data access to Actian Zen.

Spreadsheet BI

Work with your Actian Zen data in a spreadsheet that is always up-to-date.

Dashboards

Create charts and visualize your Actian Zen data in dashboards.

Data verification

Create views for “human in the loop” processes when working with Actian Zen data.

Reporting

Build custom reports from Actian Zen in HTML, PDF…

Built with enterprise-grade security and compliance.

SOC 2 Type II
GDPR-compliant
HIPAA compliant
ISO 27001

G2 Badges 2026

Frequently asked questions

How does Peliqan load data into Actian Zen?

Peliqan provides 300+ managed ELT connectors that load data directly into Actian Zen with incremental syncs, automatic schema evolution, and managed credential rotation. There is no need to write Airflow DAGs, Azure Data Factory pipelines, or Glue jobs.

Connect a source in a few clicks, choose the tables you need, and Peliqan handles the rest. Initial backfills and ongoing incremental loads run on a schedule you control.

Which sources can I sync into Actian Zen with Peliqan?

Peliqan covers 300+ sources including CRM (Salesforce, HubSpot, Pipedrive), ERP (NetSuite, SAP, Odoo, Exact Online, AFAS), ecommerce (Shopify, WooCommerce, Magento), marketing tools, support platforms, databases, and files. Browse the full connector catalog to see every source available.

If a source is not yet supported, Peliqan offers a 2-week custom connector SLA so you are never blocked.

How often is data refreshed in Actian Zen?

Sync frequency is configurable per connector. The default is every 15 minutes on the Pro plan, with custom schedules and on-demand triggers available on higher tiers. Sync mode is incremental, so only new or changed records are pulled, which keeps source API usage low and costs predictable.

Can I push data out of Actian Zen to operational tools?

Yes. Peliqan’s reverse ETL pushes data from Actian Zen back into operational systems like Salesforce, HubSpot, Mailchimp, or Slack. Run flows on a schedule, on demand, or trigger them with SQL conditions. Read the reverse ETL documentation for setup details.

What can I build on top of Actian Zen once Peliqan is in place?

Once data lands in Actian Zen, you can run SQL queries, build dashboards in Power BI, Tableau, Metabase, or Looker, expose data to AI agents through MCP servers, build Text-to-SQL workflows, or trigger reverse ETL flows. Peliqan also includes a built-in spreadsheet UI for ad hoc analysis without writing SQL.

Is Actian Zen on Peliqan secure and GDPR compliant?

Peliqan is SOC 2 Type II certified, GDPR compliant, and ISO 27001 certified. Credentials are stored encrypted at rest, all transfers happen over TLS, and EU-resident data stays in EU infrastructure on the eu.peliqan.io region.

3 ways to load data into Actian Zen

Native Actian Zen loaders

  • COPY commands and bulk loaders for individual sources
  • No managed connectors for SaaS applications
  • Manual schema management for every table
  • No incremental sync, no built-in CDC
  • Reverse ETL requires a separate tool

Custom code with Airflow / ADF / Glue

  • Full control, but engineering-heavy to build
  • Must handle OAuth, retries, and rate limits per source
  • Schema changes break pipelines silently
  • Ongoing maintenance burden on your data team
  • Reverse ETL and AI access require separate tooling

Actian Zen on Peliqan

  • 300+ managed connectors, no code required
  • Incremental syncs and automatic schema evolution
  • Bidirectional writeback for reverse ETL
  • Built-in warehouse, BI, AI, and MCP in one platform
  • SOC 2 Type II, GDPR compliant, EU hosted

Request a Actian Zen demo →

Ready to see all your company data in one place?

Connect Actian Zen to the rest of your stack and build the reports, dashboards and AI workflows your team needs.