In this article:

Platform Enhancements

General

• Kubernetes Support: You can now deploy your Snaplex instances in a Kubernetes environment using Helm Charts. This support enables you to benefit from containerized technology through the resource efficiency and automated operations that Kubernetes container-orchestration system provides.
  
  
• Scheduled Task Notifications: Improving the mechanism for triggering email notifications when an error occurs in Scheduled Tasks. Previously, even if you configured a notification, Scheduled Task failures did not trigger email notifications under all failure conditions. With this release, you might see an increase in failure notifications because of this improvement. For example, if permissions are modified after a Scheduled Task is set up, then the Pipeline called by the Task can no longer execute, triggering an email notification.
  
  

• Modifying Shared Objects: Enhancing Pipelines Executions Statistics to display a warning message when you attempt to modify an object shared between multiple documents. Sharing primarily occurs with the $original object when a Snap outputs multiple documents for a single input. For example, an SQL Select Snap that matches multiple rows for a single input document produces documents where, for each entry, $original refers to the same object. With this release, if you follow that SQL Select Snap with a Mapper Snap that writes to a property in $original, a warning message appears in the Execution Statistics window. Since modifying a shared object can lead to inconsistent results, you must copy the object. 

  Benefit to Sharing $original Objects

  The $original objects are shared for performance reasons. Copying them for every output document can be resource intensive.

• Ensuring Backward Compatibility with JDK 9 and Upwards: If your Snaplex is using JDK 8u181 or higher, your existing Active Directory Pipelines are likely to break with a Failed to validate account error. This is because Java's Improved LDAP Support security enhancement enables endpoint identification on LDAPS connections by default.

  Workaround:

  Set the JVM option com.sun.jndi.ldap.object.disableEndpointIdentification to true in your Snaplex's node properties (Global properties). This disables endpoint identification. You may have to contact your SnapLogic Organization Admin to include this setting. 

API Management Enhancements

Enhancing the SnapLogic API Management with the following API proxy features:

• Request Size Limiting: Support for blocking API requests that attempt to pass a payload size beyond a specified limit. Such requests can affect critical backend systems. This policy enables you to restrict the payload size in the API response. 
  
  
• Update Proxies: Support for editing the following configuration properties in a Proxy:
  
  • Modify Policies
  • Modify the APIs included in the Proxy

The update functionality makes it easier for you to modify the endpoints and policies in your Proxies while retaining the same Proxy name. Previously, to update a Proxy, you would have had to create a new Proxy with a different name.

Known Issues

• Importing a synthesized Pipeline through Pipeline recommendations may cause an error. Use the Replace option instead.
  

Previous Dot Releases in 4.19 - Platform

The following 4.18 Platform Dot Release updates are now a part of the 4.19 release:

UI Enhancements

Designer

• New UI Form: Introducing a new UI form as an opt-in feature for Snap configuration. Besides a new look, the new UI form offers an improved user experience and reduced latency. To enable the new UI form, select the New Form UI checkbox on the User Settings menu in SnapLogic Designer. Additionally, in the Mapper Snap integrates the AutoLink feature (formerly, SmartLink) in the same Infobox popup.
  

• Data Preview: Enhancing the Data Preview feature with the addition of the Formatted checkbox. This functionality enables you to format document data with line-feeds that would otherwise be ignored, and increase the readability of this data in table/JSON modes. When viewing error documents that have a stack trace column in JSON/table mode, you can select Formatted to view this information easier.

• SnapLogic Cloud Pattern Search and Preview

  • Introducing SnapLogic Cloud Pattern Catalog Search. You can now search the extensive set of Pattern Pipelines from SnapLogic and preview Pattern Pipelines that match your search criteria. You can either use a Pattern Pipeline to create a new Pipeline or copy its contents into an existing Pipeline.
    

  • Creating Branched Pipelines Using Pipeline Recommendations

    You can now create complex branched Pipelines using SnapLogic's Pipeline Recommendations feature. Just provide a start Snap, an end Snap, and an intermediary Snap and let Iris AI recommend Pipelines that connect all the three Snaps in a specified order.

    

