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 Source | Supports Write Operations | Supports File Upload to Specified Path |
---|---|---|
MySQL | Y | Y |
PostgreSQL | Y | Y |
Oracle | Y | Y |
SQL Server | Y | Y |
IBM DB2 | ||
Dameng | Y | Y |
KingbaseES | ||
GBase 8a | Y | Y |
TiDB | ||
OceanBase | Y | Y |
NetSuite | ||
Greenplum | Y | Y |
Cloudberry | Y | Y |
Apache Doris | Y | Y |
StarRocks | Y | Y |
SelectDB | Y | Y |
ClickHouse | Y | Y |
Vertica | ||
AtomData | ||
GBase 8s | ||
SAP BW | ||
Denodo | ||
Amazon Redshift | Y | Y |
Amazon Athena | Y | Y |
Maxcompute PostgreSQL | ||
Alibaba Hologres | Y | Y |
Maxcompute | ||
AnalyticDB MySQL | Y | Y |
GaussDB | Y | Y |
TDSQL MySQL | Y | Y |
TDSQL PostgreSQL | Y | Y |
Lakehouse | ||
Databricks | ||
Hive | ||
Spark SQL | ||
Impala | Y | Y |
Kylin | ||
Kyligence Enterprise | ||
Presto | Y | Y |
Trino | ||
Hbase | ||
Phoenix | ||
ArgoDB | ||
Elastic Search | ||
Apache Solr | ||
MongoDB BI Connector | ||
MongoDB | ||
SAP HANA | Y | Y |
API Data Source |