AI 助理
文档备案控制台
官方文档
首页

ALIYUN::GPDB::JdbcDataSource

更新时间：
复制 MD 格式
产品详情
我的收藏

ALIYUN::GPDB::JdbcDataSource类型用于创建JDBC数据源。

语法

{
  "Type": "ALIYUN::GPDB::JdbcDataSource",
  "Properties": {
    "DBInstanceId": String,
    "JdbcUserName": String,
    "DataSourceName": String,
    "DataSourceType": String,
    "DataSourceDescription": String,
    "JdbcPassword": String,
    "JdbcConnectionString": String
  }
}

属性

属性名称

类型

必须

允许更新

描述

约束

DBInstanceId

String

是

否

实例ID。

无

JdbcUserName

String

是

是

数据库账户名称。

无

DataSourceDescription

String

否

是

数据源描述。

无

DataSourceName

String

否

否

数据源名称。

无

DataSourceType

String

否

是

数据源类型。

无

JdbcConnectionString

String

否

是

JDBC连接字符串。

无

JdbcPassword

String

否

是

数据库账户密码。

无

返回值

Fn::GetAtt

  • ModifyTime：最后修改时间。

  • CreateTime：资源的创建时间。

  • JdbcUserName：数据库账户名称。

  • ExternalDataServiceId：外部数据服务ID。

  • StatusMessage：服务状态信息，如异常则显示异常原因。正常运行状态为null值。

  • JdbcPassword：数据库账户密码。

  • DataSourceName：数据源名称。

  • DataSourceType：数据源类型。

  • ConnectionMessage：返回信息：如果连接失败，则返回错误消息。否则返回""。

  • JdbcConnectionString：JDBC连接字符串。

  • DataSourceDescription：数据源描述。

  • ConnectionStatus：服务状态。

  • DataSourceId：数据源ID。

示例

场景 1 ：为AnalyticDB PostgreSQL实例创建JDBC数据源，连接外部MySQL数据库实现跨库查询。

ROSTemplateFormatVersion: '2015-09-01'
Description:
  zh-cn: 为AnalyticDB PostgreSQL创建JDBC数据源，连接外部MySQL数据库实现跨库查询。
  en: Create a JDBC data source for AnalyticDB PostgreSQL to connect to an external MySQL database.
Parameters:
  DBInstanceId:
    Type: String
    Label:
      zh-cn: GPDB实例ID
      en: GPDB Instance ID
    Description:
      zh-cn: 已有的AnalyticDB PostgreSQL实例ID。
      en: The ID of an existing AnalyticDB for PostgreSQL instance.
  DataSourceName:
    Type: String
    Label:
      zh-cn: 数据源名称
      en: Data Source Name
    Description:
      zh-cn: JDBC数据源名称，用于标识该数据源连接。
      en: The JDBC data source name for identification.
    Default: mysql_source
  JdbcConnectionString:
    Type: String
    Label:
      zh-cn: JDBC连接串
      en: JDBC Connection String
    Description:
      zh-cn: >-
        MySQL数据库的JDBC连接串，格式：
        jdbc:mysql://<主机地址>:<端口>/<数据库名>
      en: >-
        MySQL JDBC connection string, format:
        jdbc:mysql://<host>:<port>/<database>
  JdbcUserName:
    Type: String
    Label:
      zh-cn: 数据库账号
      en: Database Username
    Description:
      zh-cn: 外部MySQL数据库的登录账号。
      en: The username for the external MySQL database.
  JdbcPassword:
    Type: String
    Label:
      zh-cn: 数据库密码
      en: Database Password
    Description:
      zh-cn: 外部MySQL数据库的登录密码。
      en: The password for the external MySQL database.
    NoEcho: true
Resources:
  JdbcDataSource:
    Type: ALIYUN::GPDB::JdbcDataSource
    Properties:
      DBInstanceId:
        Ref: DBInstanceId
      DataSourceName:
        Ref: DataSourceName
      JdbcConnectionString:
        Ref: JdbcConnectionString
      JdbcUserName:
        Ref: JdbcUserName
      JdbcPassword:
        Ref: JdbcPassword
