aetl:processing_data:reader:ms_sql_server

Data Source is a MS SQL Server

All properties are very similar to ODBC connection
Leave user name and password blank to use Windows Authentication
To connect using different port use "server name,port" format

ODBC Drivers

Our software automatically selects the highest installed driver in the following order

  • ODBC Driver 17 for SQL Server
  • ODBC Driver 13 for SQL Server
  • ODBC Driver 11 for SQL Server
  • SQL Server Native Client 11.0
  • SQL Server Native Client 10.0
  • SQL Native Client
  • SQL Server

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

16/06/2015 23:19 · kevin
, , ,
  • aetl/processing_data/reader/ms_sql_server.txt
  • Last modified: 18/06/2015 11:57
  • by admin