Key New Features in SnapLogic

API Management:

Added Developer Portal Accounts and Subscription Manager.
Added Subscription Key Management.
Added improvements for editing and viewing API Specifications.

Developer Portal:

Added Featured API category to help discover and promote APIs.
Support for creating developer accounts to access the catalog and create subscriptions.
Support for creating Applications and subscribe to APIs.

New Snaps/Accounts:

Added Amazon SNS Snap Pack.
Added OAuth Account for Salesforce Snap Pack.
Support for Mutual Authentication in Salesforce Snaps.
Support for Azure Service Bus and Exact Online (coming soon).

ELT for Cloud Data Platforms:

Support for Google BigQuery as a target database.
Support for MERGE INTO ALL option and automatic source table aliasing in ELT Merge Into Snap.

SnapLogic Flows:

Flows is specifically built for business users to more easily automate business processes. Flows greatly simplify integrations for business users while allowing IT to maintain control of security and governance.
Support for new endpoints: Microsoft Dynamics 365 Sales, Microsoft Teams, Microsoft SharePoint, ServiceNow, and SnapLogic Read/Write to Pipeline.
Support for unified error handling for efficient troubleshooting.
Refreshed homepage with improved performance.

Flows is available to you free with your current SnapLogic subscription, but only for a limited time. To get started, register for Flows.

4.27 UAT Delta

This section tracks the changes made during the iterative pushes to the UAT server and the GA release. The following is the release schedule:

UAT 1: Friday, Oct 29, 2021 – Snaplex version: 4.27_rc-10694 - 4.27
UAT 2: Friday, Nov 5, 2021 – Snaplex version: 4.27_rc-10694 - 4.27
GA: Saturday, Nov 13, 2021 – Snaplex version: main-10704 - 4.27 GA

The SnapLogic GA release build on the production server is also deployed on the UAT server.

Important

Per the SnapLogic Release Process, all remaining Snaplex instances across Orgs are auto-upgraded to the recommended version (main-10919 4.27 Patch 3) at 9 p.m. PT on Saturday, Jan 8, 2022. Orgs migrated to the 4.27 GA version prior to the auto-upgrade are not impacted.
The Snaplex upgrade process also upgrades the Java version to the latest version. After the upgrade, the Java version of your Cloudplex nodes may not be the same as your FeedMaster nodes. However, this does not impact the operations of your SnapLogic instance. We will be fixing this issue in a subsequent release.
To use the new SnapLogic features and Snaps in the 4.27 release, ensure that your Snaplex nodes are upgraded to the main-10704 (Recommended) version.
This 4.27 release includes the patches deployed to SnapLogic after the 4.26 release, as listed in the 4.26 Dot Releases section.

4.27 Dot Releases

Platform

Log4j upgrade: You need to restart your Snaplex monitor process using jcc.sh restart to update the monitor process and use the latest Log4j version.

Date of Update	Snaplex Build	Update

Date of Update	Snaplex Build	Update
Feb 7, 2022	main-11121 4.27 Patch 4	Upgraded to Log4j version 2.17.1.
Dec 20, 2021	main-10919 4.27 Patch 3 (Recommended)	Upgraded to Log4j version 2.17.0. Fixed an issue with Patch 2 that could cause some Pipeline Execute Snap instances to hang.
Dec 16, 2021	main-10904 4.27 Patch 2	Fixed a potential vulnerability issue regarding Log4j. Upgrading to Log4j 2.16.0 fixed this issue by removing support for message lookup patterns and disabling JNDI functionality by default. Some Pipelines may hang, where the parent and child Pipelines run on nodes having different Snaplex versions, causing the Snaplex to effect a rolling restart. We plan to release a patch next week to address the above issue.
Dec 10, 2021	main-10894 - 4.27 Patch 1	Fixed an issue with the Log4j 2 (Java logging library) that affected Java applications. For additional details, see our Community blogpost.

UI

Date of Update	Update

Date of Update	Update
Dec 9, 2021	Fixed an issue where Snowflake and SQL Server account types were not appearing in Snaps. Fixed an issue where whenever a Task is updated, such as changing its Run Policy, Notifications or Debug Settings, the task reverts all parameters to the parent Pipeline default parameters.
Nov 23, 2021	Fixed an issue where null or empty parameters were being overwritten by the default Pipeline parameters on the subsequent task update. This could cause a problem if you were updating tasks where you set the parameters to null/blank, but needed to update something else on the task. For the triggered task, the empty values are now retained upon updating any fields.

Snaps

Snap Pack	Date of Update	Snap Pack Version	Updates

