# Source System Integrations

A major component of Lumi AI is the ability to connect, define, and process data from structured sources. As a result, Lumi AI offers integration to many of the most popular source systems and protocols available to get you connected with your data.

## Properties

Each system comes with supported secondary functions and features:

* **Status**: Indicates the availability of the system as a connection option
  * *Available: Is available for all license/plan tiers*
  * *Enterprise only: Is available for Enterprise plans only*
  * *Private Preview: Is available for select customers in testing / upon request*
* **Connection Methods:** Sources can be connected in one of two ways
  * *Direct: The default method, with a direct and secure over-the-internet connection*
  * *Gateway: An alternative method using a Lumi AI purpose-built agent to mediate connections from the edge of the network (see* [*Data Gateway*](https://docs.lumi-ai.com/product-features/data-gateway) *to learn more)*
* **Controls**: Mechanisms to restrict or throttle connections and their impact to the source system (see [Query Constraints](https://docs.lumi-ai.com/using-lumi/limitations/query-constraints) and [Organization Profile](https://docs.lumi-ai.com/product-features/organization-settings/organization-profile) for more information and settings); not all mechanisms are supported by all systems
  * *Cost: Prevents high estimated compute-cost queries from running before they start*
  * *Duration: Stops long-running queries at a specific threshold*

{% hint style="info" %}
Note:

* To be enrolled as part of a "Private Preview", please reach out to <support@lumi-ai.com>.
* Gateways and gateway connections are only available for Enterprise plans.
  {% endhint %}

## Supported Systems

Click on any to learn more.

<table data-view="cards"><thead><tr><th>System</th><th>Connection Methods<select multiple><option value="N9AjoAQJwHgP" label="Gateway" color="blue"></option><option value="FznRCDPNTcm2" label="Direct" color="blue"></option></select></th><th>Status<select><option value="KhcHckEkAcIv" label="Private Preview" color="blue"></option><option value="9iVHJkUAjXzN" label="Available" color="blue"></option></select></th><th>Controls<select multiple><option value="INYUex9sjSeT" label="Cost" color="blue"></option><option value="q8ITGZ3mmq6Z" label="Duration" color="blue"></option></select></th><th data-hidden data-card-target data-type="content-ref"></th><th data-hidden data-type="content-ref"></th></tr></thead><tbody><tr><td>PostgreSQL</td><td><span data-option="FznRCDPNTcm2">Direct, </span><span data-option="N9AjoAQJwHgP">Gateway</span></td><td><span data-option="9iVHJkUAjXzN">Available</span></td><td><span data-option="INYUex9sjSeT">Cost, </span><span data-option="q8ITGZ3mmq6Z">Duration</span></td><td><a href="source-system-integrations/postgresql">postgresql</a></td><td><a href="source-system-integrations/postgresql">postgresql</a></td></tr><tr><td>Microsoft SQL Server</td><td><span data-option="FznRCDPNTcm2">Direct, </span><span data-option="N9AjoAQJwHgP">Gateway</span></td><td><span data-option="9iVHJkUAjXzN">Available</span></td><td><span data-option="INYUex9sjSeT">Cost</span></td><td><a href="source-system-integrations/microsoft-sql-server">microsoft-sql-server</a></td><td><a href="source-system-integrations/microsoft-sql-server">microsoft-sql-server</a></td></tr><tr><td>MySQL</td><td><span data-option="FznRCDPNTcm2">Direct, </span><span data-option="N9AjoAQJwHgP">Gateway</span></td><td><span data-option="9iVHJkUAjXzN">Available</span></td><td><span data-option="q8ITGZ3mmq6Z">Duration</span></td><td><a href="source-system-integrations/mysql">mysql</a></td><td><a href="source-system-integrations/mysql">mysql</a></td></tr><tr><td>Databricks</td><td><span data-option="FznRCDPNTcm2">Direct, </span><span data-option="N9AjoAQJwHgP">Gateway</span></td><td><span data-option="KhcHckEkAcIv">Private Preview</span></td><td></td><td><a href="source-system-integrations/databricks">databricks</a></td><td></td></tr><tr><td>BigQuery</td><td><span data-option="FznRCDPNTcm2">Direct</span></td><td><span data-option="9iVHJkUAjXzN">Available</span></td><td><span data-option="INYUex9sjSeT">Cost</span></td><td><a href="source-system-integrations/bigquery">bigquery</a></td><td></td></tr><tr><td>Snowflake</td><td><span data-option="FznRCDPNTcm2">Direct, </span><span data-option="N9AjoAQJwHgP">Gateway</span></td><td><span data-option="9iVHJkUAjXzN">Available</span></td><td><span data-option="q8ITGZ3mmq6Z">Duration</span></td><td><a href="source-system-integrations/snowflake">snowflake</a></td><td></td></tr><tr><td>SAP HANA</td><td><span data-option="N9AjoAQJwHgP">Gateway</span></td><td><span data-option="9iVHJkUAjXzN">Available</span></td><td></td><td><a href="source-system-integrations/sap-hana">sap-hana</a></td><td></td></tr><tr><td>Oracle</td><td><span data-option="FznRCDPNTcm2">Direct</span></td><td><span data-option="9iVHJkUAjXzN">Available</span></td><td><span data-option="INYUex9sjSeT">Cost</span></td><td><a href="source-system-integrations/oracle">oracle</a></td><td></td></tr><tr><td>AWS Athena</td><td><span data-option="FznRCDPNTcm2">Direct</span></td><td><span data-option="KhcHckEkAcIv">Private Preview</span></td><td></td><td></td><td></td></tr><tr><td>RedShift</td><td><span data-option="FznRCDPNTcm2">Direct</span></td><td><span data-option="KhcHckEkAcIv">Private Preview</span></td><td><span data-option="q8ITGZ3mmq6Z">Duration</span></td><td><a href="source-system-integrations/redshift">redshift</a></td><td></td></tr></tbody></table>