January 2023 Release Notes

Key New Features

API Management

  • UI redesign of the 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.

Platform

Snaps

Studio

  • This release introduces 21 new Pipeline Patterns.

API Management

Enhancements

  • UI Redesign for the APIM Developer Portal. The redesign offers the same color scheme and element style as the SnapLogic Studio design, making for a consistent user experience.

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

  • The Generic OAuth2 API Policy also supports OAuth 1.0.

AutoSync

New Features

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

  • Integration sources:

    • Microsoft Dynamics 365 for Sales: AutoSync supports load and reload or upsert new and changed records for synchronization.

    • SFTP: AutoSync supports load and reload of CSV and JSON files.

    • Zendesk CRM: AutoSync supports load and reload, upsert new and changed records, or synchronize and track history with SCD2.

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. 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 OAuth 2.0 for authentication.

Limitations

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

  • SFTP: Data loaded from SFTP converts to strings in the destination.

  • 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

    • 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) field set to the Aggregate concatenation function results.

Platform

Enhancements

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

  • With Git integration, the following more detailed statuses for tracked assets are available:

    • Tracked, Modified Locally

    • Tracked, Modified Remotely

    • Tracked, Conflict

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

Known Issues

In an Org with GitHub integration, you can select a Pattern Project from the Git Checkout option in the Manager > Create Project dialog; however, a standard project is created, not a Pattern Project.

Snaps

New Snaps

Enhancements

  • The Snowflake and the PostgreSQL Snap Packs support geospatial data types. Full support for Snowflake requires using our custom Snowflake JDBC driver. (Contact Support for details.)

  • The Azure Synapse SQL Insert, MySQL Insert, SQL Server Insert, and Vertica Insert Snaps no longer supports the Preserve case-sensitivity checkbox because these databases are case-insensitive. The databases store the data regardless of whether the columns in the target table and the input data are in mixed, lower, or upper case.

  • 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 now include an Authentication Mode dropdown list that enables you to choose Azure SQL authentication options.

  • The JWT Generate Snap is enhanced with the following fields:

    • Issued At Epoch, Not Before Epoch, and Expiration Epoch for specifying custom values for the fields.

    • Skip Key ID for removing the Key ID parameter from the JWT token when selected if you do not want the Key ID to display in the output.

Fixed Issues

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

  • The HTTP Client Snap no longer fails 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

Â