Add a MaxCompute data source

Updated at:

Add a MaxCompute (ODPS) project as a data source in the Lindorm Tunnel Service (LTS) console. LTS uses two VPC endpoints to connect to MaxCompute: the MaxCompute endpoint for queries and API calls, and the Tunnel endpoint for bulk data transfer. Both endpoints vary by region.

Prerequisites

Before you begin, ensure that you have:

  • An AccessKey ID and AccessKey Secret with access to your MaxCompute project

  • The name of your MaxCompute project

  • The MaxCompute and Tunnel endpoints for the region where your MaxCompute project resides (see Endpoints by region)

Important

For RAM users, the AccessKey Secret is displayed only when you click Create AccessKey. If you did not save it at creation time, you cannot view it later. Create a new AccessKey and save it. To create an AccessKey pair, see Create an AccessKey pair.

Add a MaxCompute data source

  1. Log on to the Lindorm Tunnel Service (LTS) console.

  2. In the left-side navigation pane, choose Data source management > Add data source.

  3. On the Add data source page, configure the following parameters.

    ParameterDescription
    NameEnter a custom name for the MaxCompute (ODPS) data source.
    Data Source TypeSelect MaxCompute (ODPS).
    ParametersA JSON object containing your MaxCompute connection details. See step 4.
  4. In the Parameters field, enter the connection details as a JSON object. Replace the AccessKey placeholders with your credentials, and set the endpoints and project name for your region and project.

    {
      "accessId": "<your-access-key-id>",
      "accessKey": "<your-access-key-secret>",
      "endPoint": "http://service.cn-shanghai.maxcompute.aliyun-inc.com/api",
      "project": "bds_pro",
      "tunnelEndPoint": "http://dt.cn-shanghai.maxcompute.aliyun-inc.com"
    }
    KeyDescriptionWhere to get itExample
    accessIdYour AccessKey IDRAM console<your-access-key-id>
    accessKeyYour AccessKey SecretRAM console; available only when created<your-access-key-secret>
    endPointThe VPC endpoint of MaxCompute for your region. Used for queries and API calls.Endpoints by regionhttp://service.cn-shanghai.maxcompute.aliyun-inc.com/api
    projectThe name of your MaxCompute projectMaxCompute consolebds_pro
    tunnelEndPointThe VPC Tunnel endpoint for your region. Used for bulk data transfer.Endpoints by regionhttp://dt.cn-shanghai.maxcompute.aliyun-inc.com

Endpoints by region

Use the VPC endpoints that match the region where your MaxCompute project resides.

RegionMaxCompute endpointTunnel endpoint
China (Hangzhou)http://service.cn-hangzhou.maxcompute.aliyun-inc.com/apihttp://dt.cn-hangzhou.maxcompute.aliyun-inc.com
China (Shanghai)http://service.cn-shanghai.maxcompute.aliyun-inc.com/apihttp://dt.cn-shanghai.maxcompute.aliyun-inc.com
China (Beijing)http://service.cn-beijing.maxcompute.aliyun-inc.com/apihttp://dt.cn-beijing.maxcompute.aliyun-inc.com
China (Zhangjiakou)http://service.cn-zhangjiakou.maxcompute.aliyun-inc.com/apihttp://dt.cn-zhangjiakou.maxcompute.aliyun-inc.com
China (Shenzhen)http://service.cn-shenzhen.maxcompute.aliyun-inc.com/apihttp://dt.cn-shenzhen.maxcompute.aliyun-inc.com
China (Chengdu)http://service.cn-chengdu.maxcompute.aliyun-inc.com/apihttp://dt.cn-chengdu.maxcompute.aliyun-inc.com
China (Hong Kong)http://service.cn-hongkong.maxcompute.aliyun-inc.com/apihttp://dt.cn-hongkong.maxcompute.aliyun-inc.com
Singaporehttp://service.ap-southeast-1.maxcompute.aliyun-inc.com/apihttp://dt.ap-southeast-1.maxcompute.aliyun-inc.com
Australia (Sydney) Closing Downhttp://service.ap-southeast-2.maxcompute.aliyun-inc.com/apihttp://dt.ap-southeast-2.maxcompute.aliyun-inc.com
Malaysia (Kuala Lumpur)http://service.ap-southeast-3.maxcompute.aliyun-inc.com/apihttp://dt.ap-southeast-3.maxcompute.aliyun-inc.com
UAE (Dubai)http://service.me-east-1.maxcompute.aliyun-inc.com/apihttp://dt.me-east-1.maxcompute.aliyun-inc.com
UK (London)http://service.uk-all.maxcompute.aliyun-inc.com/apihttp://dt.uk-all.maxcompute.aliyun-inc.com