Outputs:
  DataSourceId:
    Label:
      zh-cn: 数据源ID
      en: Data Source ID
    Description:
      zh-cn: 创建成功的JDBC数据源ID。
      en: The ID of the created JDBC data source.
    Value:
      Fn::GetAtt:
        - JdbcDataSource
        - DataSourceId
  ConnectionStatus:
    Label:
      zh-cn: 连接状态
      en: Connection Status
    Description:
      zh-cn: 数据源的连接状态。
      en: The connection status of the data source.
    Value:
      Fn::GetAtt:
        - JdbcDataSource
        - ConnectionStatus
{
  "ROSTemplateFormatVersion": "2015-09-01",
  "Description": {
    "zh-cn": "为AnalyticDB PostgreSQL创建JDBC数据源，连接外部MySQL数据库实现跨库查询。",
    "en": "Create a JDBC data source for AnalyticDB PostgreSQL to connect to an external MySQL database."
  },
  "Parameters": {
    "DBInstanceId": {
      "Type": "String",
      "Label": {
        "zh-cn": "GPDB实例ID",
        "en": "GPDB Instance ID"
      },
      "Description": {
        "zh-cn": "已有的AnalyticDB PostgreSQL实例ID。",
        "en": "The ID of an existing AnalyticDB for PostgreSQL instance."
      }
    },
    "DataSourceName": {
      "Type": "String",
      "Label": {
        "zh-cn": "数据源名称",
        "en": "Data Source Name"
      },
      "Description": {
        "zh-cn": "JDBC数据源名称，用于标识该数据源连接。",
        "en": "The JDBC data source name for identification."
      },
      "Default": "mysql_source"
    },
    "JdbcConnectionString": {
      "Type": "String",
      "Label": {
        "zh-cn": "JDBC连接串",
        "en": "JDBC Connection String"
      },
      "Description": {
        "zh-cn": "MySQL数据库的JDBC连接串，格式：jdbc:mysql://<主机地址>:<端口>/<数据库名>",
        "en": "MySQL JDBC connection string, format: jdbc:mysql://<host>:<port>/<database>"
      }
    },
    "JdbcUserName": {
      "Type": "String",
      "Label": {
        "zh-cn": "数据库账号",
        "en": "Database Username"
      },
      "Description": {
        "zh-cn": "外部MySQL数据库的登录账号。",
        "en": "The username for the external MySQL database."
      }
    },
    "JdbcPassword": {
      "Type": "String",
      "Label": {
        "zh-cn": "数据库密码",
        "en": "Database Password"
      },
      "Description": {
        "zh-cn": "外部MySQL数据库的登录密码。",
        "en": "The password for the external MySQL database."
      },
      "NoEcho": true
    }
  },
  "Resources": {
    "JdbcDataSource": {
      "Type": "ALIYUN::GPDB::JdbcDataSource",
      "Properties": {
        "DBInstanceId": {
          "Ref": "DBInstanceId"
        },
        "DataSourceName": {
          "Ref": "DataSourceName"
        },
        "JdbcConnectionString": {
          "Ref": "JdbcConnectionString"
        },
        "JdbcUserName": {
          "Ref": "JdbcUserName"
        },
        "JdbcPassword": {
          "Ref": "JdbcPassword"
        }
      }
    }
  },
  "Outputs": {
    "DataSourceId": {
      "Label": {
        "zh-cn": "数据源ID",
        "en": "Data Source ID"
      },
      "Description": {
        "zh-cn": "创建成功的JDBC数据源ID。",
        "en": "The ID of the created JDBC data source."
      },
      "Value": {
        "Fn::GetAtt": [
          "JdbcDataSource",
          "DataSourceId"
        ]
      }
    },
    "ConnectionStatus": {
      "Label": {
        "zh-cn": "连接状态",
        "en": "Connection Status"
      },
      "Description": {
        "zh-cn": "数据源的连接状态。",
        "en": "The connection status of the data source."
      },
      "Value": {
        "Fn::GetAtt": [
          "JdbcDataSource",
          "ConnectionStatus"
        ]
      }
    }
  }
}

场景 2 ：创建JDBC数据源连接外部PostgreSQL数据库，配置数据源类型和描述信息。

ROSTemplateFormatVersion: '2015-09-01'
Description:
  zh-cn: 创建JDBC数据源连接外部PostgreSQL数据库，配置数据源类型和描述信息。
  en: Create a JDBC data source to connect to an external PostgreSQL with type and description.
