Versions Compared

Old Version 109

changes.mady.by.user Chandna Mitra

Saved on

compared with

New Version Current

changes.mady.by.user Chandna Mitra

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In this Page

Table of Contents
maxLevel2

...

You can use the Dashboard to check status of your Resumable Pipeline. You can view Pipeline status history and resume a suspended Pipeline using the new Resume icon ().

Snap Enhancements

Info
  • Pipelines that are already started before a Snap update will continue to run with the older version of the Snaps. All Pipelines executed after a Snap update run with the new Snaps
  • For Ultra Pipelines, the currently running instances will continue to run with the older Snap packs. Editing and saving the task instance in Manager will cause a rolling restart of the Ultra Pipeline instances and the new Snap Packs will get picked up.
  • Customers using SQL Server with Windows authentication and SAP will need to restart their Groundplexes Groundplex and CloudplexesCloudplex instances.
  • New Snap Packs are displayed in the SnapLogic Designer only after all the JCCs in an org are upgraded to the latest version.

New Snap Pack

SnapLogic Data Science

ML Natural Language Processing Snap Pack:

...

Added documentation on how to deploy Machine Learning models as REST APIs in SnapLogic.

New Snaps in Existing Snap Packs

Salesforce Snap Pack: 

  • Salesforce Publisher: Publish Salesforce platform event records to a given event custom sObject (Salesforce Object). 
  • Salesforce Subscriber: Subscribe to Salesforce platform event records for a given event custom sObject.

SnapLogic Data Science

ML Core Snap Pack:

  • Auto ML: Automate the process of selecting machine learning algorithms and tuning hyperparameters. This Snap gives the best predictive model within the specified time limit.

ML Data Preparation Snap Pack: 

Updated Snap Packs

Core

  • Binary Snap Pack:
    • Added a new property, Blob endpoint, which enables you to specify the Azure Blob Storage endpoint that you want to use with an Azure Storage account. 
    • Added a new property, Only Output on Change, in the File Poller Snap. This property helps avoid redundancy by not displaying the same matching file in every polling result, unless the file is changed. 
  • Data Catalog Snap Pack: Added the Catalog Delete Snap to remove tables and table partitions from the Data Catalog. 

Data

  • Hadoop Snap Pack: Added a new property, Output for each file written, to handle multiple binary input data in the HDFS Writer Snap.
  • Snowflake Snap Pack:
    • Added the ability to use SnapLogic to securely connect to and query a Snowflake instance using Azure Blob as its storage layer. See Snowflake Account documentation for details.
    • Added support for snowflake JDBC JAR version 3.6.17. See Snowflake Account documentation for details.
    • Updated the Snowflake Unload, Bulk Load, and Bulk Upsert Snaps to enable SnapLogic users to successfully connect to a Snowflake instance to query, bulk load, and unload data from Azure Blob storage.

Enterprise

  • Netsuite Snap Pack: The Target Schema of the Mapper Snap now displays custom fields by their Display Names in Pipelines that use the NetSuite Create, Update, Upsert, Search, Async Upsert, or Async Search Snaps.

    Note

    Custom fields are not displayed in the updated NetSuite Snaps. They are visible only for Snaps where you have configured custom fields with SnapLogic 4.15 or earlier releases.
    With the updated NetSuite Snaps, you must connect a Mapper Snap as an upstream Snap to map custom fields.


  • Workday Prism Analytics Snap Pack: Updated the name of the Workday Prism Snap Pack to Workday Prism Analytics Snap Pack.

...

  • While authorizing accounts for the Google Spreadsheet Snap Pack, force approval prompts you to request a new refresh token.
  • In the SQL Server Snap Pack, Pipeline execution fails whenever a value is set in the Limit offset property of the SQL Server Select Snap.
  • For a Salesforce Read or SOQL Snap using the REST API, certain network failures while reading a REST response may result in a socket timeout exception that will not retire.
  • For a Salesforce (Platform Events) Subscriber Snap, retry attempts are not logged, and currently retries are attempted only for authentication errors.

eXtreme Big Data Enhancements

...

Panel

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

  • UAT #1, January 18, 2019 (Release updates are published above)
  • UAT #2, January 25, 2019
  • UAT #3, February 01, 2019
  • GA, February 16, 2019 (9 pm PST)

UAT #2 Updates

Platform

  • Fixed an issue with error handling for locked user accounts.
  • Fixed an issue with expression caching and with the Date.toLocaleDateString function evaluation.
  • Fixed an issue with state cleanup during a Pipeline abort.
  • Fixed issues with API proxy creation functionality.

