Data Source is an ODBC Connection

 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”

ODBC 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

Data View

Data View Toolbar

  1. Reader Properties
  2. Refresh Data
  3. Browse Data
  4. Switch to Data View
  5. Switch to Data Definition View

Data Definition View

Data Definition View Toolbar

  1. Reader Properties
  2. Refresh Data
  3. Print Data Definition
  4. Print Preview Data Definition
  5. Find
  6. Browse Data
  7. Switch to Data View
  8. Switch to Data Definition View

List of ODBC Drivers Download Links

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL Forum

  • aetle/processing_data/reader/odbc.txt
  • Last modified: 17/09/2018 10:34
  • by admin