data source

This article introduces the usage scenarios, operation processes and key configurations of the data source function to help users complete daily management and business operations.

View data source

Click the Data Source menu to view the data sources created by the current tenant Support name, type, connection information, user name, remarks search, support drop-down data source type search

20241213185108

Add data source

Click the Add Data Source button

20241213184832

The following data source types are supported

Note: The connection information must carry the db name or schema name of the database. It is recommended to use the intranet IP connection first.

data sourceConnection information template
MySQLjdbc:mysql://127.0.0.1:3306/test_db
Dorisjdbc:mysql://127.0.0.1:9030/test_db
SQL Serverjdbc:sqlserver://127.0.0.1:1433;trustServerCertificate=true
Oraclejdbc:oracle:thin:@127.0.0.1:1521/zhiqingyun
Hivejdbc:hive2://127.0.0.1:10000/test_db
Postgresjdbc:postgresql://127.0.0.1:5432/test_db
Clickhousejdbc:clickhouse://127.0.0.1:8123/test_db
Hanajdbc:sap://127.0.0.1:30015/test_db
Damengjdbc:dm://127.0.0.1:5236/test_db
OceanBasejdbc:oceanbase://127.0.0.1:2881/test_db
Tidbjdbc:mysql://127.0.0.1:4000/test_db
StarRocksjdbc:mysql://127.0.0.1:9030/test_db
Kafka127.0.0.1:9092

Connection information description

  • Name: required, data source name, unique within the tenant
  • Type: required, drop-down data source type selection
  • Data source driver: required, the driver provided by the system is used by default, you can select the driver in Driver Management
  • Connection information: Required, database connection information, connection information reference template, please note the db library name or schema name at the end It is recommended to use intranet IP connection first.
  • User: optional, data source account
  • Password: Optional, data source password
  • Remarks: Optional
  • hive.metastore.uris: Only the hive data source has this option. It is recommended to use the intranet IP. The default port number is 9083
  • topic: Only the kafka data source has this option. It is recommended to use the intranet IP. The default port number is 9092

Data source detection

Detect the data source and troubleshoot data source connection problems Example: The following error message is an incorrect password

20241213184910

20241213184945

20241213184957