UI

  • Fixed a script error issue when importing an empty file using the Import file option present in Snaps such as the Script Snap, CSV Generator Snap, and XML Generator Snap, results in a script error.
  • Fixed an issue where creating a Proxy and clicking Try It with an invalid JSON results in the following error: Uncaught SyntaxError: Unexpected token ] in JSON.
  • Fixed error messages in API Management.
  • Fixed text in Dialog for IP Whitelist in Manager > Settings.
  • Fixed an issue with Table Assets where clicking on an asset results in an incorrect display of the UI.
  • Fixed an issue where resizing the UI window removes the header from view.

Big Data

  • Fixed an issue where the Pipeline execution time that displays on the UI for eXtreme Pipelines is the driver execution time and not the total time from the point when the Pipeline triggers.
  • Fixed an issue where eXtreme Snowflake Snaps are not working when other Spark SQL 2.x Snaps are present in the same Pipeline.

UAT #3 Updates

Platform

  • Fixed issue with error reporting during Pipeline abort.
  • Fixed issue with Pipeline cleanup related functionality.
  • Raised timeout for preparing a triggered Pipeline on a Groundplex with a slow network.

UI

  • Fixed an issue where clicking on the TRUSTe image on the Login page results in the following error message: This site is NOT a member of the TRUSTe Certification program.
  • Fixed an issue where the Mapper Snap displays incorrect schema after validation.
  • Fixed an issue where the Create Org dialog is not displaying the full pop up menu, requiring the user to resize the window.
  • Fixed an issue with the Data Catalog where some values could be incorrectly inserted into field on the Data Catalog Snaps, breaking the Table Asset.
  • Fixed an issue where an offset between UTC and local time are yielding inaccurate Proxy statistics.
  • Fixed an issue with State Transition details for Ultra Pipelines are misaligned.
  • Fixed an issue where the failed login error message incorrectly appears.

 Big Data

  • Fixed an issue where copying an eXtremeplex results in the following error message: Notification: xxx is not of type value. Notification: xxx value must be of type object.

GA Updates

UI

  • Fixed an issue in API Management, wherein the UI displays time in the user's local time zone, instead of UTC.
  • Removed Total Input Bytes statistics for Spark Pipelines, since it only applies for eXtreme Pipelines.
  • Fixed an issue with group1 private Snap Pack that displays a script error upon clicking a Snap, instead of opening the Snap Infobox.

...

Panel

SnapLogic dot releases help optimize and continuously improve the platform. This dot release section documents all customer-impacting updates across the SnapLogic platform. 

Platform

Release #DateUpdate
NA4/16/2019Fixed an issue in the Control Plane that caused the linkage of existing Tasks with Pipelines to fail when the associated Project undergoes multiple migrations.

UI

Release #DateUpdates
4.16.102/28/2019
  • Fixed an issue where switching Orgs while working in Chrome results in a Script Error message.
  • Fixed an issue so that you can navigate by month when searching for Assets in SnapLogic Manager. 
  • Fixed an issue where selecting Auto-Scaling on the Advanced tab of the eXtremeplex form results in an error.

Snap Packs


Snap PackUpdate DateBuildUpdates
MS Dynamics 365 for Sales5/1/2019dynamics365forsales7232

Dynamics 365 for Sales Read Snap now supports custom object types. 

Azure SQL4/24/2019db/azuresql7179Fixed an issue in the Azure SQL Bulk Extract Snap wherein the Snap fails to process all the metadata information of the input table and schema.
Google Spreadsheet4/22/2019google/spreadsheet6995Fixed an issue wherein the Spreadsheets Browser Snap fails if a spreadsheet name contains / or : in Windows plex.

Generic JDBC

4/15/2019

MULTIPLE7123Added two new properties, Number of retries and Retry interval, to Execute, Insert, Select, and Update Snaps that enables you to handle retry attempts during a connection failure.
MYSQLAdded two new properties, Number of retries and Retry interval, to Delete, Insert, Select, Execute, Merge, Update, and MutliExecute Snaps that enables you to handle retry attempts during a connection failure.
OracleAdded two new properties, Number of retries and Retry interval, to Delete, Insert, Select, Execute, Merge, and Update Snaps that enables you to handle retry attempts during a connection failure.
SQL Server
PostGreSQL
Redshift
Confluent Kafkaconfluentkafka7118Fixed an issue with the Confluent Kafka Producer Snap wherein the Snap fails to produce the upstream Snap's input schema for Partition Number property in the output preview.
Email4/12/2019email6772Fixed an issue with the Email Delete Snap wherein the Snap fails to delete emails with multiple input documents.
Binary4/11/2019binary7049Fixed an issue with the File Writer Snap wherein the Snap writes FTPS files partially. Two new global properties, ftpsDelayBeforeClosing and ftpDelayBeforeClosing, enable you to add delays to the FTP file protocol to handle the partial write.
SAP HANA4/10/2019db/saphana7062Fixed an issue in SAP HANA Update and Insert Snaps wherein time data type was not getting passed if a table name and column name were similar in multiple schemas.
Transform4/9/2019transform7093Fixed an issue with the XSLT Snap failure by enhancing the Saxon version.
SAP HANA4/5/2019db/saphana7040Fixed an issue with the SAP HANA - Delete Snap wherein the Snap was unable to delete a data if the delete condition was not selected or if the condition was a static value. 
Tableau 9&103/28/2019tableau96877

