Connect Soda to IBM DB2
Last modified on 22-Jul-24
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.
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 for more information.
Connection configuration reference
Install package: soda-db2
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
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 returns results in verbose mode in the CLI.
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 |
Was this documentation helpful?
What could we do to improve this page?
- Suggest a docs change in GitHub.
- Share feedback in the Soda community on Slack.
Documentation always applies to the latest version of Soda products
Last modified on 22-Jul-24