Parameters:
  DBInstanceId:
    Type: String
    Label:
      zh-cn: GPDB实例ID
      en: GPDB Instance ID
    Description:
      zh-cn: 已有的AnalyticDB PostgreSQL实例ID。
      en: The ID of an existing AnalyticDB for PostgreSQL instance.
  DataSourceName:
    Type: String
    Label:
      zh-cn: 数据源名称
      en: Data Source Name
    Description:
      zh-cn: JDBC数据源名称。
      en: The JDBC data source name.
    Default: pg_source
  DataSourceType:
    Type: String
    Label:
      zh-cn: 数据源类型
      en: Data Source Type
    Description:
      zh-cn: 外部数据源的数据库类型。
      en: The database type of the external data source.
    Default: postgresql
  DataSourceDescription:
    Type: String
    Label:
      zh-cn: 数据源描述
      en: Data Source Description
    Description:
      zh-cn: 数据源的描述信息，便于后续管理和识别。
      en: Description of the data source for management.
    Default: 外部PostgreSQL数据源，用于跨实例联邦查询
  JdbcHost:
    Type: String
    Label:
      zh-cn: 数据库主机地址
      en: Database Host
    Description:
      zh-cn: 外部PostgreSQL数据库的连接地址。
      en: The host address of the external PostgreSQL database.
  JdbcPort:
    Type: Number
    Label:
      zh-cn: 数据库端口
      en: Database Port
    Description:
      zh-cn: 外部PostgreSQL数据库的端口号。
      en: The port of the external PostgreSQL database.
    Default: 5432
    MinValue: 1
    MaxValue: 65535
  JdbcDatabase:
    Type: String
    Label:
      zh-cn: 数据库名称
      en: Database Name
    Description:
      zh-cn: 外部PostgreSQL数据库的库名。
      en: The database name of the external PostgreSQL.
  JdbcUserName:
    Type: String
    Label:
      zh-cn: 数据库账号
      en: Database Username
    Description:
      zh-cn: 外部PostgreSQL数据库的登录账号。
      en: The username for the external PostgreSQL database.
  JdbcPassword:
    Type: String
    Label:
      zh-cn: 数据库密码
      en: Database Password
    Description:
      zh-cn: 外部PostgreSQL数据库的登录密码。
      en: The password for the external PostgreSQL database.
    NoEcho: true
Resources:
  JdbcDataSource:
    Type: ALIYUN::GPDB::JdbcDataSource
    Properties:
      DBInstanceId:
        Ref: DBInstanceId
      DataSourceName:
        Ref: DataSourceName
      DataSourceType:
        Ref: DataSourceType
      DataSourceDescription:
        Ref: DataSourceDescription
      JdbcConnectionString:
        Fn::Sub:
          - jdbc:postgresql://${Host}:${Port}/${Database}
          - Host:
              Ref: JdbcHost
            Port:
              Ref: JdbcPort
            Database:
              Ref: JdbcDatabase
      JdbcUserName:
        Ref: JdbcUserName
      JdbcPassword:
        Ref: JdbcPassword