Snap Pack	Date of Update	Snap Pack Version	Updates
Marketo	Feb 4, 2022	427patches13147	Fixed an issue with the Asset Read, Lead Read, and Asset Write Snaps where the original payload was not passed through to the error view.
Marketo	Feb 2, 2022	427patches12999	Fixed an issue where the Bulk Lead Extract and Bulk Lead Upsert Snaps failed when the Snaplexes were proxy-enabled.
Salesforce	Jan 27, 2022	427patches14079	Fixed an issue with the Salesforce Subscriber Snap where the Snap was unable to re-subscribe to a topic if it did not receive any message for 72 hours — it stopped and displayed an error message. With this fix, the Snap automatically sets the Replay ID value to -2 when: the specified Replay ID is invalid or outside the retention window. the CreatedDate of the most recent event received by Snap is outside the 72-hour retention window.
Hadoop	Jan 25, 2022	427patches13769	Fixed an issue with the Hadoop Directory Browser Snap where the Snap was not listing the files in the given directory for Windows VM.
Binary	Jan 21, 2022	427patches14283	Fixed an issue with the Binary Snaps where the Snaps could not re-establish a lost connection to the SMB mount point. Enhanced the S3 File Writer Snap with the Suggest fully-qualified file names checkbox that allows you to use fully-qualified file names in the File name Suggestions list for gov cloud instances. Fixed an issue with the File Poller Snap to handle poor performing polling operations. Fixed an issue with the ZipFile Write Snap where the ZIP extension files were downloaded with an incorrect file extension. Fixed an issue with the Zip File Read Snap where a zip file from SMB failed to uncompress due to the limited compatibility of Java unzip utility, which is now replaced with Apache unzip utility. Fixed an issue with the File Writer Snap when a file greater than 10MB failed to write when uploading to Google Storage. Upgraded the Google Cloud Storage Java Library from version 1.105.1 to version 2.2.2.
Amazon SQS	Jan 20, 2022	427patches14012	Fixed an issue in the SQS Consumer Snap where the Snap did not read message attributes when the Client-side buffering checkbox is selected.
Azure Service Bus	Jan 13, 2022	4.27patch14048	Introduced the Azure Service Bus Snap Pack— a cloud messaging service that connects applications, devices, and services running in the cloud to any other applications or services. This Snap Pack offers the following Snaps: ASB Acknowledge ASB Producer ASB Consumer
Transform	Jan 12, 2022	427patches12966	Enhanced the Avro Formatter Snap to display meaningful error message while processing invalid and null values from the input.
Google BigQuery	Jan 12, 2022	427patches13752	Upgraded Google BigQuery driver to 1.119.0 version to support time partition intervals by MONTH and YEAR.
SAP	Jan 12, 2022	427patches13992	Upgraded the Java Native Library used by the SAP Java Connector (JCo) to version 3.1.4. Breaking change for Pipelines containing Snaps from the SAP Snap Pack with Java Native Library This upgrade may cause your existing Pipelines to break if they contain Snaps from the SAP Snap Pack. You must manually upgrade your SAP Java Connector (JCo) Native Library to version 3.1.4 for these Pipelines to run successfully. See SAP Configurations for more information. Enhanced the SAP Execute Snap to support nested tables or structured data in the BAPI function module's import parameters.
ELT	Jan 7, 2022	427patches13923	Fixed an issue with the ELT SCD2 Snap where the Snap did not equate null values in the corresponding cause-historization rows of both the source and target tables (with no changes to data in the remaining fields) as the same and produced duplicate rows in the target table, as a result. After this fix, the Snap does not cause any new duplicate rows in the target table. Fixed an issue with the ELT Load Snap where the Snap fails with the error `Database encountered an error during Bulk Load process` when you specify a CSV file to load data from, with the Load Action as Alter Table. The Snap now performs the specified ALTER TABLE actions—ADD/DROP columns—and loads the data into the target table accordingly (without the need to manually modify the source or target tables beforehand).
ML Core ML Data Preparation	Jan 7, 2022	427patches13948	Fixed an issue with the following Snaps, where a deadlock occurred when data is loaded from both the input views. Predictor Classification Predictor Regression Clustering Principal Component Analysis
ML Analytics	Jan 6, 2022	427patches13292	Fixed an issue with the Profile Snap, where the Snap failed to create a temporary directory as the temp file path exceeded 255 characters.
PostgreSQL	Jan 6, 2022	427patches13149	Fixed an issue with the PostgreSQL - Execute Snap, where the Snap failed when using the Delete query with the RETURNING function.
Salesforce	Jan 5, 2022	427patches13944	Fixed an issue with Salesforce accounts, where an account password containing special characters and an empty security token was improperly encoded, due to which the account was not validated.
NetSuite	Dec 31, 2021	427patches13080	Fixed an XML parsing issue with empty elements for the NetSuite Snaps.
Salesforce	Dec 23, 2021	427patches13789	Fixed the following issues with the Salesforce Snaps: High memory use due to leaked resources. Hung Pipelines due to blocked threads.
Redshift	Dec 20, 2021	427patches12999	Fixed an issue with the Redshift Bulk Load Snap, where the temporary files in S3 were not deleted for aborted or interrupted Pipelines.
Exact Online	Dec 17, 2021	427patches (main96)	Introduced the Exact Online Snap Pack that enables businesses to automate operations in a single flexible subscription, improve business results, and maximize data security. This Snap Pack offers the following Snaps: Exact Online Read Exact Online Create Exact Online Update Exact Online Delete
SAP S/4 HANA	Dec 17, 2021	427patches (main95)	Enhanced the SAP S/4 HANA Snaps to support sub-entities and pagination support. Removed unnecessary datatype conversions. Reduced metadata request volume. Fixed issues in concurrency exception (exceptions that arise when two users attempt to change the same data in a database simultaneously) and potential Snap crashes.
Google BigQuery	Dec 16, 2021	427patches13615	Fixed the table truncate 404 error in the Google BigQuery Load (Streaming) Snap by supporting the retry functionality. The Snap now waits in case of an error and retries before loading the data.
ELT	Dec 13, 2021	427patches13539	Fixed an issue with ELT SCD2 Snap where the Snap fails when you define more than one TargetTable Natural Key in the Snap configuration to load SCD2 data into the target Cloud Data Warehouse instance. Fixed an issue with the ELT SCD2 Snap where the Snap failed to update the previous current rows in the target SCD2 table to historical rows when you define an End Date of Historical Row in Target Table Temporal Field(s). Fixed an issue with the ELT SCD2 Snap where the Snap failed to insert new rows when you define the values that exist in the most recent historical rows of the target SCD2 table as the cause-historization values. Fixed an issue with ELT Transform Snap where the Snap does not omit the source columns marked for removal from the output view—using an empty Target Path for one or more columns selected in the Expression field of the Snap’s Mapping Table. See Using Empty Target Paths to Omit Rows from the Snap Output to understand how to perform this operation.
Splunk	Dec 7, 2021	427patches13429	Updated the Splunk Basic Auth account with the following: Fixed the connection failure issue when connecting to a cloud-based Splunk instance by not adding the prefix `'input-'`to the hostname. Removed the On-premises checkbox from the Snap Account settings.
Binary	Dec 6, 2021	427patches13004	Fixed an issue with the SMB Account in Binary Snaps where the Snaps could not re-establish a lost connection to the SMB mount point.
NetSuite	Dec 2, 2021	427patches13072	Fixed an issue with the NetSuite Search Snap where the Snap failed when the body is not present in the SOAP request.
REST	Dec 1, 2021	427patches12750	Enhanced the REST Put Snap with the Upload Transfer Request Type field to support encoding of chunked data transfer and calculating content length.
Anaplan	Nov 29, 2021	427patches13160	Fixed an issue with the Anaplan Snaps, where the log messages were stored in `jccoutput.log` file instead of `jcc.json` file, and updated the dependent libraries.
Transform	Nov 15, 2021	main12989	Fixed an issue with the Group by Fields Snap that caused the Snap to abort with an error when executed with zero input documents.
REST OpenAPI	Nov 15, 2021	main12989	Fixed an issue with the REST OAuth2 and OpenAPI OAuth2 accounts that caused a new feature, OAuth Password Grant Type, to be excluded from the 4.27 GA version.
ELT	Nov 20, 2021	427patches13030	Fixed the following issues with the ELT SCD2 Snap: Where the Snap failed to get the right data type due to column name case mismatches between what is used in the Snap and what is actually used in the Azure Synapse tables (returned by the JDBC driver). You no longer need to type the column names in the exact case that Azure Synapse expects. The Snap failed with the error `start_date does not exist` while writing SCD2 data to a Redshift table column start_date that is specified as the Start Date of Current Row in the Target Table Temporal Field(s) field set. The Snap failed with the error `Reference 'END_DATE' is ambiguous` while merging SCD2 updates into DLP tables. Where the Snap failed due to lack of required access privileges on the target database (for example, create table rights to create temporary tables as needed). The Snap now runs the input SQL statement and the elaborate sub-queries instead of attempting to create a temporary table in such scenarios. Fixed the issue with the ELT SCD2 and ELT Load Snaps that fail to perform an add/drop operation involving multiple columns on a Redshift target table.
SAP	Nov 23, 2021	427patches12999	Enhanced SAP RFC Listener, SAP IDoc Listener and SAP IDoc Document Listener Snaps with a new field set Advanced JCo Server Properties that allows you to configure Java Connector (JCo) server-related attributes.
Google BigQuery	Nov 24, 2021	427patches12691	Fixed an issue with the Google BigQuery Bulk Load (Cloud Storage) Snap, where the Snap failed with an exception for big query tables. The `CreateDisposition` is now set conditionally on the basis of the setting in Create table if not present checkbox.