Advanced-etl-processor
MS SQL Server Reader
About Microsoft SQL Server
Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It supports SQL for managing and querying data and is designed for enterprise-level data storage, processing, and security. SQL Server includes tools for reporting, analytics, and integration with other Microsoft services.
Properties
Tip: To change Reader properties double click on it.
- 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 18 for SQL Server
- 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
Count Number of Records
When user run a transformation, software displays a progress bar and completion percentage.
To calculate this percentage, the software must first determine the total number of records in the source table.This record-counting operation can take a significant amount of time, especially for large tables, and may negatively impact overall performance.
Disabling Count Number of Records prevents the software from counting the records before processing begins, allowing the transformation to start immediately and potentially improving performance.
For more technologies supported by our ETL Software see Advanced ETL Processor Versions
Confused? Ask question on our ETL Forum