Skip to content

Connection Management

Open Data Connections to add, delete, modify, or view connections.

Connection List

You can search for connections in the search box at the top right, or view all connections, those you created, and those authorized to you via the dropdown list.

Card View:

List View: In list view, you can click on columns with sorting icons to sort them.

Connection Operations

Create Connection

Click Create Connection to create a new connection.

Connection Permission Management, Edit, and Delete

The connection creator can click the three-dot menu on the connection to perform Permission Management, Edit, and Delete operations.

Using User Attributes in Connections

When creating various types of data connections, you can use user attributes in the connection property fields to enable dynamic connections for different users.

Click the user attribute icon on the right side of the connection property field to open the user attribute list. Search for and click the desired user attribute, and it will be automatically filled into the text box.

Show Only Tables in the Specified Database/Schema

On the Create/Edit Data Connection page, select Show only tables in the specified database/schema. After opening the connection, only the tables under the specified database/schema will be displayed. If this option is not selected, all databases and schemas that the user has permission to view will be shown.

When there are too many schemas or tables, this option can help alleviate performance issues during list loading.

Supported Connections for Write Operations and File Upload to Specified Paths

Prerequisites: Write permissions on the database are required (including CREATE DATABASE, CREATE SCHEMA, and CREATE TABLE).

The table below lists the data connections in HENGSHI SENSE that support write operations and file upload to specified paths. A Y indicates support.

Data SourceSupports Write OperationsSupports File Upload to Specified Path
MySQLYY
PostgreSQLYY
OracleYY
SQL ServerYY
IBM DB2
DamengYY
KingbaseES
GBase 8aYY
TiDB
OceanBaseYY
NetSuite
GreenplumYY
CloudberryYY
Apache DorisYY
StarRocksYY
SelectDBYY
ClickHouseYY
Vertica
AtomData
GBase 8s
SAP BW
Denodo
Amazon RedshiftYY
Amazon AthenaYY
Maxcompute PostgreSQL
Alibaba HologresYY
Maxcompute
AnalyticDB MySQLYY
GaussDBYY
TDSQL MySQLYY
TDSQL PostgreSQLYY
Lakehouse
Databricks
Hive
Spark SQL
ImpalaYY
Kylin
Kyligence Enterprise
PrestoYY
Trino
Hbase
Phoenix
ArgoDB
Elastic Search
Apache Solr
MongoDB BI Connector
MongoDB
SAP HANAYY
API Data Source

User Manual for Hengshi Analysis Platform