> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sync.cdata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Apache Doris

export const CommonDatasourceCompleteConnectionOauth = ({datasource = "the data source", title = "the connector", oauthschemes = "", start = 2}) => {
  return <ol start={start}>
      <li>Define advanced connection settings on the <strong>Advanced</strong> tab. (In most cases, though, you should not need these settings.)</li>
      <li>{oauthschemes ? <>If you authenticate with {oauthschemes}, click</> : <>Click</>} <strong>Connect to {datasource}</strong> to connect to your {title} account.</li>
      <li>Click <strong>Create & Test</strong> to create your connection.</li>
    </ol>;
};

export const CommonAuthSchemeLdap = ({siteName = "CData Sync", siteNameShort = "Sync", datasource = "the data source"}) => {
  return <>
      <p>To connect with LDAP credentials, specify the following properties:</p>
      <ul>
        <li><strong>Auth Scheme:</strong> Select <strong>LDAP</strong>.</li>
        <li><strong>User:</strong> Enter the username that you use to authenticate to your {datasource} account.</li>
        <li><strong>Password:</strong> Enter the password that you use to authenticate to your {datasource} account.</li>
      </ul>
    </>;
};

export const CommonAuthSchemeAwsec2roles = ({siteName = "CData Sync", siteNameShort = "Sync", datasource = "the data source"}) => {
  return <>
      <p>
        When you run {siteName} on an EC2 instance, {siteName} can authenticate by using the IAM role that is assigned to the instance. Select <strong>AwsEC2Roles</strong> for <strong>Auth Scheme</strong> to use that role. No additional properties are required.
      </p>
    </>;
};

export const CommonAuthSchemeAwsiamroles = ({siteName = "CData Sync", siteNameShort = "Sync", datasource = "the data source"}) => {
  return <>
      <p>To connect with your IAM user credentials, specify the following properties:</p>
      <ul>
        <li><strong>Auth Scheme:</strong> Select <strong>AwsIAMRoles</strong>.</li>
        <li><strong>User:</strong> Enter the username that you use to authenticate to your {datasource} account.</li>
        <li><strong>AWS Access Key:</strong> Enter your Amazon Web Services (AWS) account access key. You can locate this value on your AWS security credentials page.</li>
        <li><strong>AWS Secret Key:</strong> Enter your AWS account secret key. You can locate this value on your AWS security credentials page.</li>
        <li><strong>AWS Role ARN:</strong> Enter the Amazon Resource Name (ARN) for the role with which you want to authenticate.</li>
        <li>(Optional) <strong>AWS External Id:</strong> Enter the unique identifier that is required when you assume a role in another account.</li>
      </ul>
    </>;
};

export const CommonAuthSchemeAzuremsi = ({siteName = "CData Sync"}) => {
  return <>
      <p>
        To leverage Azure Managed Service Identity (MSI) when {siteName} is running on an Azure
        virtual machine, select <strong>Azure MSI</strong> for <strong>Auth Scheme</strong>. No
        additional properties are required.
      </p>
    </>;
};

export const CommonAuthSchemeAzurepassword = ({siteName = "CData Sync", siteNameShort = "Sync", datasource = "the data source"}) => {
  return <>
      <p>To connect with an Azure password, specify these settings:</p>
      <ul>
        <li><strong>Auth Scheme:</strong> Select <strong>AzurePassword</strong>.</li>
        <li><strong>User:</strong> Enter the username that you use to authenticate to Azure.</li>
        <li><strong>Password:</strong> Enter the password that you use to authenticate to Azure.</li>
        <li><strong>Azure Tenant:</strong> Enter the Id of the Azure Tenant under which your OAuth and client applications were created. This Id is available under <strong>Directory (tenant) ID</strong> on the <strong>Overview</strong> page of one of the applications.</li>
      </ul>
    </>;
};

