# Connect Soda to IBM DB2

> For Soda to run quality scans on your data, you must configure it to connect to your data source.\
> To learn how to set up Soda and configure it to connect to your data sources, see [Get started](https://docs.soda.io/soda-documentation/soda-v3/quick-start-sip/setup-guide).

## Compatibility

Soda supports connections to IBM DB2 for Linux, UNIX, Windows (LUW).\
Soda does not support connections to IBM DB2 for z/OS. Refer to [IBM Developer documentation](https://developer.ibm.com/articles/dm-1108compdb2luwzos/) for more information.

## Connection configuration reference

Install package: `soda-db2`

```yaml
data_source my_datasource_name:
  type: db2
  host: 127.0.0.1
  port: 50000
  username: simple
  password: simple_pass
  database: database
  schema: public
```

| Property | Required | Notes                                                              |
| -------- | -------- | ------------------------------------------------------------------ |
| type     | required | Identify the type of data source for Soda.                         |
| host     | required | Provide a host identifier.                                         |
| port     | required | Provide a port identifier.                                         |
| username | required | Consider using system variables to retrieve this value securely.   |
| password | required | Consider using system variables to retrieve this value securely.   |
| database | required | Provide an identifier for your database.                           |
| schema   | optional | Provide an identifier for the schema in which your dataset exists. |

## Test the data source connection <a href="#test-the-data-source-connection" id="test-the-data-source-connection"></a>

To confirm that you have correctly configured the connection details for the data source(s) in your configuration YAML file, use the `test-connection` command. If you wish, add a `-V` option to the command to return results in verbose mode in the CLI.

```sh
soda test-connection -d my_datasource -c configuration.yml -V
```

## Supported data types

| Category | Data type                   |
| -------- | --------------------------- |
| text     | VARCHAR                     |
| number   | INT, INTEGER, DOUBLE, FLOAT |
| time     | DATE, TIME, TIMESTAMP       |