Manager

• Snaplex Notifications: Adding a Snaplex drop-down list for Notifications for ease of use. You can now set notifications for your Snaplex instances without having to look up the name in the Designer or Dashboard. When you configure a Snaplex notification, a drop-down list of Snaplex names appears.

  

Dashboard

• Error Messages and Logs: Enhancing the troubleshooting experience in the SnapLogic Dashboard. Logging for JCC nodes is optimized so that duplicate or similar logs are filtered out, enabling you to find unique errors more quickly when you click View Details on the Snap Statistics tab in the Pipeline Executions Statistics popup.

Developer Portal

• Logo and Banner Customization: Introducing the ability to customize your API Developer Portal. You can now add your own organizational logo and banner text to the Developer Portal from API Manager. Since the Developer Portal serves as the public catalog for your users to consume APIs, you can now customize the look to reflect your organization's branding.

  

Known Issues

General

• Clicking the Execute button in the Try it section on the API tab of a Proxy might cause the Proxy window to abruptly close.

• When configuring an account for a database Snap, the Search field is not enabled in the the drop-down list.

New UI Form

• The Workday Reader Snap does not work with the New UI Form enabled because the accounts cannot be validated.

• Leaving mandatory fields blank while configuring a Snap or its account, and then clicking Save should display an error message but does not when the New UI Form enabled.

Previous Dot Releases in 4.19 - UI

The following 4.18 UI Dot Release updates are now a part of the 4.19 release:

Snap Enhancements

General

• AutoLink (formerly, SmartLink): Enhances the AutoLink feature to simplify the mapping of data by suggesting Input Schema mapping to the Target Schema in the Mapper Snap. The SnapLogic platform uses a combination of algorithms to derive mapping suggestions. AutoLink feature enables you to:
  • Filter mapping suggestions based on a score threshold.
  • Get the best mapping recommendations.
  • Map nested schemas easily as the machine learning model has higher flexibility for mapping nested schemas.
  • Preview and refine the matches.

• SnapLogic B2B Integration: Leverages SnapLogic's capabilities to integrate the EDI gateway of 1 EDI Source with another EDI gateway or B2B solution. You can integrate with multiple applications supported by SnapLogic, such as NetSuite, SAP, and Oracle.

New Snap Pack

• Coupa: We now integrate with Coupa's business spend management application. This Snap Pack includes the following Snaps:
  
  • Coupa Create: Create Coupa resource records.
  • Coupa Read: Fetch Coupa resource records.
  • Coupa Update: Update Coupa resource records. You can also deactivate Coupa resources using this Snap. 

Updated Snap Packs

• SOAP 
  • Introduces the Library API field to the SOAP Execute Snap to enable execution over HTTP. The supported libraries are Apache HttpComponents and Apache CXF, and both the libraries support the Message Transmission Optimization Mechanism (MTOM). 
    
  • Adds a new field, Allow duplicate headers, in the SOAP Execute Snap. Enabling this field allows duplicate headers value; if disabled, the last value of the duplicate header key is used.
    
    

• Azure SQL: Enhances the error handling in PolyBase Bulk Load Snap when writing to a data warehouse. The Snap writes a new blob in the Azure container. This new blob highlights the first invalid row that caused the bulk load operation to fail.
  
  
• Binary
  • The Key Passphrase field is now a mandatory field for the SSH Auth account. This update does not impact existing accounts and Pipelines. However, if you update existing SSH accounts or create a new account, then the passphrase is required. 
  • Raises the minimum buffer size in the S3 File Writer Snap to 6 MB.
    
    
• SnapLogic Metadata: The /wiki/spaces/AP/pages/1438762 now features the Normalization checkbox, which, when selected, makes Pipeline comparisons easier.
  
  
• ML Data Preparation: Introducing the Deduplicate Snap. Use this Snap to remove duplicate records from input documents. When you use multiple matching criteria to deduplicate your data, it is evaluated using each criterion separately, and then aggregated to give the final result.
  
  
• Transform Snap Pack: The output of the AVG function in the Aggregate Snap now rounds up all numeric values that have more than 16 digits.
  
  
• NetSuite: Supports NetSuite version 2019.1. While this does not impact any of your existing Pipelines, you can use the following WSDL configurations in your SnapLogic NetSuite accounts to benefit from this version's capabilities:
  • WSDL Year: 2019
  • WSDL Release: 1
  • WSDL Patch: 0
    
    