export const CommonAuthSchemeAzuread = ({siteName = "CData Sync"}) => {
  return <>
      <p>
        To connect with an Azure Active Directory (AD) user account, select <strong>AzureAD</strong>{' '}
        for <strong>Auth Scheme</strong>. {siteName} provides an embedded OAuth application with
        which to connect, so no additional properties are required.
      </p>
    </>;
};

export const CommonAuthSchemeNtlm = ({siteName = "CData Sync", siteNameShort = "Sync", datasource = "the data source"}) => {
  return <>
      <p>To connect with NTLM user credentials, specify the following properties:</p>
      <ul>
        <li><strong>Auth Scheme:</strong> Select <strong>NTLM</strong>.</li>
        <li><strong>User:</strong> Enter the username that you use to authenticate to your {datasource} server.</li>
        <li><strong>Password:</strong> Enter the password that you use to authenticate to your {datasource} server.</li>
      </ul>
    </>;
};

export const CommonAuthSchemePassword = ({siteName = "CData Sync", siteNameShort = "Sync", datasource = "the data source"}) => {
  return <>
      <p>To connect with your user credentials, set the following properties:</p>
      <ul>
        <li><strong>Auth Scheme:</strong> Select <strong>Password</strong>.</li>
        <li><strong>User:</strong> Enter the username that you use to authenticate to your {datasource} account.</li>
        <li><strong>Password:</strong> Enter the password that you use to authenticate to your {datasource} account.</li>
      </ul>
    </>;
};

export const CommonDatasourceAuthenticate = () => {
  return <p>After you add the connector, you need to set the required properties.</p>;
};

export const CommonDatasourceAddConnector = ({datasource = "the data source", title = "the connector", destination = false, siteNameShort = "Sync"}) => {
  return <>
      <p>
        To enable {siteNameShort} to use data from {datasource}, you first must add the
        connector, as follows:
      </p>
      <ol>
        <li>Open the <strong>Connections</strong> page of the {siteNameShort} dashboard.</li>
        <li>Click <strong>Add Connection</strong> to open the <strong>Select Connectors</strong> page.</li>
        <li>
          Click the <strong>{destination ? "Destinations" : "Sources"}</strong> tab and locate
          the <strong>{title}</strong> row.
        </li>
        <li>
          Click the <strong>Configure Connection</strong> icon at the end of that row to open
          the <strong>New Connection</strong> page. This action opens the{' '}
          <strong>Add Connection</strong> dialog box.
          <br />
          <strong>Note:</strong> If the <strong>Configure Connection</strong> icon is not
          available, click the <strong>Download Connector</strong> icon to install
          the {title} connector.
        </li>
        <li>Enter a name for your connection in the <strong>Add Connection</strong> dialog box.</li>
        <li>Click <strong>Add</strong> to open the <strong>Settings</strong> tab for your connector.</li>
      </ol>
      <p>
        For more information about installing new connectors, see{' '}
        <a href="../connections">Connections</a>.
      </p>
    </>;
};

export const CommonDatasourceIntroDestination = ({datasource = "the data source", siteName = "CData Sync"}) => {
  return <p>
      You can use the {datasource} connector from the {siteName} application to move data
      from any supported source to the {datasource} destination. To do so, you need to add
      the connector, authenticate to the connector, and complete your connection.
    </p>;
};

export const driverVersion = "M";

export const siteNameShort = "Sync";

export const siteName = "CData Sync";

export const datasource = "Apache Doris";
export const pageTitle = "Apache Doris";
export const advancedurl = "";
export const oauthschemes = "AzureAD";

<CommonDatasourceIntroDestination datasource="Apache Doris" siteName={siteName} />

## Add the Apache Doris Connector

<CommonDatasourceAddConnector datasource="Apache Doris" title="Apache Doris" destination={true} siteNameShort={siteNameShort} />

## Authenticate to Apache Doris

