---
url: /v6.2/en-us/connecting-oceanbase.md
---
# Connecting to OceanBase

### Connection Steps

Please follow the steps below to connect to the `OceanBase` data source.

1. Click "New Data Connection" in the upper right corner of the data connection page.
   ![](/images/data-connection/connection-001.png)

2. Select the `OceanBase` data source from the list of data source types.
   ![](/images/data-connection/connecting-oceanbase-001.png)

3. Fill in the required parameters for the data source connection as prompted.
   ![](/images/data-connection/connecting-oceanbase-002.png)

   **Connection Configuration Information Description**

   | Field                                   | Description                                                                                      |
   | ---------------------------------------- | ------------------------------------------------------------------------------------------------ |
   | Name                                    | The name of the connection. Required and unique within the user                                  |
   | Host Address                            | The address of the database. If the URL field is filled in, the URL will take precedence         |
   | Port                                    | The port of the database. If the URL field is filled in, the URL will take precedence            |
   | Username                                | The username for the database                                                                    |
   | Password                                | The password for the database                                                                    |
   | Database                                | The name of the database                                                                         |
   | Max Connections                         | The maximum number of connections in the connection pool                                         |
   | ssl                                     | Whether to use SSL connection                                                                    |
   | Prefer using database comment as dataset title | Whether to display the table name or the table comment as the title. When enabled, shows the title; when disabled, shows the table comment |
   | URL                                     | The JDBC URL of the database                                                                    |
   | Transaction isolation level for read operations | This setting only affects reading data; writing data still uses the default isolation level      |
   | Hierarchical loading of schema and tables| Default is off. When enabled, schemas and tables are loaded hierarchically; only schemas are loaded during connection, and you need to click the schema to load the tables under it |
   | Query timeout (seconds)                 | Default is 600. When the data volume is large, you can appropriately increase the timeout        |
   | Allow write operations                  | Indicates that this connection can be selected as an output connection in [Data Integration](pipeline.md) and [Batch Sync](batch-sync.md). You must have write permission to the database and pass verification before configuring this parameter. |
   | Support uploading files to specified path| Indicates the database name where the generated table will be stored when creating a local file dataset. You must have write permission to the database and pass verification before configuring this parameter. |
   | Show only tables under the specified database/schema | When this option is selected and the database field is not empty, only tables under that db will be displayed |

4. After filling in the parameters, click the `Validate` button to get the validation result (this checks the connectivity between HENGSHI SENSE and the configured data connection; you cannot add the connection if validation fails).

5. After validation passes, `Allow write operations` and `Support uploading files to specified path` will be enabled and can be optionally turned on.

6. Click `Execute Preset Code` to pop up the preset code for this data source, then click the execute button.

7. Click the `Add` button to add the `OceanBase` connection.

> \[!CAUTION] Please note
>
> 1. Parameters marked with \* are required; others are optional.
> 2. You must execute the preset code when connecting to the data source. Failure to do so may result in certain functions being unavailable during data analysis.

### Supported `OceanBase` Versions

`4.x` and above

### Data Connection Preview Support

Supports regular `table` and `view` objects, as well as other tables that can be listed by `show tables`.

### SQL Dataset Support for SQL

All `SELECT`-related features are supported. The `SELECT SQL` statement must comply with the `TiDB` syntax specification.