Outputs:
  DataSourceId:
    Label:
      zh-cn: 数据源ID
      en: Data Source ID
    Description:
      zh-cn: 创建成功的JDBC数据源ID。
      en: The ID of the created JDBC data source.
    Value:
      Fn::GetAtt:
        - JdbcDataSource
        - DataSourceId
  ExternalDataServiceId:
    Label:
      zh-cn: 外部数据服务ID
      en: External Data Service ID
    Description:
      zh-cn: 外部数据服务的唯一标识。
      en: The unique ID of the external data service.
    Value:
      Fn::GetAtt:
        - JdbcDataSource
        - ExternalDataServiceId
  ConnectionStatus:
    Label:
      zh-cn: 连接状态
      en: Connection Status
    Description:
      zh-cn: 数据源的连接状态。
      en: The connection status of the data source.
    Value:
      Fn::GetAtt:
        - JdbcDataSource
        - ConnectionStatus
  ConnectionMessage:
    Label:
      zh-cn: 连接信息
      en: Connection Message
    Description:
      zh-cn: 连接结果信息，连接失败时返回错误消息。
      en: Connection result message, returns error info on failure.
    Value:
      Fn::GetAtt:
        - JdbcDataSource
        - ConnectionMessage
{
  "ROSTemplateFormatVersion": "2015-09-01",
  "Description": {
    "zh-cn": "创建JDBC数据源连接外部PostgreSQL数据库，配置数据源类型和描述信息。",
    "en": "Create a JDBC data source to connect to an external PostgreSQL with type and description."
  },
  "Parameters": {
    "DBInstanceId": {
      "Type": "String",
      "Label": {
        "zh-cn": "GPDB实例ID",
        "en": "GPDB Instance ID"
      },
      "Description": {
        "zh-cn": "已有的AnalyticDB PostgreSQL实例ID。",
        "en": "The ID of an existing AnalyticDB for PostgreSQL instance."
      }
    },
    "DataSourceName": {
      "Type": "String",
      "Label": {
        "zh-cn": "数据源名称",
        "en": "Data Source Name"
      },
      "Description": {
        "zh-cn": "JDBC数据源名称。",
        "en": "The JDBC data source name."
      },
      "Default": "pg_source"
    },
    "DataSourceType": {
      "Type": "String",
      "Label": {
        "zh-cn": "数据源类型",
        "en": "Data Source Type"
      },
      "Description": {
        "zh-cn": "外部数据源的数据库类型。",
        "en": "The database type of the external data source."
      },
      "Default": "postgresql"
    },
    "DataSourceDescription": {
      "Type": "String",
      "Label": {
        "zh-cn": "数据源描述",
        "en": "Data Source Description"
      },
      "Description": {
        "zh-cn": "数据源的描述信息，便于后续管理和识别。",
        "en": "Description of the data source for management."
      },
      "Default": "外部PostgreSQL数据源，用于跨实例联邦查询"
    },
    "JdbcHost": {
      "Type": "String",
      "Label": {
        "zh-cn": "数据库主机地址",
        "en": "Database Host"
      },
      "Description": {
        "zh-cn": "外部PostgreSQL数据库的连接地址。",
        "en": "The host address of the external PostgreSQL database."
      }
    },
    "JdbcPort": {
      "Type": "Number",
      "Label": {
        "zh-cn": "数据库端口",
        "en": "Database Port"
      },
      "Description": {
        "zh-cn": "外部PostgreSQL数据库的端口号。",
        "en": "The port of the external PostgreSQL database."
      },
      "Default": 5432,
      "MinValue": 1,
      "MaxValue": 65535
    },
    "JdbcDatabase": {
      "Type": "String",
      "Label": {
        "zh-cn": "数据库名称",
        "en": "Database Name"
      },
      "Description": {
        "zh-cn": "外部PostgreSQL数据库的库名。",
        "en": "The database name of the external PostgreSQL."
      }
    },
    "JdbcUserName": {
      "Type": "String",
      "Label": {
        "zh-cn": "数据库账号",
        "en": "Database Username"
      },
      "Description": {
        "zh-cn": "外部PostgreSQL数据库的登录账号。",
        "en": "The username for the external PostgreSQL database."
      }
    },
    "JdbcPassword": {
      "Type": "String",
      "Label": {
        "zh-cn": "数据库密码",
        "en": "Database Password"
      },
      "Description": {
        "zh-cn": "外部PostgreSQL数据库的登录密码。",
        "en": "The password for the external PostgreSQL database."
      },
      "NoEcho": true
    }
  },
  "Resources": {
    "JdbcDataSource": {
      "Type": "ALIYUN::GPDB::JdbcDataSource",
      "Properties": {
        "DBInstanceId": {
          "Ref": "DBInstanceId"
        },
        "DataSourceName": {
          "Ref": "DataSourceName"
        },
        "DataSourceType": {
          "Ref": "DataSourceType"
        },
        "DataSourceDescription": {
          "Ref": "DataSourceDescription"
        },
        "JdbcConnectionString": {
          "Fn::Sub": [
            "jdbc:postgresql://${Host}:${Port}/${Database}",
            {
              "Host": {
                "Ref": "JdbcHost"
              },
              "Port": {
                "Ref": "JdbcPort"
              },
              "Database": {
                "Ref": "JdbcDatabase"
              }
            }
          ]
        },
        "JdbcUserName": {
          "Ref": "JdbcUserName"
        },
        "JdbcPassword": {
          "Ref": "JdbcPassword"
        }
      }
    }
  },
  "Outputs": {
    "DataSourceId": {
      "Label": {
        "zh-cn": "数据源ID",
        "en": "Data Source ID"
      },
      "Description": {
        "zh-cn": "创建成功的JDBC数据源ID。",
        "en": "The ID of the created JDBC data source."
      },
      "Value": {
        "Fn::GetAtt": [
          "JdbcDataSource",
          "DataSourceId"
        ]
      }
    },
    "ExternalDataServiceId": {
      "Label": {
        "zh-cn": "外部数据服务ID",
        "en": "External Data Service ID"
      },
      "Description": {
        "zh-cn": "外部数据服务的唯一标识。",
        "en": "The unique ID of the external data service."
      },
      "Value": {
        "Fn::GetAtt": [
          "JdbcDataSource",
          "ExternalDataServiceId"
        ]
      }
    },
    "ConnectionStatus": {
      "Label": {
        "zh-cn": "连接状态",
        "en": "Connection Status"
      },
      "Description": {
        "zh-cn": "数据源的连接状态。",
        "en": "The connection status of the data source."
      },
      "Value": {
        "Fn::GetAtt": [
          "JdbcDataSource",
          "ConnectionStatus"
        ]
      }
    },
    "ConnectionMessage": {
      "Label": {
        "zh-cn": "连接信息",
        "en": "Connection Message"
      },
      "Description": {
        "zh-cn": "连接结果信息，连接失败时返回错误消息。",
        "en": "Connection result message, returns error info on failure."
      },
      "Value": {
        "Fn::GetAtt": [
          "JdbcDataSource",
          "ConnectionMessage"
        ]
      }
    }
  }
}

