# 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="/files/3ejFfucpUyFmEx1RpxiU" alt=""><figcaption><p>Access to Settings</p></figcaption></figure>

<figure><img src="/files/JTm1B8gpc18kfl002pJl" 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="/files/P2mU87DUJD3jiWq63XJN" 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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.gaiodataos.com/fundamentals/data-sources.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.