Automate quickly with Superior Connectivity and Higher Productivity

Dhananjay Bapat headshot
7 min read

We’re excited to announce the February 2021 release of the SnapLogic Intelligent Integration Platform. In this release, we are releasing a number of new Snap Packs: Marketo and Hubspot for Marketing Automation, Microsoft Teams and Power BI for team communication and analytics respectively, and OpenAPI to connect to any OpenAPI compliant endpoints. We are adding support for Azure Synapse analytics to our ELT capability. We have also made a number of platform enhancements such as higher productivity through expanded Universal search, platform notifications to Slack, better reliability through Snaplex level scheduling, and more.

Hassle-free connectivity with NEW Snap Packs

Over the last few months, we have added a number of Snap Packs to provide out-of-the-box connectivity to key enterprise endpoints. 

Our *NEW* Marketo and Hubspot Snap Packs allow you to connect seamlessly to these marketing automation systems. You can easily manage marketing assets/campaigns as well as leads that enter your marketing funnel. While HubSpot Snap Pack supports CRUD (create, read, update, delete) operations, Marketo Snap Pack allows you to do bulk operations on leads. With these Snap Packs, you can quickly sync your assets and leads data across Marketing, Sales, and other functional areas and easily connect to event/survey applications such as Eventbrite, SurveyMonkey, Demand Generation tools such as Google Ads, Linkedin, and Analytics endpoints such as Microsoft Power BI and Tableau.

The *NEW* Microsoft Power BI Snap Pack allows you to connect your Power BI instance to hundreds of data sources and bring your data to life with live dashboards and reports. You can visualize your data and share insights across teams or embed them in your app or website. The Snap Pack allows you to post, push datasets, read, and edit so that you can easily query data, create/bind entities, import files, and update entities. Check out this demo video on how you can easily push data to Power BI with SnapLogic.

If you are an organization that has a heavy investment in the Microsoft ecosystem, the next Snap Pack will excite you. Our *NEW* Microsoft Teams Snap Pack allows you to easily integrate your Microsoft Teams into your enterprise workflows for customers, employees, and teams. The Snap Pack supports a number of accounts such as OAuth2 User, Application, and Dynamic accounts to adhere to your enterprise security standards. You can use it to send messages, perform channel operations, and perform team operations. To see the complete list of capabilities, please visit Microsoft Teams Snap Pack page in our documentation.

Another key *NEW* Snap Pack with this release is the OpenAPI Snap Pack. Most of the API endpoints today adhere to the OpenAPI specification version 2 or 3. Users can now leverage this Snap Pack to connect to any API endpoint with the published OpenAPI specification so that they can get all the documentation while they are building their automated workflows. Thus you can more efficiently connect to any generic endpoint without the need for specific Snaps. Learn how you can leverage OpenAPI Snap Pack in this demo video

Improved connectivity with other Snap Pack enhancements

Here are a few other notable enhancements: 

  • Google Sheets Snap Pack now supports JSON based version 4 of the API rather than XML based version 3
  • Kafka Snap Pack updates now support reading/writing record headers and timestamps, provide option to choose one output document per batch. The later feature allows systems that don’t natively support streaming data to effectively work with Kafka messages by batching them together.
  • Amazon Redshift and Amazon SQS Snap Packs now provide cross-account IAM support that allows organizations to trust and allocate roles with specific access privileges to specific groups or users.

Pushdown to any cloud data warehouse including Azure Synapse

Over last few releases, we have announced ELT support for Snowflake, Redshift cloud data warehouses so that you can do ETL and ELT on a single platform. We are extending our ELT support to Azure Synapse with this release. With ELT for Azure Synapse, we enable you to accelerate data loading into Azure Synapse and provide ultimate flexibility in transforming data by leveraging all computing resources across SnapLogic and Azure Synpase, thus reducing TCO and enabling a faster time-to-value. 

With SnapLogic platform you can extract data from SaaS applications and databases by leveraging a vast number of Snaps. Once the data is in the staging area in Azure Cloud Storage, you can visually define data transformations, no need to write SQL. These visual transformations are converted into SQL statements and pushed to Azure Synapse for execution.

In addition to adding Azure Synapse, we have added a number of features to SnapLogic ELT that make it easy to discover schema and SQL functions in the target cloud data warehouse. The platform now provides suggestions for column names during LOAD, INSERT SELECT or MERGE INTO operations. The platform also provides SQL function suggestions when working with your target cloud data warehouse. To deal with large number of SQL functions various cloud data warehouses support, we have bucketed them into different categories to simplify discovery.

To learn more about the new Azure Synapse ELT capabilities and other ELT enhancements, check out our documentation.

Better Ease of Use and improved resiliency with the Platform Updates

The SnapLogic Intelligent Integration platform continues to evolve to make it easy for integration developers, whether they are technical or non-technical, to build and monitor integrations. 

Universal Search, as the name suggests helps you search everything related to SnapLogic, all from a single search box. With the February release, it now performs pipeline searches in addition to the searches in Community, Configured Snaps and Documentation. And it is not just a simple text based search. Iris AI integration assistant provides more relevant search results across generic content (in community and documentation) and specific content from your org (such as pipelines or configured Snaps that you have access to). To learn more, check out this demo video.

Figure 1: Universal search now supports pipeline searches

Another enhancement that will help you efficiently monitor your integrations is the platform notifications to Slack. Users can now get notified via Slack for any notifications from SnapLogic platform such as Daily API Usage, Snaplex Congestion, CPU usage, user activity, in addition to email notifications. You can send notifications on Slack Channels or directly to users. Check out this demo video to learn more.

Figure 2: Configuring Notifications to Slack

Last but not least, you can now enable Snaplex levels scheduling for all the scheduled tasks. This update reduces the time difference between the scheduled time of task execution and the actual time of task execution. With this update, your scheduled tasks won’t be affected by network disruption of the control plane helping your reliably deliver data that advances business processes and delivers insights.

If you missed the product release webinar, you can watch it here and hear from our product team. You can always learn more about these updates by visiting the SnapLogic Documentation.

If you are not yet already part of the SnapLogic Community, join the conversation here. Engage with others and get your questions answered, and for upcoming product releases check out the ‘Release Notes and Announcements’ section in the community to get your first glimpse into what is coming next.

Dhananjay Bapat headshot
Senior Technical Product Marketing Manager at SnapLogic

We're hiring!

Discover your next great career opportunity.