SQL Server Snap Pack

In this article

Overview

Use the SQL Server Snap Pack to read and write objects from your SQL Server database. 

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.

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.

  • 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.

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.

Support Versions

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

  • 11.00.2100

  • 12.0.20008

  • 13.0.4224.16

  • 14.0.1000.169 (Windows AD)

  • 16.0

  • This Snap Pack supports SQL Server 2008 to 2016. 


Snap Pack History

Release 

Snap Pack Version

Date

Type

Updates

November 2024

main29029

Nov 13, 2024

Stable

Updated and certified against the current SnapLogic Platform release.

August 2024

438patches28829

Nov 5, 2024

Latest

Reinstated support for the jTDS driver in the SQL Server Snap Pack.

August 2024

main27765

Aug 21, 2024

Stable

Updated and certified against the current Snaplogic Platform release.

May 2024

437patches27732

Aug 14, 2024

Latest

Fixed an issue with the SQL Server - Select Snap configured with an Ultra task to handle temporary database unavailability. The Snap now validates the database connection to ensure that it is reestablished after temporary database outages.

May 2024

437patches27328

Jul 30, 2024

Latest

Fixed an issue with the SQL Server Insert Snap that caused an error when inserting the infinity value into a decimal-type column.

May 2024

437patches27091

Jul 5, 2024

Latest

Fixed a case-sensitivity issue with the SQL Server—Bulk Load Snap that caused a NullPointerException when retrieving the PATH environment variable in a Windows environment. This change is applicable only to Windows, as environment variables are case-sensitive in Linux.

May 2024

main26341

May 8, 2024

Stable

Updated the Delete Condition (Truncates a Table if empty) field in the SQL Server - Delete Snap to Delete condition (deletes all records from a table if left blank) to indicate that all entries will be deleted from the table when this field is blank, but no truncate operation is performed.

February 2024

436patches26177

Apr 24, 2024

Latest

  • Fixed an issue with the SQL Server Snap Pack that displayed an error when numeric values with scale 0 were inserted into the database with DECIMAL or NUMERIC type columns, instead of inserting the value with decimal digits truncated.

  • Fixed an issue with the SQL Server Snap Pack that displayed an error when fractional numeric values (numbers with a decimal point) were inserted into the database with an INT type column, instead of inserting the value with decimal digits truncated.

February 2024

436patches25757

Apr 3, 2024

Latest

Fixed an issue with the SQL Server - Insert Snap that previously displayed an error when attempting to insert a true or false value into a TinyInt datatype. The Snap now correctly inserts 1 or 0 for true or false in the table, respectively. 

February 2024

436patches25548

Mar 21, 2024

Latest

  • Added support for XML and spatial types (Geography and Geometry) for SQL Server Snap Pack.

  • Fixed an issue with the SQL Server - Insert Snap that displayed an error when an empty or blank string was passed as a value to an integer-type column.

February 2024

main25112

Feb 14, 2024

Stable

As of main25112, the SQL Server Snap Pack no longer supports the jDTS driver. If you are using the latest SQL Server driver versions (2014 and higher), we recommend you use the driver that is bundled with the SQL Server Snap Pack. Note that the older SQL Server versions are supported as is.

November 2023

main23721

Nov 8, 2023

Stable

Updated and certified against the current SnapLogic Platform release.

August 2023

434patches22758

Sep 11, 2023

Latest

Fixed an issue with the SQL Server Stored Procedure and Table List Snaps that caused no retries to be executed even if you select the number of retries in the UI when a custom JDBC driver was used.

August 2023

434patches22579

Aug 22, 2023

Latest

Improved the SQL Server Bulk Load Snap to reduce the chance of causing a deadlock error.

August 2023

main22460

Aug 16, 2023

Stable

The SQL Server - Execute Snap now includes a new Query type field. When Auto is selected, the Snap tries to determine the query type automatically.

May 2023

433patches22090

Aug 8, 2023

Latest

The SQL Server Stored Procedure and SQL Server Table List Snaps now support the retry functionality.

May 2023

433patches21808

Jul 13, 2023

Latest

  • The SQL Server Snap Pack is upgraded to the latest version of the Microsoft JDBC Driver 12.2.0.jre11 for SQL Server:

    • Pipelines using the default JAR in the SQL server accounts might fail after the driver upgrade because the latest driver is backward-incompatible. To prevent your accounts from failing, reconfigure the URL properties field in account settings as follows:

      trustServerCertificate = true

    • Pipelines NOT using the default driver (bundled with the SQL Server Snap Pack) will not fail.
      Note: This update will be a part of the stable distribution with the GA release on August 9, 2023.
      Learn more about the SQL Server driver upgrade: FAQ for Upgrading to SQL Server JDBC Driver 12.2.0

  • Fixed an issue with the SQL Server Insert Snap that was causing performance degradation between GA release 4.32 and 4.33 if the network connection between the Groundplex and the database server was slow.

May 2023

433patches21386

Jun 8, 2023 

-

The SQL Server Snap Pack is upgraded to the latest version of the Microsoft JDBC Driver 12.2.0.jre11 for SQL Server:

  • Pipelines using the default JAR in the SQL server accounts might fail after the driver upgrade because the latest driver is backward-incompatible. To prevent your accounts from failing, reconfigure the URL properties field in account settings as follows:

    trustServerCertificate = true

  • Pipelines NOT using the default driver (bundled with the SQL Server Snap Pack) will not fail.

May 2023

433patches21119

May 15, 2023 

Latest

Updated the Bulk Load Snap to preserve empty strings as empty strings and null as nulls.

May 2023

main21015

May 10, 2023 

Stable

Upgraded with the latest SnapLogic Platform release.

February 2023

main19844

Feb 9, 2023