• PostgreSQL: Adds new Snap, PostgreSQL Bulk Load, to support bulk load operations.
  
  
• Salesforce: Introduces an account type Salesforce.com OAuth2 and the following Snaps that support the Bulk API v2.0:
  • Salesforce Bulk Create: Adds new Salesforce records.
  • Salesforce Bulk Update: Updates Salesforce records.
  • Salesforce Bulk Upsert: Updates or inserts Salesforce records.
  • Salesforce Bulk Delete: Deletes Salesforce records.
    
    
• Snowflake
  • Enhances the Snowflake SCD2 Snap to support auto-historization of column data by adding a new field-set, Auto Historization Query. You can now detect whether the incoming record is a historical event or a current event.
  • Raises the minimum buffer size in the Snowflake - Bulk Upsert and Snowflake - Bulk Load Snaps to 6 MB.
    
    
• Workday: The Workday Write Snap now provides a Validate Only Load check box, which enables users to upload–and then manually validate–data before importing it into Workday.
  
  
• ServiceNow: The Snap Pack supports the Madrid release of ServiceNow.
  
  
• PostgreSQL Snap Pack: Added a new PostgreSQL Dynamic Account.
  
  
• RabbitMQ Snap Pack: Added the Auto delete check box, which enables you to indicate that the RabbitMQ autoDelete property associated with the existing queue is set to true.
  
  
• Anaplan Snap Pack: Removed the suggestion button from the Workspace and Model fields in the Snap Settings dialog. Hence, you need to enter the field values manually.  

Breaking Change: Fix to the Active Directory List Users Snap Might Fail Pipelines

We found an issue where the Active Directory List Users Snap inserts a space before every record of each field in the output. While we are fixing this issue in the 4.19 release, if you have Pipelines that have the Active Directory List Users Snap that assumes a space in the first character, then this fix might break your Pipelines. 

Known Issues

• Generic JDBC - Execute Snap: If a SELECT query in the SQL statement field in the Snap Settings contains duplicate column names, then the query result displays the column name twice, with the latter mention prefixed with the table name. If the column name occurs more than twice, the second entry is still prefixed with the table name but it displays the value of the column mentioned last in the query. The example below illustrates this behavior. 

   Example: Incorrect results for SELECT queries with duplicate column names

  Example

  Consider the following query, where the column name "name" is repeated three times: 

  select id, name, city, location, id as name, city as name, location as name from address

  Expected output:

  The  Generic JDBC - Execute Snap's output should reflect the correct query result containing all the six fields, as shown in the image below:

  

  Actual output:

  The Snap's output displays the repeat occurrence of the column "name" only once, prefixed with the table name "address" as shown in the image below. Further, it holds the value of the table column "location", which was mentioned last in the SELECT query. 

  

  
  

  To avoid this issue, we recommend that you give unique column names in the query.

• The ZipFile Write Snap with Use input view label enabled produces incorrect file names – different from the file names assigned by users.
  
  
• The REST GET Snap Link HTTP response header maybe be malformed compared to other third-party applications like POSTMAN.
  

• The File Delete Snap, when configured with a Google Service account, intermittently throws a NoClassDefFoundError: com/google/common/base/MoreObjects error. 
  
  

• The following NetSuite Snaps currently do not support custom records: NetSuite Get, NetSuite Get List, NetSuite Async Get, and NetSuite Delete.
  
  

• The Sandbox Account setting, available while creating a NetSuite account, does not work as expected. Do not select this check box while creating a sandbox NetSuite account.
  
  

• The CSV Formatter Snap ignores escape characters when used along with any quote characters. When this happens, the resultant data cannot be parsed correctly using CSV Parser Snap which can cause an error. See Apache CSV Format issue for details.

Previous Dot Releases in 4.19 - Snaps