ALIYUN::GPDB::JdbcDataSource-资源编排(ROS)-阿里云帮助中心

语法

{
  "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。

示例

YAML

ROSTemplateFormatVersion: '2015-09-01'
Parameters:
  JdbcPassword:
    Type: String
    Description:
      en: The password of the database account.
    Required: false
  DataSourceName:
    Type: String
    Description:
      en: Data Source Name.
    Required: false
  DBInstanceId:
    Type: String
    Description:
      en: The instance ID.
    Required: true
  DataSourceType:
    Type: String
    Description:
      en: Data Source Type.
    Required: false
  JdbcUserName:
    Type: String
    Description:
      en: The name of the database account.
    Required: true
  JdbcConnectionString:
    Type: String
    Description:
      en: The JDBC connection string.
    Required: false
  DataSourceDescription:
    Type: String
    Description:
      en: Data Source Description.
    Required: false
Resources:
  ExtensionResource:
    Type: ALIYUN::GPDB::JdbcDataSource
    Properties:
      JdbcPassword:
        Ref: JdbcPassword
      DataSourceName:
        Ref: DataSourceName
      DBInstanceId:
        Ref: DBInstanceId
      DataSourceType:
        Ref: DataSourceType
      JdbcUserName:
        Ref: JdbcUserName
      JdbcConnectionString:
        Ref: JdbcConnectionString
      DataSourceDescription:
        Ref: DataSourceDescription
Outputs:
  ModifyTime:
    Description: Last modification time.
    Value:
      Fn::GetAtt:
        - ExtensionResource
        - ModifyTime
  CreateTime:
    Description: The creation time of the resource.
    Value:
      Fn::GetAtt:
        - ExtensionResource
        - CreateTime
  JdbcUserName:
    Description: The name of the database account.
    Value:
      Fn::GetAtt:
        - ExtensionResource
        - JdbcUserName
  ExternalDataServiceId:
    Description: External Data Service id.
    Value:
      Fn::GetAtt:
        - ExtensionResource
        - ExternalDataServiceId
  StatusMessage:
    Description: Service status information, such as exceptions, displays the reason for the exception. A null value in the normal Running state.
    Value:
      Fn::GetAtt:
        - ExtensionResource
        - StatusMessage
  JdbcPassword:
    Description: The password of the database account.
    Value:
      Fn::GetAtt:
        - ExtensionResource
        - JdbcPassword
  DataSourceName:
    Description: Data Source Name.
    Value:
      Fn::GetAtt:
        - ExtensionResource
        - DataSourceName
  DataSourceType:
    Description: Data Source Type.
    Value:
      Fn::GetAtt:
        - ExtensionResource
        - DataSourceType
  ConnectionMessage:
    Description: 'Return Information: If the connection fails, an error message is returned. Otherwise, "" is returned "".'
    Value:
      Fn::GetAtt:
        - ExtensionResource
        - ConnectionMessage
  JdbcConnectionString:
    Description: The JDBC connection string.
    Value:
      Fn::GetAtt:
        - ExtensionResource
        - JdbcConnectionString
  DataSourceDescription:
    Description: Data Source Description.
    Value:
      Fn::GetAtt:
        - ExtensionResource
        - DataSourceDescription
  ConnectionStatus:
    Description: Service Status:.
    Value:
      Fn::GetAtt:
        - ExtensionResource
        - ConnectionStatus
  DataSourceId:
    Description: The data source ID.
    Value:
      Fn::GetAtt:
        - ExtensionResource
        - DataSourceId

JSON

{
  "ROSTemplateFormatVersion": "2015-09-01",
  "Parameters": {
    "JdbcPassword": {
      "Type": "String",
      "Description": {
        "en": "The password of the database account."
      },
      "Required": false
    },
    "DataSourceName": {
      "Type": "String",
      "Description": {
        "en": "Data Source Name."
      },
      "Required": false
    },
    "DBInstanceId": {
      "Type": "String",
      "Description": {
        "en": "The instance ID."
      },
      "Required": true
    },
    "DataSourceType": {
      "Type": "String",
      "Description": {
        "en": "Data Source Type."
      },
      "Required": false
    },
    "JdbcUserName": {
      "Type": "String",
      "Description": {
        "en": "The name of the database account."
      },
      "Required": true
    },
    "JdbcConnectionString": {
      "Type": "String",
      "Description": {
        "en": "The JDBC connection string."
      },
      "Required": false
    },
    "DataSourceDescription": {
      "Type": "String",
      "Description": {
        "en": "Data Source Description."
      },
      "Required": false
    }
  },
  "Resources": {
    "ExtensionResource": {
      "Type": "ALIYUN::GPDB::JdbcDataSource",
      "Properties": {
        "JdbcPassword": {
          "Ref": "JdbcPassword"
        },
        "DataSourceName": {
          "Ref": "DataSourceName"
        },
        "DBInstanceId": {
          "Ref": "DBInstanceId"
        },
        "DataSourceType": {
          "Ref": "DataSourceType"
        },
        "JdbcUserName": {
          "Ref": "JdbcUserName"
        },
        "JdbcConnectionString": {
          "Ref": "JdbcConnectionString"
        },
        "DataSourceDescription": {
          "Ref": "DataSourceDescription"
        }
      }
    }
  },
  "Outputs": {
    "ModifyTime": {
      "Description": "Last modification time.",
      "Value": {
        "Fn::GetAtt": [
          "ExtensionResource",
          "ModifyTime"
        ]
      }
    },
    "CreateTime": {
      "Description": "The creation time of the resource.",
      "Value": {
        "Fn::GetAtt": [
          "ExtensionResource",
          "CreateTime"
        ]
      }
    },
    "JdbcUserName": {
      "Description": "The name of the database account.",
      "Value": {
        "Fn::GetAtt": [
          "ExtensionResource",
          "JdbcUserName"
        ]
      }
    },
    "ExternalDataServiceId": {
      "Description": "External Data Service id.",
      "Value": {
        "Fn::GetAtt": [
          "ExtensionResource",
          "ExternalDataServiceId"
        ]
      }
    },
    "StatusMessage": {
      "Description": "Service status information, such as exceptions, displays the reason for the exception. A null value in the normal Running state.",
      "Value": {
        "Fn::GetAtt": [
          "ExtensionResource",
          "StatusMessage"
        ]
      }
    },
    "JdbcPassword": {
      "Description": "The password of the database account.",
      "Value": {
        "Fn::GetAtt": [
          "ExtensionResource",
          "JdbcPassword"
        ]
      }
    },
    "DataSourceName": {
      "Description": "Data Source Name.",
      "Value": {
        "Fn::GetAtt": [
          "ExtensionResource",
          "DataSourceName"
        ]
      }
    },
    "DataSourceType": {
      "Description": "Data Source Type.",
      "Value": {
        "Fn::GetAtt": [
          "ExtensionResource",
          "DataSourceType"
        ]
      }
    },
    "ConnectionMessage": {
      "Description": "Return Information: If the connection fails, an error message is returned. Otherwise, \"\" is returned \"\".",
      "Value": {
        "Fn::GetAtt": [
          "ExtensionResource",
          "ConnectionMessage"
        ]
      }
    },
    "JdbcConnectionString": {
      "Description": "The JDBC connection string.",
      "Value": {
        "Fn::GetAtt": [
          "ExtensionResource",
          "JdbcConnectionString"
        ]
      }
    },
    "DataSourceDescription": {
      "Description": "Data Source Description.",
      "Value": {
        "Fn::GetAtt": [
          "ExtensionResource",
          "DataSourceDescription"
        ]
      }
    },
    "ConnectionStatus": {
      "Description": "Service Status:.",
      "Value": {
        "Fn::GetAtt": [
          "ExtensionResource",
          "ConnectionStatus"
        ]
      }
    },
    "DataSourceId": {
      "Description": "The data source ID.",
      "Value": {
        "Fn::GetAtt": [
          "ExtensionResource",
          "DataSourceId"
        ]
      }
    }
  }
}