All Products
Search
Document Center

Lindorm:Add a LindormTable data source

Last Updated:Aug 24, 2022

This topic describes how to add a LindormTable data source.

Prerequisites

You are logged on to the Lindorm Tunnel Service (LTS) web UI. For information, see Activate and log on to LTS.

Add a Lindorm SQL data source

  1. Log on to the LTS web UI. In the left-side navigation pane, choose Data Source Manage > Add Data Source.

  2. On the Add data source page, configure the parameters. The following table describes the parameters.

    Parameter

    Description

    Name

    The name of the data source. The name can contain letters and digits.

    Data Source Type

    Select LQL.

    Parameters

    { "clusterKey":"x.hbaseue.rds.aliyuncs.com:30020:$username:$password" }

    • x.hbaseue.rds.aliyuncs.com:30020: the private endpoint that is used to connect to LindormTable by using the HBase API for Java. For more information about how to obtain the endpoint, see View endpoints.

    • $username: the username that is used to connect to LindormTable.

    • $password: the password that is used to connect to LindormTable.

  3. Click Add.

Add an HBase-compatible LindormTable data source

  1. Log on to the LTS web UI. In the left-side navigation pane, choose Data Source Manage > Add Data Source.

  2. On the Add data source page, configure the parameters. The following table describes the parameters.

    Parameter

    Description

    Name

    The name of the data source. The name can contain letters and digits.

    Data Source Type

    Select Lindorm for HBase(Enhanced Edition).

    Parameters

    { "clusterKey":"{x.hbaseue.rds.aliyuncs.com:30020}:{username}:{password}" }

    • x.hbaseue.rds.aliyuncs.com:30020: the private endpoint that is used to connect to LindormTable by using the HBase API for Java. For more information about how to obtain the endpoint, see View endpoints.

    • username: the username that is used to connect to LindormTable.

    • password: the password that is used to connect to LindormTable.

    Cluster/etc/hosts (Only EMR or OpenSource Cluster needed)

    The settings in the /etc/hosts file that corresponds to your HBase cluster. This parameter is required if you want to add a self-managed HBase cluster or an Elastic MapReduce (EMR) HBase cluster as a data source.

  3. Click Add.

Add a Cassandra-compatible LindormTable data source

  1. Log on to the LTS web UI. In the left-side navigation pane, choose Data Source Manage > Add Data Source.

  2. On the Add data source page, configure the parameters. The following table describes the parameters.

    Parameter

    Description

    Name

    The name of the data source. The name can contain letters and digits.

    Data Source Type

    Select Lindorm for Cassandra.

    Parameters

    {

    "cqlAddress":"x.rds.aliyuncs.com:9042",

    "username":"",

    "password":"", "clusterKey":"x.hbaseue.rds.aliyuncs.com:30020:username:password"

    }

    • x.rds.aliyuncs.com:9042: the Cassandra-compatible private endpoint that is used to connect to LindormTable. For more information about how to obtain the endpoint, see View endpoints.

    • x.hbaseue.rds.aliyuncs.com:30020: the private endpoint that is used to connect to LindormTable by using the HBase API for Java. For more information about how to obtain the endpoint, see View endpoints.

    • username: the username that is used to connect to LindormTable.

    • password: the password that is used to connect to LindormTable.

  3. Click Add.