<CommonDatasourceAuthenticate datasource="Apache Doris" title="Apache Doris" destination={true} siteNameShort={siteNameShort} />

* **Server:** Enter the host name or the IP address of the MySQL server to which you want to connect.
* **Port:** Enter the port number that you use to connect to the MySQL server. The default port is **3306**.

{siteName} supports authenticating to {datasource} in several ways. Select your authentication method below to proceed to the relevant section that contains the authentication details.

* [**Password**](#password) (default)
* [**NTLM**](#ntlm)
* [**Azure Active Directory**](#azure-active-directory)
* [**Azure Password**](#azure-password)
* [**Azure Managed Service Identity**](#azure-managed-service-identity)
* [**AWS IAM Roles**](#aws-iam-roles)
* [**AWS EC2 Roles**](#aws-ec2-roles)
* [**LDAP**](#ldap)

### Password

<CommonAuthSchemePassword siteName={siteName} datasource={datasource} />

### NTLM

<CommonAuthSchemeNtlm siteName={siteName} datasource={datasource} />

<ul style={{marginTop: "-1rem"}}>
  <li>(Optional) <strong>Domain:</strong> Enter the Microsoft Windows domain that enables Windows Integrated Authentication using the NTLM protocol.</li>
  <li><strong>NTLM Version:</strong> Select the version of the NTLM protocol to use when you authenticate with Windows credentials.</li>
</ul>

### Azure Active Directory

To connect with your Azure Active Directory credentials, specify the following properties:

* **Auth Scheme:** Select **AzureAD**.
* **User:** Enter the username that you use to authenticate to your {datasource} account.
* **Azure Tenant:** Enter the MySQL tenant to which you want to connect. If you do not specify a tenant, {siteName} uses the default tenant.
* **OAuth Client Id:** Enter the client Id that you were assigned when you registered your application with an OAuth authorization server.
* **OAuth Client Secret:** Enter the client secret that you were assigned when you registered your application with an OAuth authorization server.
* **Scope:** Enter the scope of your access to the application.

### Azure Password

<CommonAuthSchemeAzurepassword siteName={siteName} datasource={datasource} />

<ul style={{marginTop: "-1rem"}}>
  <li> <strong>OAuth Client Id:</strong> Enter the client Id (also known as the consumer key) that is assigned to you custom OAuth application.</li>
</ul>

### Azure Managed Service Identity

To leverage Azure Managed Service Identity (MSI) when CData Sync is running on an Azure virtual machine, select Azure MSI for Auth Scheme. No additional properties are required.

* **Auth Scheme:** Select **AzureMSI**.
* **Azure Tenant:** Enter the MySQL tenant to which you want to connect. If you do not specify a tenant, {siteName} uses the default tenant.

### AWS IAM Roles

To connect with your IAM user credentials, specify the following properties:

* **Auth Scheme:** Select **AwsIAMRoles**.
* **AWS Access Key:** Enter your Amazon Web Services (AWS) account access key. You can locate this value on your AWS security credentials page.
* **AWS Secret Key:** Enter your AWS account secret key. You can locate this value on your AWS security credentials page.
* **AWS Role ARN:** Enter the Amazon Resource Name (ARN) for the role with which you want to authenticate.

### AWS EC2 Roles

<CommonAuthSchemeAwsec2roles siteName={siteName} datasource={datasource} />

### LDAP

<CommonAuthSchemeLdap siteName={siteName} datasource={datasource} />

## Complete Your Connection

To complete your connection:

1. Specify the following properties:

   * **Database:** Enter the MySQL database to which you want to connect. If you do not specify a database, Sync uses the default database.
   * **Use SSL:** Select whether you want to enable Secure Sockets Layer (SSL). By default, the **Enable** checkbox is not selected.

<div style={{marginTop: "-1rem"}}>
  <CommonDatasourceCompleteConnectionOauth datasource={datasource} title={pageTitle} oauthschemes={oauthschemes} />
</div>