# 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.

<figure><img src="https://1671598980-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0muDd0LkZG6CmTQvGQ4D%2Fuploads%2FyQ82X9cuRy8i8Y7uW9Qs%2FCleanShot%202025-06-02%20at%2010.19.14.png?alt=media&#x26;token=4abb66db-9fd0-4ad6-b421-11eb5e62512d" alt=""><figcaption><p>Access to Settings</p></figcaption></figure>

<figure><img src="https://1671598980-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0muDd0LkZG6CmTQvGQ4D%2Fuploads%2FIduIoeUV5UoLi5dgF8z0%2FCleanShot%202025-06-02%20at%2010.20.31.png?alt=media&#x26;token=67dbfe62-93b7-4ba2-8dcc-84f37f556326" alt=""><figcaption><p>Settings Page</p></figcaption></figure>

***

### 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.

<figure><img src="https://1671598980-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0muDd0LkZG6CmTQvGQ4D%2Fuploads%2FCwb2pY7TIq09rhADhDvn%2Fimage.png?alt=media&#x26;token=751ce671-07c4-4334-b790-4eb67b5390c9" alt=""><figcaption><p>REST</p></figcaption></figure>

***

### 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.
