Lindorm:Add a LindormTable data source

Prerequisites

Before you begin, make sure you have:

• Logged on to the LTS web UI. For details, see Activate and log on to LTS.

• Obtained the private endpoint for your LindormTable instance. For details, see View endpoints.

Add a Lindorm SQL data source

Use this method to connect via the LQL protocol.

1. In the left-side navigation pane, choose Data Source Manage > Add Data Source.

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

   Parameter	Description
   Name	A name for the data source. Supports letters and digits.
   Data Source Type	Select LQL.
   Parameters	Enter the connection string in the following format: { "clusterKey":"<endpoint>:30020:$username:$password" }

   Replace the placeholders with the actual values:

   Placeholder	Description
   <endpoint>	The private endpoint for HBase API for Java connections. Format: x.hbaseue.rds.aliyuncs.com. Port 30020 is used for HBase protocol connections. For details, see View endpoints.
   $username	The username for LindormTable.
   $password	The password for LindormTable.

3. Click Add.

Add an HBase-compatible LindormTable data source

Use this method to connect via the HBase protocol (Enhanced Edition).

1. In the left-side navigation pane, choose Data Source Manage > Add Data Source.

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

   Parameter	Description
   Name	A name for the data source. Supports letters and digits.
   Data Source Type	Select Lindorm for HBase(Enhanced Edition).
   Parameters	Enter the connection string in the following format: { "clusterKey":"{<endpoint>:30020}:{<username>}:{<password>}" }
   Cluster/etc/hosts (Only EMR or OpenSource Cluster needed)	The /etc/hosts entries for your HBase cluster. Required only if you are connecting to a self-managed HBase cluster or an Elastic MapReduce (EMR) HBase cluster.

   Replace the placeholders with the actual values:

   Placeholder	Description
   <endpoint>	The private endpoint for HBase API for Java connections. Format: x.hbaseue.rds.aliyuncs.com. Port 30020 is used for HBase protocol connections. For details, see View endpoints.
   <username>	The username for LindormTable.
   <password>	The password for LindormTable.

3. Click Add.

Add a Cassandra-compatible LindormTable data source

Use this method to connect via the Cassandra protocol.

1. In the left-side navigation pane, choose Data Source Manage > Add Data Source.

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

   Parameter	Description
   Name	A name for the data source. Supports letters and digits.
   Data Source Type	Select Lindorm for Cassandra.
   Parameters	Enter the connection string in the following format. See the placeholder table below for details.

   Parameters format:

   {
     "cqlAddress": "<cassandra-endpoint>:9042",
     "username": "",
     "password": "",
     "clusterKey": "<hbase-endpoint>:30020:<username>:<password>"
   }

   Replace the placeholders with the actual values:

   Placeholder	Description
   <cassandra-endpoint>	The Cassandra-compatible private endpoint. Format: x.rds.aliyuncs.com. Port 9042 is used for Cassandra protocol connections. For details, see View endpoints.
   <hbase-endpoint>	The private endpoint for HBase API for Java connections. Format: x.hbaseue.rds.aliyuncs.com. Port 30020 is used for HBase protocol connections.
   <username>	The username for LindormTable.
   <password>	The password for LindormTable.

3. Click Add.