DataWorks:CreateDataSource

El ID del espacio de trabajo de DataWorks al que pertenece la fuente de datos. Puede llamar a la operación ListProjects para consultar el ID.

El nombre de la fuente de datos.

La descripción de la fuente de datos.

El tipo de la fuente de datos. Los valores comunes incluyen:

• odps

• mysql

• rds

• oss

• sqlserver

• polardb

• oracle

• mongodb

• emr

• postgresql

• analyticdb_for_mysql

• hybriddb_for_postgresql

• holo

El subtipo de la fuente de datos.

• Este parámetro surte efecto solo si establece el parámetro DataSourceType en rds.

• Si el parámetro DataSourceType se establece en rds, este parámetro se puede establecer en mysql, sqlserver o postgresql.

El entorno en el que se utiliza la fuente de datos. Valores válidos: 0 y 1. El valor 0 indica el entorno de desarrollo. El valor 1 indica el entorno de producción.

Los detalles de la fuente de datos. Ejemplos de detalles de algunas fuentes de datos comunes:

• odps

  {
    "accessId": "*****",
    "accessKey": "*****",
    "authType": 2,
    "endpoint": "http://service.odps.aliyun.com/api",
    "project": "xsaxsax",
    "tag": "public"
  }
  

• mysql

  {
    "database": "xsaxsa",
    "instanceName": "rm-xsaxsa",
    "password": "xsaxsa",
    "rdsOwnerId": "xasxsa",
    "regionId": "cn-shanghai",
    "tag": "rds",
    "username": "xsaxsa"
  }
  

• rds

  {
    "configType": 1,
    "tag": "rds",
    "database": "xsaxsa",
    "username": "xsaxsa",
    "password": "xssaxsa$32050",
    "instanceName": "rm-xsaxs",
    "rdsOwnerId": "11111111"
  }
  

• oss

  {
    "accessId": "*****",
    "accessKey": "*****",
    "bucket": "xsa-xs-xs",
    "endpoint": "http://oss-cn-shanghai.aliyuncs.com",
    "tag": "public"
  }
  

• sqlserver

  {
    "jdbcUrl": "jdbc:sqlserver://xsaxsa-xsaxsa.database.xxx.cn:123;DatabaseName=xsxs-xsxs",
    "password": "sdasda$fs",
    "tag": "public",
    "username": "sxaxacdacdd"
  }
  

• polardb

  {
    "clusterId": "pc-sdadsadsa",
    "database": "dsadsadsa",
    "ownerId": "121212122",
    "password": "sdasdafssa",
    "region": "cn-shanghai",
    "tag": "polardb",
    "username": "asdadsads"
  }
  

• redis

  {    
  "password": "xxxxxx",   
   "address":"[{\"host\":\"xxxxxxx.redis.rds.aliyuncs.com\",\"port\":6379}]",    
  "tag": "public"
  }
  

• oracle

  {
    "jdbcUrl": "jdbc:oracle:saaa:@xxxxx:1521:PROD",
    "password": "sxasaxsa",
    "tag": "public",
    "username": "sasfadfa"
  }
  

• mongodb

  {
    "address": "[\"xsaxxsa.mongodb.rds.aliyuncs.com:3717\"]",
    "database": "admin",
    "password": "sadsda@",
    "tag": "public",
    "username": "dsadsadas"
  }
  

• emr

  {
    "accessId": "*****",
    "emrClusterId": "C-dsads",
    "emrResourceQueueName": "default",
    "emrEndpoint": "emr.aliyuncs.com",
    "accessKey": "*****",
    "emrUserId": "224833315798889783",
    "name": "sasdsadsa",
    "emrAccessMode": "simple",
    "region": "cn-shanghai",
    "authType": "2",
    "emrProjectId": "FP-sdadsad"
  }
  

• postgresql

  {
    "jdbcUrl": "jdbc:postgresql://xxxx:1921/ssss",
    "password": "sdadsads",
    "tag": "public",
    "username": "sdsasda"
  }
  

• analyticdb_for_mysql

  {
    "instanceId": "am-sadsada",
    "database": "xsxsx",
    "username": "xsxsa",
    "password": "asdadsa",
    "connectionString": "am-xssxsxs.ads.aliyuncs.com:3306"
  }
  

• hybriddb_for_postgresql

  {
    "connectionString": "gp-xsaxsaxa-master.gpdbmaster.rds.aliyuncs.com",
    "database": "xsaxsaxas",
    "password": "xsaxsaxsa@11",
    "instanceId": "gp-xsaxsaxsa",
    "port": "541132",
    "ownerId": "xsaxsaxsas",
    "username": "sadsad"
  }
  

• holo

  {
    "accessId": "*****",
    "accessKey": "*****",
    "database": "xsaxsaxsa",
    "instanceId": "xsaxa",
    "tag": "aliyun"
  }
  

• kafka

  {
    "instanceId": "xsax-cn-xsaxsa",
    "regionId": "cn-shanghai",
    "tag": "aliyun",
    "ownerId": "1212121212112"
  }