Data Lake Analytics - Deprecated:Create a MongoDB schema

Procedure

1. Log on to the DLA console.

2. In the left-side navigation pane, click Endpoint. In the endpoint list, locate the row that contains the target endpoint and click Log on in DMS in the Actions column. Run the following statement to create a MongoDB schema in DLA:

    CREATE DATABASE `mongo_test`WITH DBPROPERTIES (
        catalog = 'mongodb',
        location = 'mongodb://<your-user-name>:<your-password>@dds-bp1694axxxxxxxx.mongodb.rds.aliyuncs.com:3717,dds-bp1694ayyyyyyyy.mongodb.rds.aliyuncs.com:3717/admin?replicaSet=zzzzz',
        database = 'mongo_test',
        INSTANCE_ID = 'mongodb_instance_id',
        vpc_id = 'vpc-*******'
    );

   Description

   • location: indicates the ConnectionStringURI of your MongoDB instance.

     

   • database: indicates the name of your MongoDB database.

   • INSTANCE_ID: indicates the ID of your MongoDB instance.

     

   • vpc_id: indicates the ID of the VPC where your MongoDB instance is located.

Next step

Create a MongoDB table and read and write data from and to the table