Enhanced the Tableau REST Snap to accept the append_file_upload REST operation which provides more flexibility while publishing datasource/workbook.

MongoDB3/28/2019db/mongo7004Enhanced the MongoDB Find Snap to support Decimal128 data type so that Decimal128 values are rendered as NumberDecimal in the Mongo shell.
Workday3/20/2019workday6973Fixed an issue with paging variable toggle in Workday Read Snap to produce correct preview data.
SQL Server3/20/2019db/sqlserver6981Fixed an issue of slow performance in SQL Server Snaps while using SQL Server Dynamic account type.
Binary3/18/2019binary6975

Added a new property, Blob endpoint for Binary Accounts, which enables you to specify the Azure Blob Storage endpoint that you want to use with an Azure Storage account.

Transform3/15/2019transform6962
  • Added a new property, Escape special characters, to the XML Generator Snap that enables you to escape XML special characters in template variable values.
  • Added a new property, Header size error policy, to the CSV Formatter and CSV Parser Snaps. The property enables you to handle header size errors.
NetSuite3/14/2019netsuite6911
  • Deprecated the NetSuite Credential account type.
  • Fixed an issue with running multiple Pipelines by lazy-fetching custom fields metadata.
SOAP3/13/2019soap6886Fixed an issue with the SOAP Execute Snap wherein SLDB protocols were not being supported.
ServiceNow3/13/2019servicenow6897ServiceNow Snaps will not support parsing logic for JSON version. All JSON versions must be replaced with JSON2.
Snowflake3/13/2019db/snowflake6945Fixed an issue with the Snowflake Lookup Snap failing when Date datatype is used in JavaScript functions.
Snowflake3/8/2019db/snowflake6928

Added support for file format options for input data from upstream Snaps, to the Snowflake Bulk Load Snap.

Workday Prism Analytics3/8/2019workdayprism6801Added a new property, Append, to the Bulk Load Snap that lets you add data to an existing dataset.
Oracle3/8/2019db/oracle6919

Added a new property, Session parameters, in the Oracle Insert Snap to enable the use of National Language Support (NLS) parameters.

Cassandra3/5/2019db/cassandra6848Fixed an issue with the Cassandra Execute Snap wherein output documents were not produced on selecting the Pass through property.
Confluent Kafka3/4/2019confluentkafka6891Certified Confluent Platform version 5.x. This was due to Confluent Platform not supporting version 3.2.0 after March 2, 2019. The Snap Pack still supports 3.2.0 to ensure backward compatibility.
Salesforce3/1/2019salesforce6889

Added two new properties, Number of retries and Retry interval, to the Salesforce Read, SOQL, Publisher, and Subscriber Snaps. These properties let you handle retry attempts and intervals in case of a network failure.

Transform2/26/2019transform6869Fixed an issue with the XML Parser Snap wherein XSD with annotations are incorrectly interpreted.
Reltio2/22/2019reltiosnapconnector6773Fixed an issue with the Reltio Generic Execute Snap wherein response codes are handled incorrectly.
Oracle

2/22/2019 





db/oracle6824

Fixed an issue with the Lookup Snap passing data simultaneously to output and error views when some values contain spaces at the end.












SQL Serverdb/sqlserver6818
Verticavertica6820
Redshiftdb/redshift6821
PostgreSQLdb/postgres6822
MySQLdb/mysql6823
Snowflake2/22/2019 db/snowflake6819
  • Added a new property, Buffer size (MB), to the Snowflake Bulk Load Snap. Buffer size lets you specify the size limit of each buffer when writing to external staging systems such as S3. 
  • Fixed an issue with the Lookup Snap passing data simultaneously to output and error views when some values contain spaces at the end.
Workday2/22/2019 workday6862Fixed an issue with the Workday Read Snap not logging SOAP calls.

For information on updating the Snap Packs, refer to How to upgrade to a new Snap Pack version.


...