Gaio DataOS
Gaio DataOS
Gaio DataOS
  • 👋 Welcome to Gaio DataOS
  • GETTING STARTED
    • Gaio DataOS Console
    • Quickstart
  • FUNDAMENTALS
    • Data Projects
    • Studio
    • Database
    • Workflow
  • Data Sources
  • TASKS
    • ETL
      • Builder
      • SQL
      • Source SQL
      • Insert Table
      • Insert Row
      • Update
      • Delete
      • Create Table
      • Quick Table
      • Quick Upload
      • Pivot Table
      • Unpivot Table
      • REST
      • Parameters to Table
      • Table to Parameters
      • Define parameter value
      • Users
      • CSV Web
      • CSV Local
      • Google Spreadsheet
    • Analytics
      • Sample
      • Cluster
      • Principal Components
      • Association Rules
      • Forecast
      • Python
    • Delivery
      • Content
      • Form Card
      • Export CSV
    • Map Editor
Powered by GitBook
On this page
  • Data Sources in Gaio DataOS
  • Direct Database Connections
  • API Connections via REST
  • Cloud Storage Integrations
  • Why This Matters

Data Sources

Data Sources in Gaio DataOS

Gaio DataOS was designed to integrate and transform data from multiple sources — from traditional databases to modern cloud-based services. This flexibility allows organizations of all sizes to centralize their information in a single environment for analysis and automation.

Direct Database Connections

Gaio easily connects to a wide variety of database management systems (DBMS), enabling real-time operations, automations, complex queries, and intelligent data pipelines.

Supported databases:

  • MySQL

  • PostgreSQL

  • ClickHouse

  • SQL Server

  • MariaDB

  • MemSQL

  • Amazon Redshift

  • Snowflake

  • Oracle

  • Databricks

  • Salesforce

These connections provide direct access to tables, which can be queried using SQL, visualized in dashboards, or used as the foundation for transformation flows and machine learning models.

API Connections via REST

In addition to database connections, Gaio offers a powerful task called REST, which allows integration with external data through APIs.

With this feature, you can:

  • Connect to enterprise services like Hubspot, ERPs, and CRMs

  • Retrieve data from public or internal APIs

  • Build automated pipelines from JSON responses

  • Send dynamic parameters and configure headers, tokens, and authentication

This makes Gaio a true integration hub, capable of receiving and processing data from virtually any API-enabled source.

Cloud Storage Integrations

Gaio also supports connecting to cloud storage systems, allowing users to work directly with files and objects stored in:

  • Amazon S3

  • Azure Blob

  • Google Drive (via REST)

  • Google Sheets (via native Studio feature)

Why This Matters

Having multiple integration options makes Gaio ideal for:

  • Unifying data scattered across different systems

  • Automating real-time data updates

  • Building Business Intelligence and Machine Learning solutions based on consistent, up-to-date data

  • Reducing dependency on external ETL or integration tools

At its core, Gaio DataOS is a connected environment, ready to integrate with your entire data ecosystem — whether through databases, cloud storage, or APIs.

PreviousWorkflowNextETL

Last updated 5 days ago

Access to Settings
Settings Page
REST