Skip to content

Fracttal ETL Hub Documentation

Welcome to the complete documentation of the Fracttal ETL Hub, an advanced data integration platform that enables efficient and scalable connection between multiple enterprise systems.

What is Fracttal ETL Hub?

Fracttal ETL Hub is an ETL (Extract, Transform, Load) solution based on JSON configurations that implements the JSON-RPC 2.0 protocol. The platform offers:

  • 18+ native connection types to enterprise systems
  • 40+ transformation operators based on JSON Logic
  • Dynamic event system for complex workflows
  • Orchestration with Apache Airflow 2.9.3
  • Automatic validation of configurations

Quick Guide

1. Getting Started

2. Available Connections

Explore all supported connections organized by category:

  • Database: SQL Server, MySQL, PostgreSQL, Oracle
  • Cloud: AWS, Azure, Google Cloud
  • Communication: Email, SMS, WhatsApp
  • Management: JIRA, Trello
  • APIs: HTTP/REST, SOAP, Fracttal API
  • Files: Google Sheets, Google Docs

3. Transformations

API Reference

Examples

Basic ETL

{
  "id": "uuid-1",
  "jsonrpc": "2.0",
  "method": "etl.etl_update",
  "params": {
    "id": "uuid-2",
    "config": {
      "source": {
        "connection": {"id_type": 1, "name": "Database"},
        "operation": "list_table",
        "parameters": {"table": "users"}
      },
      "transform": {
        "rename": [
          [{"var": "name"}, "full_name", "string"]
        ]
      },
      "target": {
        "connection": {"id_type": 3, "name": "Google Sheets"},
        "operation": "append",
        "parameters": {"spreadsheet_id": "123456"}
      }
    },
    "environment": "production"
  }
}

Support

Quick Tips

  • Use the search bar to find specific connections
  • All configurations follow the JSON-RPC 2.0 schema
  • Valid environments are production and develop
  • UUIDs must be unique per configuration

Important

Remember to validate all configurations before deploying to production.