场景 3 ：创建GPDB账号并配置JDBC数据源，实现完整的跨库联邦查询环境搭建。

ROSTemplateFormatVersion: '2015-09-01'
Description:
  zh-cn: 创建GPDB账号并配置JDBC数据源，实现完整的跨库联邦查询环境搭建。
  en: Create a GPDB account and JDBC data source for a complete federated query setup.
Parameters:
  DBInstanceId:
    Type: String
    Label:
      zh-cn: GPDB实例ID
      en: GPDB Instance ID
    Description:
      zh-cn: 已有的AnalyticDB PostgreSQL实例ID。
      en: The ID of an existing AnalyticDB for PostgreSQL instance.
  AccountName:
    Type: String
    Label:
      zh-cn: GPDB账号名称
      en: GPDB Account Name
    Description:
      zh-cn: >-
        GPDB数据库账号名称，2~16个字符，
        由小写字母、数字和下划线组成，
        不能以gp开头。
      en: >-
        GPDB account name, 2-16 characters,
        lowercase letters, digits and underscores, cannot start with gp.
    Default: query_user
    AllowedPattern: '^(?!gp)[a-z][a-z0-9_]{0,14}[a-z0-9]$'
  AccountPassword:
    Type: String
    Label:
      zh-cn: GPDB账号密码
      en: GPDB Account Password
    Description:
      zh-cn: GPDB数据库账号密码，8~32个字符。
      en: GPDB account password, 8-32 characters.
    NoEcho: true
    MinLength: 8
    MaxLength: 32
  DataSourceName:
    Type: String
    Label:
      zh-cn: 数据源名称
      en: Data Source Name
    Description:
      zh-cn: JDBC数据源名称。
      en: The JDBC data source name.
    Default: external_db_source
  DataSourceType:
    Type: String
    Label:
      zh-cn: 数据源类型
      en: Data Source Type
    Description:
      zh-cn: 外部数据源的数据库类型。
      en: The database type of the external data source.
    Default: mysql
    AllowedValues:
      - mysql
      - postgresql
      - oracle
      - sqlserver
  ExternalJdbcConnectionString:
    Type: String
    Label:
      zh-cn: 外部数据库JDBC连接串
      en: External JDBC Connection String
    Description:
      zh-cn: >-
        外部数据库的JDBC连接串。
        MySQL格式：jdbc:mysql://host:3306/dbname
        PostgreSQL格式：jdbc:postgresql://host:5432/dbname
      en: >-
        External database JDBC connection string.
        MySQL format: jdbc:mysql://host:3306/dbname
        PostgreSQL format: jdbc:postgresql://host:5432/dbname
  ExternalJdbcUserName:
    Type: String
    Label:
      zh-cn: 外部数据库账号
      en: External DB Username
    Description:
      zh-cn: 外部数据库的登录账号。
      en: The username for the external database.
  ExternalJdbcPassword:
    Type: String
    Label:
      zh-cn: 外部数据库密码
      en: External DB Password
    Description:
      zh-cn: 外部数据库的登录密码。
      en: The password for the external database.
    NoEcho: true
