On this page:

Release Highlights

• Data visualization in Data Preview.  
• Three new Snaps in SnapLogic Data Science: Clustering, Match, and Feature Synthesis. 
• Snap execution control in all Snap types.

General Platform Enhancements

• Disabled Snap Functionality: Introduces a fundamental shift in the modes in which your Pipelines are executed. You can now disable a Snap, preventing it–and all downstream Snaps–from executing. This change takes a major complexity out of iterative development of Pipelines. If you have Pipelines with multiple branches, you can now test each branch in isolation without having to copy and import the branch into a new canvas.
  
  
  
  
• Triggered Task Updates: Introduces the following enhancements for running Pipelines as Triggered Tasks:
  • You can access custom HTTP headers during execution through Pipeline parameters.
  • Performance optimizations resulting in improved latency when triggering Tasks through On-premise and Local Override URLs, reducing latency.
• API Management Enhancements: The API Management layer is enhanced to handle at-scale management of APIs (Triggered tasks) configured to run on a Groundplex, as well as add support for OAuth2 authentication flow for APIs. APIM Proxies now support Tasks that are triggered from Groundplexes.
• Enhanced Support for Data Catalog: Enhances data catalog usability by enabling you to infer the Schema of your data using the JSON Formatter Snap. Previously, only metadata from Parquet-formatted files could be written to the Data Catalog. You can now use the following Snap pattern to populate the Data Catalog: JSON Formatter → File Writer → Catalog Insert.
• SFTP connection update for Snaps: Changed the default value for maxSftpChannels field to 2.
• New Expressions: Enhance the SnapLogic Expressions Language by adding the following expressions:
  • HTML.encode()/decode(): Encode/decode strings into and from HTML entities.
  • zipObject(): Returns an object composed from key/value pairs, which accepts two arrays: the first containing only properties and the second containing only values.
  • toObject(): Performs arrow functions on the values of the array to generate the key/value pair in the object returned by the callback. 
  • getMonthFromZero and getUTCMonthFromZero: Returns the month in the specified date (with the option of UTC time) as an integer between 0 (January) and 11 (December).
  • capitalize(), camelCase(), kebabCase(), snakeCase(),lowerFirst(), upperFirst(): Alters characters in your strings.

UI

General

• The session timeout behavior has changed. Until 4.16, if you belonged to multiple Orgs, the shortest idle timeout set in any of the Orgs was applied. With the 4.17 release, the session timeout of the current Org is applied instead.
• Insights data is now automatically aggregated on a daily basis. As such, the Insights Schedule setting has been removed from SnapLogic Manager. 

Designer

• Data Preview Enhancement: Adds the ability to display your data in pie, bar, line, and scatter charts. You can see the entire dataset while navigating through your data records in the paginated tabular view. Apart from offering better controls for navigating through your previewed data Snap by Snap, the enhanced Data Preview form provides multiple options for plotting the various categories of data. You can also select the number of records (up to 2000) that you want to preview through a drop-down menu available on some Snaps.
  

  The Data Preview charts only appear if you are on the latest Snaplex version.

  
  
  
  

• Snaplex Deprecated Version Indicators: Alerts you about using an older Snap Catalog if any Snaplex node is running an older version of SnapLogic. Starting with the May 2019 release, a warning appears if any of your Snaplexes are deprecated. Additionally, in the Snaplex drop-down menu, the deprecated Snaplexes appear in italics, shaded in gray.
  

Manager

• Files: Enhances SnapLogic Manager to support the download of certain file types, such as HTML, JPEG, and PNG files. Additionally, you can now upload multiple files at a time to Manager.
• Notification Enhancements: When you log in as an Org Admin, you can configure notifications in Manager for CPU and Memory usage based on thresholds that you set in Manager.

Dashboard

• Snaplex Deprecated Version Indicators: When you hover over a Snaplex that contains old versions of JCC nodes, a warning message appears indicating the deprecated version of the JCC node. When you click the Snaplex, the Details pop-up for that Snaplex displays a note recommending the latest SnapLogic version.

Snap Enhancements

Updated Snap Packs

Binary Snap Pack

• Enhanced the Binary Snap Pack to support SMB versions 2.0 and 3.0.
• Added two properties, Number of retries and Retry interval. Use these to manage retry attempts to the following Snaps in case of network failures:
  • Directory Browser
  • File Delete
  • File Poller
  • File Reader
  • File Writer
  • Multi File Reader
  • S3 File Reader
  • S3 File Writer
  • ZipFile Read
  • ZipFile Write

Confluent Kafka Snap Pack and Hadoop Snap Pack

• The Snap Packs are tested and certified against CDH 6.1.

Database Snap Packs

