Login
Try for free
Request a demo

One-click data pipelines for AFAS to Elastic Search

Easily sync data from AFAS to Elastic Search, explore your data with the rich Data Explorer and transform your AFAS data with Magical SQL.

Try now for free

  • No credit card required
  •  5-minute setup
  • SOC 2 Type II certified

AFAS
Elastic Search

Instant ELT Pipeline & Data Warehouse Loading

Peliqan brings ETL pipelines, data transformations and reverse ETL together in one integrated platform. Connect your favorite BI tool and activate your data with SQL and low-code Python.

Direct to Warehouse Sync

Direct-to-Warehouse Sync

Sync AFAS data into Elastic Search with a few clicks. Or choose any other data warehouse or database as a destination.

Whitelabel Data warehouse

One Click Pipeline Setup

One-Click Pipeline Setup

Deploy production-ready ELT pipelines with automatic schema detection and incremental updates. Your AFAS data flows into Elastic Search continuously.

Data to BI

AI Driven Data Management 

AI-Driven Data Management 

Transform your data during sync with SQL or Python. Use AI to generate transformation logic from plain-English descriptions – clean, validate and enrich data before it lands in Elastic Search.

Data for AI agents

Multi Source Integration

Multi-Source Integration

Combine AFAS with 250+ other data sources in Elastic Search. Create unified datasets for analytics, reporting and machine learning – all in your centralized warehouse.

250+ connectors

Python SQL Processing

Python & SQL Processing

Run custom Python or SQL transformations on your AFAS data before loading into Elastic Search. Perfect for data checks, business logic, and complex transformations.

Build Data Apps

Reverse ETL & Orchestration

Reverse ETL & Orchestration

After processing your data in Elastic Search, sync enriched data back to AFAS or other systems (writeback). Complete the loop with bidirectional sync.

Activate your data

How to Connect AFAS and Elastic Search

Connect in 30 Seconds

Authenticate your source (AFAS)
via OAuth or API key – no complex setup.

Data Flows Automatically

Your data appears in the Peliqan data warehouse with automatic schema detection and optimization for analytics.

Or bring your own data warehouse (Snowflake, Redshift, Bigquery, Clickhouse, Fabric).

Query & Analyze

Use SQL, natural language queries, or the Peliqan data explorer and analyze your unified data.

Activate Insights

Connect your favorite BI tool to the Peliqan data warehouse, build Python apps, and sync insights back to your business applications.

Enable AI Agents

Turn on AI Agents (RAG and text-to-SQL) to answer business queries, generate SQL, or trigger downstream actions (e.g., create a CRM task).

Beyond Simple Sync

Incremental Pipelines

Efficiently sync only new & changed records from AFAS to Elastic Search using incremental loading strategies.

Schema Evolution Management

Automatically handle schema changes in AFAS – new fields, renamed columns, and type changes are detected and propagated to Elastic Search.

Data Quality & Validation

Built-in data quality checks ensure clean data in Elastic Search. Set validation rules, detect anomalies, and get alerts for data quality issues.

Enterprise Orchestration

Schedule complex workflows, dependencies, and multi-step pipelines. Use built-in orchestration capabilities.

Warehouse-Native Optimization

Leverage Elastic Search-specific features like partitioning, clustering, and materialized views for optimal query performance.

Developer Platform

REST APIs, Python SDK and a custom connector framework for advanced data engineering workflows.

Technical Specifications

Peliqan provides a high-performance ELT engine optimized for modern cloud data warehouses.
Load, transform and orchestrate data reliably with warehouse-native speed and security.

Supported Data Types

Protocols – REST, SOAP, SFTP, ODBC, JDBC etc.

Support for staging tables, external tables & native ingestion formats

Automatic schema evolution and change detection

Performance & Scale

Handles millions of records with distributed processing

Near real-time data sync for most object types

99.9% uptime SLA with redundant infrastructure

Security Features

End-to-end encryption in transit and at rest

VPN tunnel support and on-premises agents

Enterprise SSO integration available

SaaS Data Cockpit

Access, combine, and report on data from AFAS in Elastic Search and all your other SaaS apps. Gain valuable insights by bringing all your business data together in one place within minutes.

Explore the cockpit
SaaS Data Cockpit​

Technical Specifications

Peliqan brings ETL pipelines, data transformations and reverse ETL together in one integrated platform. Connect your favorite BI tool and activate your data with SQL and low-code Python.

Supported Data Types

All standard and custom objects types from AFAS

Custom field mapping and transformation rules

Automatic schema evolution and change detection

Performance & Scale

Handles millions of records with distributed processing

Near real-time data sync for most object types

99.9% uptime SLA with redundant infrastructure

Security Features

End-to-end encryption in transit and at rest                                                                                         

VPN tunnel support and on-premises agents

Enterprise SSO integration available

SaaS Data Cockpit

Access, combine, and report on data from AFAS in Elastic Search and all your other SaaS apps. Gain valuable insights by bringing all your business data together in one place within minutes.

Explore the cockpit
SaaS Data Cockpit

Unify, Automate & Activate Your Data 

Connect all your SaaS apps, databases, and spreadsheets into one workspace. Build automations, analytics pipelines, and data apps — all in one place.

Book a demo

G2 Badges

Peliqan is secure

 Here’s why founders, CIOs, and their IT teams trust us with their data.

SOC 2 Type II

SOC 2 Type 2 validates our security controls, ensuring your data is protected by independently audited security measures.

ISO 27001

ISO 27001 certification (in progress) ensures enterprise-grade information security, protecting your business with globally recognized standards.

GDPR

GDPR compliance guarantees EU data protection compliance, keeping PII data secure within EU boundaries.

Frequently Asked Questions

Can I connect multiple AFAS instances?

Yes, you can connect multiple instances of AFAS and unify the data, or you can customize field mappings for each connection.

You control the sync frequency. Choose from near real-time updates, every 15 minutes, hourly, daily, or custom schedules. Near real-time sync is available for most object types.

Peliqan handles enterprise-scale data volumes. Our distributed architecture processes millions of records efficiently with automatic scaling based on your needs.

Peliqan handles enterprise-scale data volumes. Our distributed architecture processes millions of records efficiently with automatic scaling based on your needs.

Our professional services team can build custom connectors and integrations. We also offer a 48-hour SLA for new connector development or you can build your own custom pipelines.

Peliqan data platform

All-in-one Data Platform

Built-in data warehouse, superior data activation capabilities, and AI-powered development assistance.

Ready to get instant access to all your company data ?

Start for free