SQL Server

SQL Server Snap Pack performs read and write objects from your SQL Server database.
Note: The SQL Server Snap Pack supports Geospatial data types (Geography and Geometry). This Snap Pack enables you to insert, read, and select Geospatial data types within the SQL Server database.
Note:

  • TIMESTAMP datatype in SQL Server is not supported. According to the Microsoft official document, "The timestamp syntax is deprecated. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature."

  • The SQL Server Snaps express time up to the millisecond for date/time values, for example, 2019-11-05T00:34:55.007.

  • This Snap Pack supports the jTDS driver.

Use Snaps in this Snap Pack to:

  • Get a list of tables in a database.

  • Lookup records in the target table and return a selected set of fields.

  • Fetch data from a database.

  • Execute SQL statements to delete, update, merge, or insert data into a specified table.

Important: The SQL Server Snap Pack is upgraded to the Microsoft JDBC Driver 12.2.0.jre11. Existing pipelines that do not use the default driver (bundled with the SQL Server Snap Pack) are not impacted. If you want to use NTLM or other authentications with the latest default driver (where the DLL file is mandatory), then you must copy the DLL file to the Snaplex path.

Prerequisites

A valid SQL Server account with appropriate permissions to access the database.

Supported versions

This Snap Pack is tested against the following SQL Server versions:

  • Older versions:

    • 11.00.2100

    • 12.0.20008

    • 13.0.4224.16

    • 14.0.1000.169 (Windows AD)

    • 16.0

  • New versions:

    • 2008

    • 2016