Key New Features

API Management

New look and feel to Developer Portal.

AutoSync

• Connect to on-premises Oracle and SQL Server data sources.

• New supported endpoints: Microsoft Dynamics 365 for Sales, SFTP, and Zendesk.

• Option to track deleted Salesforce records.

Data Automation

Platform

Snaps

Studio

Studio Patterns

API Management

Enhancements

• UI Redesign for the APIM Developer Catalog. Better contrast and arrangement of UI elements offer an improved experience.

• Support for APIM expressions in the Proxy URL enables you to use variables.

• The Generic OAuth 2 API Policy also supports OAuth 1.

AutoSync

New Features

• Using a self-managed Snaplex, connect to on-premises Microsoft SQL Server and Oracle data sources.

• Endpoint support for the following as integration sources:

  • Microsoft Dynamics 365 for Sales

  • SFTP

  • Zendesk is a cloud-based customer relationship management application. Source your customer support data from Zendesk to load, update, and upsert objects into a data warehouse.

New Behavior

• Amazon S3: Before the January release, when loading from an Amazon S3 bucket, AutoSync used the exact file name for the table it created in the destination, such as accounts.csv or customers.json. Some destinations do not support table names that include periods. Now, AutoSync replaces the period with an underscore. For example, to upload a file named accounts.csv, AutoSync creates a table named accounts_csv.

• Salesforce: AutoSync can track deleted records by adding an Is Deleted column to the destination and inserting a value of True for deleted records. On the first load, AutoSync adds previously deleted records to the destination with a value of True in the Is Deleted column. On synchronization, AutoSync inserts True in the Is Deleted column for records deleted since the last load or synchronization. To enable this behavior, select the Include deleted records checkbox when creating or editing an integration.

• Coupa: Before the January release, AutoSync required an API key to create a new connection configuration. Now, a new Coupa connection configuration uses OAuth2 for authentication.

Limitations

• Your AutoSync dashboard includes integrations created by you. It can display up to 100 integrations.

• Zendesk:

  • If you do not have a Zendesk Suite Enterprise account, an error occurs if you try to synchronize the audit_log object.

  • If you do not enable the voice feature, you cannot synchronize the following objects:

    • line

    • greeting

    • greeting_category

    • ivr

    • call

    • call_leg
      Workaround: Do not select the listed objects for synchronization.

  • The upsert and SCD2 synchronization types cannot track changes for the line, greeting, greeting_category, address, and ivr objects because Zendesk does not provide timestamps for them.

Data Automation

Known Issues

The ELT Aggregate Snap does not apply the sort order defined in the ORDER-BY Fields (Aggregate Concatenation Functions Only) fieldset to the Aggregate concatenation function results.

Platform

Enhancements

• All Snaplex Docker images are now signed to help validate their integrity.

• More detailed statuses for tracked assets are added:

  • Tracked, Modified Locally

  • Tracked, Modified Remotely

  • Tracked, Conflict

• Create new GitHub projects when creating Projects in SnapLogic Manager.

Snaps

• Introduced the Workday REST Snap to connect to REST APIs in the Workday Snap Pack. This Snap supports the following accounts:

  • Workday REST Access Token

  • Workday REST OAuth2 Account

Enhancements

• The Azure Synapse SQL Insert, MySQL Insert, SQL Server Insert, and Vertica Insert Snaps do not support the Preserve case-sensitivity feature because these databases are case-insensitive. They store the data regardless of whether the columns in the target table and the input data are in mixed, lower, or upper cases.

• The Oracle-Stored Procedure Snap supports stored functions with OUT and INOUT parameters and displays these parameter values in the output with the returnval key.

• The performance of the Redshift - Bulk Load Snap is improved by performing the CSV-format and GZIP-compression in multiple threads.

• The Snowflake S3 OAuth2 Account supports expressions for external staging fields.

• The DynamoDB Snap Pack supports the IAM role in the DynamoDB account.

• The Azure SQL Active Directory and the Azure SQL Active Directory Dynamic accounts are enhanced with the Authentication Mode dropdown list to support Azure SQL authentication.

Fixed Issues

• The Azure SQL - Execute Snap using the Azure SQL Active Directory Account that failed with SQL operation failed errors in environments using federated authentication is fixed.

• The HTTP Client Snap now does not fail when making a PATCH request containing an empty response body and location in the Headers. The Snap checks the entity length if the response entity is empty and skips the data conversion.

Studio Patterns

New Pipeline Patterns

The following Patterns are added to the Studio Patterns Catalog:

• Asynchronous Parent and Child Pipelines to Transfer Data

• Check Host and Port Connection

• Export Pipelines into a Zip File

• Extract Employee Contact Information from Workday

• Generate Apache Avro Schema and DDL based on Oracle Table Metadata

• Get Fiscal Periods for Input Date from File

• Get the list of Service Accounts in a SnapLogic Org

• Load Analytics Data from Purple to Amazon Redshift

• Migrate from a Groundplex to a Cloudplex

• Monitor the Performance of Integrations

• Quote to Cash from Salesforce to Workday or SAP

• Radiant Systems Point of Sale to Microsoft Azure SQL Server

• Relational-like Data Pivot

• Salesforce Cases Microservice API

• Salesforce to John Galt Atlas

• Salesforce to Multiple Endpoints

• Synchronize Account Events from Salesforce to Microsoft Azure SQL Database

• Transfer Data from SAP to ServiceNow

• Transfer the Attachment from Amazon S3 to Salesforce

• Workday Extract Employee 401K Contributions

• Workday Extract Employee Manager Hierarchy

Documentation Enhancements