> ## Documentation Index
> Fetch the complete documentation index at: https://domoinc-openapi-sync-dataflows.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Domo on Azure SQL (Beta)

export const InlineImage = ({src, alt = '', height = '1.6em'}) => {
  return <img noZoom src={src} alt={alt} style={{
    display: 'inline',
    verticalAlign: 'start',
    height: height,
    margin: '0'
  }} />;
};

### Intro

Azure SQL users can connect their data to Domo through Cloud Amplifier native integrations. Get started by providing connection parameters, then select the tables you want to see as Domo DataSets.

### Create an Azure SQL Integration

Follow the steps in this article to configure a read-only Azure SQL–Domo integration:

1. In the Domo Data Center, navigate to the <InlineImage src="/images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000000uR3y.jpg" /> **Data Warehouse**.

2. Select <InlineImage src="/images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000000uSeO.jpg" /> **Add New Cloud Account**.

   <Frame>
     <img alt="add new cloud account.jpg" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/a4f3szIEyPCXGEyk/images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000000uRaE.jpg?fit=max&auto=format&n=a4f3szIEyPCXGEyk&q=85&s=390abf22c7c1cc8086916df164d4fe6e" style={{width: 500, height: 452}} width="2860" height="2584" data-path="images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000000uRaE.jpg" />
   </Frame>

   The **Amplify existing cloud warehouses** modal displays.

3. In the **Native integration** section, choose **See More** to see additional options.

   <Frame>
     <img alt="see more.jpg" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/a4f3szIEyPCXGEyk/images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000000uTIf.jpg?fit=max&auto=format&n=a4f3szIEyPCXGEyk&q=85&s=6094ef4540f7ea4d381ea899eab2f9dc" style={{width: 500, height: 340}} width="1678" height="1140" data-path="images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000000uTIf.jpg" />
   </Frame>

4. Select **Azure SQL**.

   <Frame>
     <img alt="choose azure sql.jpg" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/a4f3szIEyPCXGEyk/images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000001JtzW.jpg?fit=max&auto=format&n=a4f3szIEyPCXGEyk&q=85&s=9bdbe2be7c85112c073af4363daa57ae" style={{width: 500, height: 375}} width="952" height="714" data-path="images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000001JtzW.jpg" />
   </Frame>

5. Select **+ Add New Integration**.

   <InlineImage src="/images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000001K1Yr.jpg" />

   <InlineImage src="/images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000001JrL0.jpg" />

6. Enter the following connection parameters in the provided fields to connect to your Azure SQL database:

   * **Integration name —**
     If you need to update your integration in the future, this is the name to search for in the list of integrations.
   * **Integration description (optional) —**
     Any additional information about the integration.
   * **Azure SQL Database connection URL —**
     The host and port for the Azure SQL instance you are connecting to. Ex. *\< [myhost.com](http://myhost.com):3306>*.
   * **Azure SQL Database database name —**
     The name of the database containing the tables you want to connect to.
   * **Azure SQL Database username —**
     The Azure SQL instance username with access to the data you are connecting to.
   * **Azure SQL Database password —**
     The password for the Azure SQL user.

   <Frame>
     <img alt="azure sql.jpg" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/a4f3szIEyPCXGEyk/images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000001JwKg.jpg?fit=max&auto=format&n=a4f3szIEyPCXGEyk&q=85&s=91a7f6c5d1dd518f5b5997ccd1bb3b3e" style={{width: 599, height: 442}} width="951" height="702" data-path="images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000001JwKg.jpg" />
   </Frame>

7. Configure caching options at the bottom of the form and select **Next**. Learn about Cloud Amplifier [caching rules](https://domo-support.domo.com/s/article/4412849158167?language=en_US#caching_rules).

   <Frame>
     <img alt="Screenshot 2024-05-07 at 3.24.52 PM.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/a4f3szIEyPCXGEyk/images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000000uWur.jpg?fit=max&auto=format&n=a4f3szIEyPCXGEyk&q=85&s=9e8dfdee34acb460cc1ed0b210c28551" style={{width: 549, height: 156}} width="2004" height="570" data-path="images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000000uWur.jpg" />
   </Frame>

   A success message displays.

8. Select **Choose Tables to Connect** to open the table picker.

   <Frame>
     <img alt="choose tables.jpg" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/a4f3szIEyPCXGEyk/images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000001K20H.jpg?fit=max&auto=format&n=a4f3szIEyPCXGEyk&q=85&s=0ce413d0e7dbde8942932191f3fa6bf3" style={{width: 600, height: 381}} width="2814" height="1788" data-path="images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000001K20H.jpg" />
   </Frame>

9. Use the table picker to select from schemas and tables. When you're ready, select
   **Create DataSets**.

   <Frame>
     <img alt="table picker.jpg" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/a4f3szIEyPCXGEyk/images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000001L0hB.jpg?fit=max&auto=format&n=a4f3szIEyPCXGEyk&q=85&s=87e3e83557135d77969133573f08f1db" style={{width: 600, height: 356}} width="3006" height="1785" data-path="images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000001L0hB.jpg" />
   </Frame>

10. (Optional)The confirmation modal allows you to share your DataSets with other Domo users. After choosing people to add and choosing their level of access in the dropdown, select
    **Share**.

    Or, select **No Thanks** to close the modal without sharing access.

    <Frame>
      <img alt="share modal.jpg" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/a4f3szIEyPCXGEyk/images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000000uXZB.jpg?fit=max&auto=format&n=a4f3szIEyPCXGEyk&q=85&s=787cc3bafe733301654696217f80be34" style={{width: 550, height: 313}} width="2001" height="1140" data-path="images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000000uXZB.jpg" />
    </Frame>

You can now interact with your Azure SQL DataSets in Domo.

<Frame>
  <img alt="interact with azure sql.jpg" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/a4f3szIEyPCXGEyk/images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000001K2I1.jpg?fit=max&auto=format&n=a4f3szIEyPCXGEyk&q=85&s=09caad1bec6c080eae8d2a8d2e0ec4d7" style={{width: 899, height: 397}} width="4281" height="1890" data-path="images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000001K2I1.jpg" />
</Frame>
