All Products
Document Center

Configure OTS data source

Last Updated: Jan 16, 2019

The Table Store(previously known as OTS) is a NoSQL data storage service built on Alibaba Cloud’s Apsara distributed system, enabling you to store and access massive structured data in real time.


For more information about the Table Store, see What is Table Store.


  1. Log on to the DataWorks console as a developer and click Enter Project, as shown in the following figure.


  2. Click Data Integration from the upper menu and go to the Data Sources page.


  3. Click New Source, and select Table Store (OTS) from the data sources list.

  4. Complete the configuration items for the Table Store data source.


    • Name: A combination of letters, numbers, and underscores (). It must begin with a letter or an underscore (), and must not exceed 60 characters.

    • Description: A brief description of the data source, which must not exceed 80 characters.

    • Endpoint: Endpoint of Table Store Server with the format of For more informarion, see Access control.

    • Table Store Instance ID: Instance ID corresponding to the Table Store service.

    • Access ID/AccessKey: The Access ID/AccessKey is equivalent to the logon password. For more information, see Create an AccessKey.

  5. Click Test Connectivity.

  6. When the connectivity test is passed, click Complete.

Connectivity test description

  • In a classic network, the connectivity test is provided to verify whether the Endpoint and AK entered are correct.

  • Currently, the operation of test connectivity to data sources is unavailable in VPC environments.