Highlights

The SnapLogic® February 2024 Release includes the following:

Admin Manager

• Team account to share a login for multiple users

• Configure SnapGPT settings

• Add a description for the environment

API Management

• New Policies:

  • HTTP Response Cache Policy for Proxies

  • HTTP Retry for Proxies

  • Inbound TLS for API Versions and Proxies

  • Outbound Basic Auth Policy

• The Create API and Proxy wizard displays specification errors during import

• Basic Auth Support for Proxy

AutoSync

• Edit transformations

• New cloud endpoints: MySQL, Oracle, PostGreSQL, SAP, and SQL Server

• Generic JDBC and PostgreSQL as sources

Platform

• Added support for multi-factor authentication (MFA)

GenAI Builder

• Introduced a new product in the SnapLogic AI portfolio that is focused on helping modern enterprises create applications with Generative AI faster, using a low or no-code interface

Snaps

• HubSpot Snap Pack: Added Bulk Snaps for Create, Read, Update, and Delete

• JDBC Snap Pack: Added the Schema List and Table List Snaps

• NetSuite REST Snap Pack: Added the NetSuite REST Upsert Snap

SnapGPT

• Added the ability to choose SnapGPT settings in the Admin Manager

Patch Update - Platform

Dot Releases - Snaps

Upgrading to this Release

Admin Manager

New Features

• The new team account shares one login with multiple users. One or more maintainers receive email notifications for the account, such as password reset reminders. Learn more.

• Under Application settings, configure SnapGPT settings. Learn more.

• Under Environment settings, in the new General screen, you can add a description of the environment. Learn more.
  

  

Behavior Changes

• Now, you can view and create service accounts in the Users screen. The Service account screen has been removed from the Users & Groups section of Admin Manager. In the New user dialog, Environment admins can choose Service account as the type of account to create:
  

  

• In Admin Manager, when an Environment admin creates or edits an account, they grant access to Designer instead of the Intelligent Integration Platform. Accounts enabled for Designer or AutoSync also have access to APIs and Monitor. Users with a role of Environment admin have access to Admin Manager. The following dialog shows the updated interface for granting app access for a user account. The same choices are available for a team account.
  

  

API Management

New Features

• HTTP Response Cache Policy: Use this policy to set up a cache response for API requests to your third-party endpoints through an API Proxy. The policy enables you to improve the API consumer experience by reducing delays caused by network congestion and providing a layer of resiliency if a Proxy endpoint is unresponsive.

• HTTP Retry Policy: Use this policy to configure retries and timeout behavior for your API proxy endpoints when connecting to downstream services.

• Inbound TLS Policy: Use this policy to configure certificates for all API traffic between the client and server. Your Groundplex applies this policy and creates a secure channel for communication before the data processing node executes the API. This policy complements the Outbound TLS policy by allowing you to ensure TLS communication between the client, server, and back-end service for your Proxy API endpoints.

• Outbound Basic Auth Policy: Use this policy to authenticate Proxy endpoints with Basic Auth.

• An Open API specification file with incorrect or invalid data during import now displays an error within the SnapLogic UI in Create new API, Create Proxy and Publish API or Proxy swagger editor dialogue windows. Learn more.

• Added Basic Authentication support for Proxies and Proxy endpoints. Learn more.

Enhancements

• In the Developer Portal, you can view APIs with the filter and category selection in the side navigation panel of the API documentation. Learn more.

• The Outbound OAuth2 policy now supports the OAuth2 Account for the HTTP Client Snap.

Known Issues

• Both the HTTP Cache Response and HTTP Retry Policies fail to evaluate expressions.

• Because of a known issue in the way that the Swagger Editor UI displays errors, error messages appear outside the window in the Create New API and Proxy wizard window.
  Workaround: Fix the specification in an external editor and try again.

• The HTTP Response Cache policy can only have one cached entry per policy.

AutoSync

New Features

• New capability to edit transformations after saving a data pipeline improves usability and functionality. Learn more.

• Cloud versions of MySQL, Oracle, PostGreSQL, SAP, and SQL Server are now supported. When you select one of these endpoints, choose whether you want to connect to an on-premises or cloud database. Cloud and on-premises databases can be used in the same data pipeline.

• PostgreSQL and Generic JDBC as source endpoints. Generic JDBC enables you to connect to data sources that support JDBC that are not supported as AutoSync endpoints.

