ODBC connector - CSharplie/ploosh GitHub Wiki

This connector allows to connect to a ODBC datasource and execute SQL queries.

Connection configuration

Definition

Name Mandatory Default Description
dsn yes Data Source Name
auto_commit no true Autocommit mode
username no null User name
password no null User password
driver no null ODBC driver name
encoding no UTF-8 Encoding to use for the connection

⚠️ it's highly recommended to use a parameter to pass the password value

Example

odbc_example:
  type: odbc
  dsn: my_dsn
  username: pixel
  password: $var.odbc_password

Test case configuration

Definition

Name Mandatory Default Description
connection yes The connection to use
query yes The query to execute to the database

Example

Example ODBC:
  source:
    connection: odbc_example
    type: odbc
    query: | 
        select * 
            from employees
            where hire_date < '2000-01-01'
    type: csv
    path: data/employees_before_2000.csv
⚠️ **GitHub.com Fallback** ⚠️