ODBC Reader

ODBC

In computing, Open Database Connectivity (ODBC) is a standard application programming interface (API) for accessing database management systems (DBMS). The designers of ODBC aimed to make it independent of database systems and operating systems. An application written using ODBC can be ported to other platforms, both on the client and server side, with few changes to the data access code.

Source: Wikipedia

Bulk fetch

Some ODBC drivers do not support bulk fetch. If table has blob fields use SQL as source and put blob fields last

Select field1,blob1,blob2 from table

Connection Strings

It also possible to use ODBC connection strings for both Reader and Writer connections. For example for MS SQL Server connection string is:

Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

One of the major benefits of using connection strings that it makes it no longer necessary to create ODBC Dsn’s manually on every single computer where Advanced ETL Processor is installed. It also gives a greater control over the connection parameters.

Leave user name and password blank and provide it within connection string

More information about connection strings can be found at: https://www.connectionstrings.com

The simplest way to create ODBC connection string is to use ODBC Connection builder dialog. Double click on ODBC driver name to create a connection string