Microsoft SQL Server
Microsoft SQL Server is a popular relational database management system. As a database server Microsoft SQL Server stores and retrieves data which may run either on another computer across a network or on the same computer, requested by other software applications.
Type Name
sqlserver
Connection Properties
Template name: mssql
Appropriate translator name: sqlserver
Properties:
host(default:localhost)port(no default; for connection to a Microsoft SQL Server with dynamic port allocation configured,instanceNameneeds to be provided viajdbc-properties)dbuser-namepassword(default: empty)- encrypt (default:
FALSE; enables connection encryption and has the same possible string value as the corresponding SQL Server JDBC driver property:TRUE,FALSE, andSTRICT) driver(default:com.microsoft.sqlserver)driver-class(default:com.microsoft.sqlserver.jdbc.SQLServerDriver)jdbc-properties(arbitrary extra properties)new-connection-sql(default:SET ANSI_WARNINGS OFF)check-valid-connection-sql(default:select 1)min-pool-size(default:2)max-pool-size(default:70)
Translator Properties
Translator Properties Specific for MS SQL
| Name | Description | Default value |
|---|---|---|
uploadMode | Values:
| standard |
maxChunkSize | Sets the approximate size in bytes for batches created | |
numberOfThreads | Number of threads for the bulkInsertMultiThread mode | 3 |
singleTransactionInsert | Value: boolean. When set to | TRUE |
supportsFullOuterJoins | If outer joins are supported, TRUE indicates that FULL OUTER JOINs are supported | TRUE |
supportsOrderByString | Support indicates connector supports ordering by strings | TRUE |