/
Winter 4.12 Release Notes

Winter 4.12 Release Notes

Jan 29, 2020

Before you begin

You may need to clear your browser cache before you log into the latest SnapLogic Intelligent Integration Platform (IIP).

See the applicable documentation for your browser:

You may see an Upgrade Notice dialog informing that you will be logged out immediately to complete the update process. Because the SnapLogic platform consists of multiple applications, you will likely see this message a few times.

We recommend that you upgrade your browser to the latest version.

Accounts and Platform updates

Some accounts may have a fixed time for refresh tokens, such as Google accounts that must be refreshed every hour. If that refresh needs to occur when the platform is down for an update, the refresh does not occur. To prevent these accounts from failing after a new platform deployment, it is recommended that you refresh your accounts before the designated down time. If the platform is down for longer than an hour, you will need to refresh those accounts once the platform is back online.

Platform

Enhancements

Designer and Manager 

  • Org administrators now have access to a Recycle Bin to recover deleted pipelines, tasks, or accounts. Previously, you had to contact SnapLogic to recover these items. Deleted items are stored for up to 30 days in the bin.

  • The Mapping Table interface is improved to make it easier to select or deselect multiple fields in a schema.

  • The drop-down lists only Snaplexes associated to a pipeline's project folder, shared Project Space, and the globally shared project folder. This prevents you from choosing a Snaplex that cannot run your pipeline.

  • You can run Snaplex diagnostics on a Windows host to verify your Snaplex host environment and generate an HTML report to help you troubleshoot issues that may occur. For example, you can verify that you have enough disk space on the host to store log files. You can also confirm the availability of IP addresses that the Snaplex uses to communicate with the SnapLogic control plane.

  • If your org is configured for Enhanced Account Encryption, the SnapLogic Create Snap and the SnapLogic Update Snap enable you to create/update accounts when the sensitive fields are provided in plain text. The Snaps will encrypt the data automatically.

  • The user interface in Designer and Manager is updated to present a cleaner, more professional appearance. Essential functions have not changed, but colors, buttons, icons, and tabs have a better look. For example, Snap color gradients are removed to make them easier to read and only default buttons in dialog boxes are highlighted. 

    Snap colors



    Buttons in dialog boxes

General

  • To prevent pipeline processing errors, you can specify a default value to use when a JSONPath is not found. If any part of the path is missing, then the default value is returned.

  • To make it easier to operate on objects dynamically, added support for new Object Methods (keys, entries, and values) in the SnapLogic Expression Language.

  • As with Ultra Pipeline Tasks, Triggered Tasks can now write custom headers and HTTP response codes from the output of a pipeline. This provides more visibility into the completion status of the task. Previously, only an OK status code (200) was returned. 

Snaps

This section provides the Snap updates for the Winter 2018 (4.12) release. This release also includes the patches made to Snaps in the 4.11 release, as listed in the 4.11 Dot Releases page. For information on Snap Pack build versions, see Snap Pack Versions by Release (updated at product GA).

 

New Snap Packs

Reltio: Reltio is a Master Data Management system that enables storing all information at a single place, breaking information silos and managing the master data effectively while also making it accessible in real-time. Reltio Snap Pack is a part of the Enterprise Snap Packs that enables operations on the Reltio instance.

The Reltio Snap Pack includes the following Snaps: 

  • Reltio Create: Create Reltio objects like entities, relations, interactions, and categories in a specified tenant. 

  • Reltio Read (Object): Read Reltio objects like entities, relations, interactions, and categories from the specified tenant.

  • Reltio Read (CrossWalk): Read Reltio entities from the specified tenant.

  • Reltio Bulk Export: Export Reltio entities and relations from tenant to S3 storage. Provides task status and performs task-related operations like pause task, resume task, and stop task.

  • Reltio Delete (Object): Delete all Reltio objects, except interactions, based on object ID and object type from the specified tenant. Supports deleting multiple objects as well.

  • Reltio Delete (URI): Delete all Reltio objects, except interactions, based on the URI from the specified tenant. Supports deleting multiple objects as well.

  • Reltio Merge: Merge two Reltio objects.

  • Reltio Unmerge: Un-merge merged Reltio objects; also supports un-merging composite objects.

  • Reltio Update: Update the Reltio objects (entities and categories) in the specified tenant.

SQS: Amazon Simple Queue Service (Amazon SQS) Snap Pack supports a highly-scalable hosted queue for storing messages. It supports moving data between the distributed application components and tracks the successful completion of the queued messages published independently allowing the decoupling of components in an application.

The SQS Snap Pack includes the following Snaps: 

Updated Snap Packs

Binary:

  • Added File Operation Snap to perform file-related operations like move, copy, and rename within the same server. This Snap supports these file protocols: local (file:///), S3, FTP, SFTP, WASB, and WASBS.

  • Added S3 File Reader Snap to read data from an S3 bucket with versioning support.

  • Updated S3 File Writer Snap to provide suggestions for S3 buckets and file names (versioning support).

Confluent Kafka: Enhanced the performance of the Confluent Kafka Producer Snap in writing incoming documents into the Confluent Kafka cluster.

DB Snaps: The DB Select Snaps are updated with a Match data types property to support matching of the output data types, similar to when the Output field property is empty.

Dynamics CRM: Added the Dynamics CRM Upsert Snap with Batch size property to implement the batching functionality and to route them to the error view when the batch operation fails.

Flow: 

  • Fixed an issue with the Pipeline Execute Snap that could cause the parent pipeline to freeze when the child pipeline fails.

  • Resolved an issue with the Union Snap that caused excessive CPU utilization.

Google BigQuery: Added a new property Schema auto detect in the BigQuery Bulk Load (Cloud Storage) Snap to support CSV and JSON files where one or more columns in the source file may not contain any values.

Google Spreadsheet: Added a new property Batch write in the Google Sheets Writer Snap to enable writing input documents in a single batch in the worksheet (as opposed to writing one cell at a time).

JMS: Added the property Transacted session to the JMS Producer Snap to include the Transacted key in the output view.

Hadoop: Added name service for ORC Reader and Writer.

MongoDB: Added the SSL certification properties to all the MongoDB Accounts to ensure the validation of the certificate.

Azure SQL: Updated the PolyBase Bulk Load Snap to add the Encoding property to enable a user to select the standard for the Input data to load on the database.  

REST: Added Upload body type property to the REST Post [Not Recommended] Snap for processing the specified content type.

SAP:

Salesforce Snaps: 

  • Updated Salesforce SOQL and Lookup Snaps to ensure that they are consistent with SnapLogic guidelines of writing Snap data exceptions to error views and continuing to process next documents vs. hard stopping.

  • Enhanced the Salesforce read operations for the Read, SOQL, and SOSL Snaps to display the original Salesforce error cause, reason, and resolution.

Script: Updated the PySpark Snap to enable users to stop a PySpark job in progress by pressing the STOP button.

SOAP: Added the property Exception To Error View to the SOAP Execute Snap to route the Snap exceptions to the error view.

Transform Snaps: Improved performance for both Aggregate and Join Snaps.