• AutoSync can now use the Salesforce Bulk API V2, which provides a higher query limit than V1. To use the Bulk API V2, you must configure the data pipeline with a Salesforce OAuth2 Account. Data pipelines configured with credentials created in AutoSync or in Classic Manager using the Salesforce.com Account type will use the Bulk API V1.

Enhancements

• Before this release, upgrades and fixes to the underlying AutoSync Snap Pack required that SnapLogic Support work with customers to edit existing data pipelines to use the new Snap Pack. Now, AutoSync automatically updates existing data pipelines. Upgrades and fixes usually relate to a few endpoints or only one. The automatic update only migrates the impacted data pipelines.

Known Issues

• For the Generic JDBC endpoint, only in Chrome version 113, closing the JDBC JAR file input window causes the dialog to close. You can still create or edit JDBC credentials using Add new credentials or Edit/Remove Credentials.

• DB2 credentials created in AutoSync for the Generic JDBC endpoint do not work because you cannot select a database name.
  Workaround: Create a Generic Database Account in Classic Manager, specify the database name, and select that account when using the Generic JDBC endpoint in AutoSync.

• If you create Generic JDBC endpoint credentials in AutoSync, you can only upload one JAR file. Some databases, such as Teradata, require two JAR files.
  Workaround: Create a Generic Database Account in Classic Manager, upload both JAR files, and select that Account when using the Generic JDBC endpoint in AutoSync.

Platform

New Features

• Added support for multi-factor authentication (MFA) with a one-time passcode. MFA is not yet available for the EMEA control plane. In Classic Manager, Org admins can enable MFA when creating a new user account or editing an existing account. An account with MFA can only access one environment (Org). Learn more.

Enhancements

• In the Activity Log, Snaplex events for adding and restarting nodes include the user who performed the operation, the node label, and the Org. These details make investigation and tracking easier.

Best Practice

• The GitHub/GitLab service should have a network idle timeout higher than 20 seconds. If the idle timeout is lower than that, connection errors can occur during API calls.

Known Issues

• When more than 20 branches are in a Git repository that has a combination of stale and active branches, only 20 branches display in total (not all branches).
  Workaround: You can checkout any branch through the Public API. After checkout, you can perform the required Git actions in the UI.

• MFA support:

  • After an Org admin enables MFA for a user account, the user should wait five minutes before trying to log in. Before that, the link to log in using MFA is not available.

  • Currently, due to a limitation in Auth0, you cannot remove MFA from a user account and re-enable it. If you need to do that, you will need to create a new account with a different email address.

GenAI Builder

The SnapLogic GenAI Builder enables you to build LLM-powered custom co-pilots based on your use cases. Use this no-code solution to accelerate and automate your business workflows. This product includes the following new Snap Packs:

• Azure OpenAI LLM Snap Pack, which contains the following Snaps and Account:

  • Azure OpenAI Chat Completions: Generates chat completions using the specified model and model parameters.

  • Azure OpenAI Embedder: Generates a vector embedding based on the provided input data.

  • Azure OpenAI Prompt Generator: Generates the augmented user prompt with the specified prompt template using mustache template formatting.

  • Azure OpenAI API Key Account: Authenticates with Azure OpenAI's APIs using the specified API key and corresponding endpoint for secure and authorized access.

• HTML Utilities Snap Pack, which contains the following Snaps:

  • HTML Parser: Parses the HTML content to text format.

  • Markdown Parser: Parses the Markdown content to text format.

  • HTML to Markdown Converter: Converts the HTML content to Markdown format.

• LLM Utilities Snap Pack, which contains the following Snap:

  • Chunker: Chunks input data based on defined settings.

• OpenAI LLM Snap Pack, which contains the following Snaps and Account:

  • OpenAI Chat Completions: Generates chat completions using the specified model and model parameters.

  • OpenAI Embedder: Generates a vector embedding based on the provided input data.

  • OpenAI Prompt Generator: Generates the augmented user prompt with the specified prompt template using mustache template formatting.

  • OpenAI API Key Account: Authenticates with OpenAI's APIs using the specified API key for secure and authorized access.

• Pinecone Snap Pack, which contains the following Snaps and Account:

  • Pinecone Query: Queries records in the Pinecone index, retrieves the top matching vectors close to the specified vector, and optionally outputs the vectors and metadata for the matching vectors.

  • Pinecone Upsert: Upserts the vector and metadata from the input document to the specified index and namespace and writes the data and the associated metadata in the specified index name and namespace.

  • Pinecone Account: Authenticates with Pinecone APIs using the API key.

Snaps

Upcoming

New Snaps

Introduced the following Snaps:

