


To learn more, see Types of Incremental Loads. The Microsoft SQL Server (jTDS) Connector supports two types of incremental loads, including support for using a numeric column. The Microsoft SQL Server (jTDS) connector supports the following Incorta specific functionality: Feature When Incorta loads data from a SQL database using the SQL Server (jTDS) connector, it uses the jtds-1.3.1.jar driver. About The Microsoft SQL Server (jTDS) Connector Incorta can connect to a Microsoft SQL Server database using either the Microsoft JDBC driver or the jTDS JDBC driver for SQL Server.įor more information about connecting to a Microsoft SQL Server database using the Microsoft JDBC driver, see Microsoft SQL Server Connector. Similar to other common RDMSs, Microsoft SQL Server uses Transact Structured Query Language (T-SQL) statements to perform tasks such as inserting, updating, deleting, or retrieving data from a database. The primary function of Microsoft SQL Server, as a database server, is storing and retrieving data requested by other software applications. Microsoft SQL Server is a relational database management system (RDMS).
