Datasource Examples
The following are some example data sources illustrative for various file or database kinds and connection methods. Use this syntax to create a [datasource] section in a client or server configuration .ini file. Note that there may be more than one way to connect to the same database. For example, on Windows, you can connect to a MySQL database using any of the following connections methods: ADO.NET, JDBC, or ODBC.
Access (ADO)
[datasource:access_data]
type = ado
connection = Data Source=C:\Users\altova\Documents\ZooDB.mdb;Provider=Microsoft.Jet.OLEDB.4.0
table = [ZooDB].[tblAnimals]
CSV
[datasource:csv_data]
type=csv
path=C:\data.csv
separator=comma
key-columns-by-ordinal=1
has-header-row=false
IBM DB2 (JDBC)
[datasource:db2_data]
type = jdbc
connection = jdbc:db2://db2server:50000/PRODUCTSDB
class = com.ibm.db2.jcc.DB2Driver
user = dbuser
pass = 75gfljh9
table = "DB_USER"."PRODUCTS"
IBM DB2 for i (JDBC)
[datasource:db2_i_data]
type = jdbc
connection = jdbc:as400://127.0.0.1
class = com.ibm.as400.access.AS400JDBCDriver
user = DBUSER
pass = 75gfljh9
table = "DBUSER"."PRODUCTS"
MariaDB (ODBC)
[datasource:mariadb_data]
type = odbc
connection = Dsn=datasource_mariadb
database = nanonull
user = dbuser
pass = 75gfljh9
table = 'nanonull#.'products'
MySQL (ODBC)
[datasource:mysql_data]
type = odbc
connection = Dsn=datasource_mysql;
database = zoo
user = dbuser
pass = 75gfljh9
table = 'zoo'.'products'
Oracle (JDBC)
[datasource:oracle_data]
type = jdbc
connection = jdbc:oracle:thin:@ora12c:1521:orcl12c
class = oracle.jdbc.driver.OracleDriver
user = dbuser
pass = 75gfljh9
table = "DBUSER"."PRODUCTS"
PostgreSQL (Native)
[datasource:postgresql_data]
type = postgresql
connection = localhost
database = zoo
user = dbuser
pass = 75gfljh9
table = "zoo"."public"."animals"
SQLite (Native)
[datasource:sqlite_data]
type = sqlite
path = c:\comparisons\db\Nanonull.sqlite
table = "main"."products"
SQL Server (ADO.NET)
[datasource:sqlserver_data]
type = adonet
connection = Data Source=SQLSERV16;Initial Catalog=NANONULL;MultipleActiveResultSets=True;Password=7hiu57;Persist Security Info=True;User ID=altova
assembly = System.Data.SqlClient.SqlClientFactory, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
class = System.Data.SqlClient
table = [NANONULL].[dbo].[PRODUCTS]
Teradata (JDBC)
[datasource:teradata_data]
type = jdbc
connection = jdbc:teradata://teradata16/database=nanonull
class = com.teradata.jdbc.TeraDriver
user = dbuser
pass = 75gfljh9
table = "nanonull"."products"