• Added the following new Bulk Snaps to the HubSpot Snap Pack:

  • HubSpot Bulk Create: Creates data objects in bulk in HubSpot.

  • HubSpot Bulk Read: Retrieves data objects in bulk from HubSpot.

  • HubSpot Bulk Update: Updates the specified data objects in bulk in HubSpot.

  • HubSpot Bulk Delete: Deletes the specified data objects in bulk in HubSpot.

• Added the following new Snaps to the JDBC Snap Pack:

  • Generic JDBC - Schema List: Obtains a list of schemas for the specified account from the database.

  • Generic JDBC - Table List: Obtains a list of tables associated with a specified schema from the database.

• Added the following Snap in the NetSuite REST Snap Pack:

  • NetSuite REST Upsert: Creates and updates records using the NetSuite REST API through the External ID.

Enhancements

• API Suite Snap Pack:

  • The HTTP Client and GraphQL Client Snaps now support accessing usernames and passwords from the Basic Authentication account.

  • The HTTP Client Snap also has this capability for the Digest Authentication, NTLM, SSL, and Google Service accounts.

  • Enhanced the OAuth2 Account with the Send client data as Basic Auth header checkbox to pass the client data as a basic authentication header when generating a token.

  • The HTTP Client Snap now supports the SSL OAuth2 Account.

• Marketo Snap Pack:

  • Added the Include export ID checkbox in the Bulk Extract Snap to support the display of the export ID in the output.

  • Enhanced the Bulk Lead Extract Snap to add the export ID to the output document.

• Microsoft Dynamics 365 Finance and SCM Snap Pack: Added the following Snaps:

  • Dynamics 365 Finance and SCM Bulk Import: Bulk imports the data associated with the selected entity in the Microsoft Dynamics 365 Finance and SCM application.

  • Dynamics 365 Finance and SCM Bulk Export: Bulk exports the data associated with a selected entity from the Microsoft Dynamics 365 Finance and SCM application.

• Oracle Snap Pack:

  • The Oracle - Insert, Oracle - Update, and Oracle - Bulkload Snaps now support up to nanosecond precision for the string data type.

  • Enhanced the Oracle - Execute, Oracle - Select, and Oracle - Lookup Snaps with a Column-specific timestamp precision checkbox to represent column-specific timestamp precision for the string data type.

• Salesforce Snap Pack: Enhanced the Salesforce Bulk Query Snap with expression support for the Include Deleted Records checkbox.

• ServiceNow Snap Pack: The Batch Size field is now relabeled as Page size in the ServiceNow Query and ServiceNow Insert Snaps.

Fixed Issues

• Fixed an issue with the COBOL Copybook Formatter Snap to ensure that output data is written as a single binary output.

• Fixed an issue with the Excel Parser Snap that caused a null pointer exception when the input data was an Excel file that did not contain a StylesTable.

• Fixed an issue with the File Poller Snap that caused it to poll recursively for files in the root directory of the S3 bucket.

• The database connection error message in the Generic Database Account is improved for clarity and readability.

• Fixed an issue that caused the HTTP Client Snap to fail when the Basic Authentication account password contained special characters.

• Fixed an issue with the Marketo Bulk Extract Snap where the timeout was not disabled when the Timeout setting was set to 0.

• Fixed an issue with the NetSuite REST Search Snap that encountered a java.lang.StackOverflowError error when the Page size was not set to the default value.

• Fixed an issue with the Oracle Snap Pack that required the i18n extensions to be present when the Oracle database instance was in a specific language.

• Fixed an issue with the Salesforce Snap Pack that caused the input stream to not close properly, which resulted in stale connections.

• Fixed an issue across the Snowflake Snaps that populated all suggestions for the Schema and Table Names in the configured Snowflake Account. Now, the Snaps only populate suggestions related to the database configured in the Account.

• Fixed an issue with Workday REST Snap where the input schema of the Snap did not populate in the upstream Mapper Snap.

Deprecated

• The Microsoft Exchange Snap Pack is deprecated. We recommend that you use the Exchange Online Snap Pack for your existing pipelines containing the Microsoft Exchange Snaps. Contact support@snaplogic.com if your existing pipelines use Snaps from the deprecated Snap Pack.

SnapGPT

• Added the ability to choose SnapGPT settings in the Admin Manager. Learn more.

Documentation Enhancements

• Updated an example showcasing the configuration of the JWT Validator policy.

• Updated information on SnapLogic Platform security.

• Added conceptual information to the CI/CD and Git Integration sections.