January 2023 Release Notes
Key New Features
UI redesign of the Developer Portal.
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.
Introduced the Workday REST Snap to connect to Workday REST APIs. This Snap supports the following accounts:
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
orcustomers.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 namedaccounts.csv
, AutoSync creates a table namedaccounts_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
, andivr
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
Introduced the Workday REST Snap to connect to Workday REST APIs. This Snap supports the following accounts:
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
Â
Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.