• Fixed an issue with the Database Execute-type Snaps wherein the Snaps would send the input document to the output view even if the Pass through field is not selected in the Snap configuration. With this fix, the Snaps send the input document to the output view, under the key original, only if you select the Pass through field. The impacted Snaps are:

  • Azure SQL - Execute

  • Cassandra - Execute

  • Generic JDBC - Execute

  • Hive - Execute

  • MySQL - Execute

  • Oracle - Execute

  • PostgreSQL - Execute

  • Redshift - Execute

  • SAP HANA - Execute

  • Snowflake - Execute

  • SQL Server - Execute

  • Teradata Execute

  • Vertica - Execute

Hive Snap Pack

• Added a new authentication method, User ID and Password with SSL, for Hive SSL Accounts which allows SSL connections for valid user name and password credentials.
• Certified and tested the Snap Pack against CDH 6.1.

ML Analytics Snap Pack

• Profile: Added an optional second output view. When enabled, this outputs a graphical representation of the Snap's first output as a HTML file.

ML Core Snap Pack

• AutoML: Enhanced the AutoML Snap. You can now:
  • Select algorithms to derive the top models.
  • Input the best model generated by another AutoML Snap from a previous execution.
  • View an interactive HTML report that contains statistics of up to 10 models.
• Clustering: New Snap that performs exploratory data analysis to find hidden patterns or groupings in data.

ML Data Preparation Snap Pack

• Feature Synthesis: New Snap that automatically creates features out of multiple datasets that share a one-to-one or one-to-many relationship with each other. Features are measurements of data points. For example, height, mean, mode, min, max, etc.
• Match: New Snap that identifies matched records across datasets that do not have a common key field.

NetSuite Snap Pack

• NetSuite is enforcing two-factor authentication (2FA) for credentials-based accounts and advises that all web-based integrations transition to token-based authentication. To support this transition, NetSuite Credentials account will be deprecated, and we recommend that you either create or switch to NetSuite Token account immediately, so that all SnapLogic Pipelines continue to work without any disruption.

REST Snap Pack

• Added support for OAuth 1.0 accounts, which enable you to connect to applications that require OAuth 1.0.

ServiceNow Snap Pack 

• ServiceNow Insert and ServiceNow Query: Added Batch Size field that enables you to configure the number of documents that you want to process per batch. You can configure the Batch Size for Ultra Tasks as well.

Transform Snap Pack

• JSON Formatter: Added the Derive schema from sample size menu option, whereby you select the sampling size of the schema from the data source.
• Mapper: Added the capability to select either document (previously supported) or binary data (new) for your input and output views.

Snap Execution Enhancement Impacts all Snaps

This release renames the Execute During Preview field as Snap Execution for those Snaps where the field exists and introduces a drop-down menu called Snap Execution for all other Snaps. This field allows you to enable (full or limited) or disable Snap execution.

Known Issues

Platform/UI

• If you click a Pipeline link, SnapLogic Designer opens the Pipeline only if you are in the Org that corresponds to the Pipeline. Otherwise, an Org change is implemented, and an empty workspace appears. The workaround is to paste the link in the browser URL bar to open the Pipeline.
• You might experience performance issues running ground triggered Pipelines that have Pipeline Execute Snaps when the child Pipeline runs on a different node.
• The JSON View and Table View are incorrect for new line character (\n) in the Snap output preview.
• When the output document contains too many columns, the dropdown list in DataViz view of the Data Preview fails to show all of the columns when you should be able to scroll through all of them.
• If you create a Pipeline with a File Reader Snap left open while creating a second Pipeline with the File Writer Snap open, you receive the following error message when saving the second Pipeline: 


Try again or refresh the page. If error continues to occur, please contact customer support.
sl.ibm.saveAll() Threw an unexpected error: "TypeError: Converting circular structure to JSON".

  Clicking OK results in the following error:

Refresh the page to try reloading your workspace. If the error continues to occur, please contact customer support.
Uncaught TypeError: Cannot read property 'class_id' of undefined.

Snaps

• In the Email Reader Snap, when you specify the full file path in the Attachment Folder field and you select Rename in the File Action field, you receive the following error message:  Failed to retrieve messages.

• Soap Execute Snap does not evaluate expressions for the Attachments properties, even when the expressions are enabled.
• ServiceNow Snaps do not work with Ultra Pipelines/Tasks.
• Snowflake Lookup Snap fails to retrieve table column details in Lookup column name when the same table name exists in another database in Snowflake.
• Redshift Insert Snap fails to create a table with a 2nd input view when the input documents contain NCHAR/BPCHAR (fixed length character string) data type column data.

UAT Delta

4.17 Dot Releases