Skip to main content

Azure Cosmos DB

Applicable EditionsTapData CloudTapData Cloud offers you cloud services that are suitable for scenarios requiring rapid deployment and low initial investment, helping you focus more on business development rather than infrastructure management. Free trial with TapData Cloud.TapData CommunityTapData Community is an open-source data integration platform that provides basic data synchronization and transformation capabilities. This helps you quickly explore and implement data integration projects. As your project or business grows, you can seamlessly upgrade to TapData Cloud or TapData Enterprise to access more advanced features and service support.

Azure Cosmos DB is a fully managed NoSQL and relational database for modern app development including. This article explains how to connect Azure Cosmos DB on the TapData platform, assisting in the rapid circulation of cloud data.

Prerequisites​

Azure Cosmos DB type: NoSQL

Functionality Limitations​

Azure Cosmos DB only supports full data synchronization and does not support incremental data synchronization.

Preparation​

Before connecting the data source, you need to log in to the Azure console to obtain the necessary address and key information for the connection. The specific steps are as follows:

  1. Log in to the Azure Portal.

  2. At the top of the page, search for and enter the Azure Cosmos DB console.

  3. Click on the instance name of Azure Cosmos DB Instance Name.

  4. In the left navigation bar, select Settings > Keys.

    Keys Page

Steps​

  1. Log in to TapData Platform.

  2. In the left navigation panel, click Connections.

  3. On the right side of the page, click Create.

  4. In the pop-up dialog, search for and select Azure Cosmos DB.

  5. On the redirected page, fill in the connection information for Azure Cosmos DB as per the instructions below.

    Connect Azure Cosmos DB

    • Basic Settings
      • Name: Enter a unique name with business significance.
      • Type: Currently only supports being used as a Source.
      • Account Host, Account Key: The connection address and key information (read-only permissions are sufficient) of Azure Cosmos DB. For acquisition methods, see Preparation.
      • DBName: The database name.
      • Consistency Level: Should match the Azure Cosmos DB settings, default is SESSION level. For more, see Consistency Levels Introduction.
    • Advanced Settings
      • Contain table: The default option is All, which includes all tables. Alternatively, you can select Custom and manually specify the desired tables by separating their names with commas (,).
      • Exclude tables: Once the switch is enabled, you have the option to specify tables to be excluded. You can do this by listing the table names separated by commas (,) in case there are multiple tables to be excluded.
      • Agent settings: Defaults to Platform automatic allocation, you can also manually specify an agent.
      • Model load time: If there are less than 10,000 models in the data source, their information will be updated every hour. But if the number of models exceeds 10,000, the refresh will take place daily at the time you have specified.

  6. Click Test, and when passed, click Save.

    tip

    If the connection test fails, follow the prompts on the page to fix it.