Resources:
  GpdbAccount:
    Type: ALIYUN::GPDB::Account
    Properties:
      DBInstanceId:
        Ref: DBInstanceId
      AccountName:
        Ref: AccountName
      AccountPassword:
        Ref: AccountPassword
      AccountType: Super
      AccountDescription: 联邦查询管理账号
  JdbcDataSource:
    Type: ALIYUN::GPDB::JdbcDataSource
    DependsOn: GpdbAccount
    Properties:
      DBInstanceId:
        Ref: DBInstanceId
      DataSourceName:
        Ref: DataSourceName
      DataSourceType:
        Ref: DataSourceType
      DataSourceDescription:
        Fn::Sub:
          - 通过${Type}类型JDBC连接的外部数据源
          - Type:
              Ref: DataSourceType
      JdbcConnectionString:
        Ref: ExternalJdbcConnectionString
      JdbcUserName:
        Ref: ExternalJdbcUserName
      JdbcPassword:
        Ref: ExternalJdbcPassword
Outputs:
  AccountName:
    Label:
      zh-cn: GPDB账号
      en: GPDB Account
    Description:
      zh-cn: 创建成功的GPDB账号名称。
      en: The name of the created GPDB account.
    Value:
      Fn::GetAtt:
        - GpdbAccount
        - AccountName
  DataSourceId:
    Label:
      zh-cn: 数据源ID
      en: Data Source ID
    Description:
      zh-cn: 创建成功的JDBC数据源ID。
      en: The ID of the created JDBC data source.
    Value:
      Fn::GetAtt:
        - JdbcDataSource
        - DataSourceId
  ConnectionStatus:
    Label:
      zh-cn: 连接状态
      en: Connection Status
    Description:
      zh-cn: JDBC数据源的连接状态。
      en: The connection status of the JDBC data source.
    Value:
      Fn::GetAtt:
        - JdbcDataSource
        - ConnectionStatus
  StatusMessage:
    Label:
      zh-cn: 状态信息
      en: Status Message
    Description:
      zh-cn: 服务状态信息，异常时显示异常原因，正常运行时为空。
      en: Service status info, shows exception reason if any, null when running normally.
    Value:
      Fn::GetAtt:
        - JdbcDataSource
        - StatusMessage
{
  "ROSTemplateFormatVersion": "2015-09-01",
  "Description": {
    "zh-cn": "创建GPDB账号并配置JDBC数据源，实现完整的跨库联邦查询环境搭建。",
    "en": "Create a GPDB account and JDBC data source for a complete federated query setup."
  },
  "Parameters": {
    "DBInstanceId": {
      "Type": "String",
      "Label": {
        "zh-cn": "GPDB实例ID",
        "en": "GPDB Instance ID"
      },
      "Description": {
        "zh-cn": "已有的AnalyticDB PostgreSQL实例ID。",
        "en": "The ID of an existing AnalyticDB for PostgreSQL instance."
      }
    },
    "AccountName": {
      "Type": "String",
      "Label": {
        "zh-cn": "GPDB账号名称",
        "en": "GPDB Account Name"
      },
      "Description": {
        "zh-cn": "GPDB数据库账号名称，2~16个字符，由小写字母、数字和下划线组成，不能以gp开头。",
        "en": "GPDB account name, 2-16 characters, lowercase letters, digits and underscores, cannot start with gp."
      },
      "Default": "query_user",
      "AllowedPattern": "^(?!gp)[a-z][a-z0-9_]{0,14}[a-z0-9]$"
    },
    "AccountPassword": {
      "Type": "String",
      "Label": {
        "zh-cn": "GPDB账号密码",
        "en": "GPDB Account Password"
      },
      "Description": {
        "zh-cn": "GPDB数据库账号密码，8~32个字符。",
        "en": "GPDB account password, 8-32 characters."
      },
      "NoEcho": true,
      "MinLength": 8,
      "MaxLength": 32
    },
    "DataSourceName": {
      "Type": "String",
      "Label": {
        "zh-cn": "数据源名称",
        "en": "Data Source Name"
      },
      "Description": {
        "zh-cn": "JDBC数据源名称。",
        "en": "The JDBC data source name."
      },
      "Default": "external_db_source"
    },
    "DataSourceType": {
      "Type": "String",
      "Label": {
        "zh-cn": "数据源类型",
        "en": "Data Source Type"
      },
      "Description": {
        "zh-cn": "外部数据源的数据库类型。",
        "en": "The database type of the external data source."
      },
      "Default": "mysql",
      "AllowedValues": [
        "mysql",
        "postgresql",
        "oracle",
        "sqlserver"
      ]
    },
    "ExternalJdbcConnectionString": {
      "Type": "String",
      "Label": {
        "zh-cn": "外部数据库JDBC连接串",
        "en": "External JDBC Connection String"
      },
      "Description": {
        "zh-cn": "外部数据库的JDBC连接串。MySQL格式：jdbc:mysql://host:3306/dbname，PostgreSQL格式：jdbc:postgresql://host:5432/dbname",
        "en": "External database JDBC connection string. MySQL format: jdbc:mysql://host:3306/dbname, PostgreSQL format: jdbc:postgresql://host:5432/dbname"
      }
    },
    "ExternalJdbcUserName": {
      "Type": "String",
      "Label": {
        "zh-cn": "外部数据库账号",
        "en": "External DB Username"
      },
      "Description": {
        "zh-cn": "外部数据库的登录账号。",
        "en": "The username for the external database."
      }
    },
    "ExternalJdbcPassword": {
      "Type": "String",
      "Label": {
        "zh-cn": "外部数据库密码",
        "en": "External DB Password"
      },
      "Description": {
        "zh-cn": "外部数据库的登录密码。",
        "en": "The password for the external database."
      },
      "NoEcho": true
    }
  },
  "Resources": {
    "GpdbAccount": {
      "Type": "ALIYUN::GPDB::Account",
      "Properties": {
        "DBInstanceId": {
          "Ref": "DBInstanceId"
        },
        "AccountName": {
          "Ref": "AccountName"
        },
        "AccountPassword": {
          "Ref": "AccountPassword"
        },
        "AccountType": "Super",
        "AccountDescription": "联邦查询管理账号"
      }
    },
    "JdbcDataSource": {
      "Type": "ALIYUN::GPDB::JdbcDataSource",
      "DependsOn": "GpdbAccount",
      "Properties": {
        "DBInstanceId": {
          "Ref": "DBInstanceId"
        },
        "DataSourceName": {
          "Ref": "DataSourceName"
        },
        "DataSourceType": {
          "Ref": "DataSourceType"
        },
        "DataSourceDescription": {
          "Fn::Sub": [
            "通过${Type}类型JDBC连接的外部数据源",
            {
              "Type": {
                "Ref": "DataSourceType"
              }
            }
          ]
        },
        "JdbcConnectionString": {
          "Ref": "ExternalJdbcConnectionString"
        },
        "JdbcUserName": {
          "Ref": "ExternalJdbcUserName"
        },
        "JdbcPassword": {
          "Ref": "ExternalJdbcPassword"
        }
      }
    }
  },
  "Outputs": {
    "AccountName": {
      "Label": {
        "zh-cn": "GPDB账号",
        "en": "GPDB Account"
      },
      "Description": {
        "zh-cn": "创建成功的GPDB账号名称。",
        "en": "The name of the created GPDB account."
      },
      "Value": {
        "Fn::GetAtt": [
          "GpdbAccount",
          "AccountName"
        ]
      }
    },
    "DataSourceId": {
      "Label": {
        "zh-cn": "数据源ID",
        "en": "Data Source ID"
      },
      "Description": {
        "zh-cn": "创建成功的JDBC数据源ID。",
        "en": "The ID of the created JDBC data source."
      },
      "Value": {
        "Fn::GetAtt": [
          "JdbcDataSource",
          "DataSourceId"
        ]
      }
    },
    "ConnectionStatus": {
      "Label": {
        "zh-cn": "连接状态",
        "en": "Connection Status"
      },
      "Description": {
        "zh-cn": "JDBC数据源的连接状态。",
        "en": "The connection status of the JDBC data source."
      },
      "Value": {
        "Fn::GetAtt": [
          "JdbcDataSource",
          "ConnectionStatus"
        ]
      }
    },
    "StatusMessage": {
      "Label": {
        "zh-cn": "状态信息",
        "en": "Status Message"
      },
      "Description": {
        "zh-cn": "服务状态信息，异常时显示异常原因，正常运行时为空。",
        "en": "Service status info, shows exception reason if any, null when running normally."
      },
      "Value": {
        "Fn::GetAtt": [
          "JdbcDataSource",
          "StatusMessage"
        ]
      }
    }
  }
}
上一篇：ALIYUN::GPDB::ExternalDataService下一篇：ALIYUN::GPDB::InstancePublicConnection