Connecting to Sybase
This section contains details for Sybase connections.General information
Field | Description |
---|---|
Data source | Sybase |
Supported versions | 7.2.0 |
Connection string | jdbc:sybase: |
Packaged? |
|
Certified? |
|
Supported features | |
Estimate job |
|
Analyze data |
|
Schedule |
|
Processing capabilities | |
Pushdown |
|
Spark agent |
|
Yarn agent |
|
Parallel JDBC |
|
Java Platform version compatibility | |
JDK 8 |
|
JDK 11 |
|
Minimum user permissions
In order to bring your Sybase data into Collibra Data Quality & Observability, you need the following permissions.
- Read access on your Sybase database tables.
- ROLE_ADMIN assigned to your user in Collibra DQ.
Recommended and required connection properties
Required | Connection Property | Type | Value |
---|---|---|---|
| Name | Text | The unique name of your connection. Ensure that there are no spaces in your connection name. |
| Connection URL | String | The connection string path of your Sybase connection. When referring to the example below, replace the Example |
| Driver Name | String | The driver class name of your Sybase connection.
|
| Port | Integer | The port number to establish a connection to the datasource. The default port is |
| Source Name | String | N/A |
| Target Agent | Option | The Agent that submits your Spark job for processing. |
| Auth Type | Option | The method to authenticate your connection. Note The configuration requirements are different depending on the Auth Type you select. See Authentication for more details on available authentication types. |
| Driver Properties | String | The configurable driver properties for your connection. Multiple properties must be comma delimited. For example, abc=123,test=true |
Authentication
This data source supports the following authentication type:
Username/Password
Required | Field | Description |
---|---|---|
| Username | The username of your Sybase service account. |
| Password | The password of your Sybase service account. |