Welcome to the October 2022 update for Azure Synapse Analytics! This month's update focuses on features released at Microsoft Ignite 2022, breaking from the traditional editions.

Don’t forget to check out our companion video on the Azure Synapse Analytics YouTube channel!

Table of contents

• Data Integration
  • New Microsoft 365 Pipeline Template Dataflows in Preview
  • SAP Change Data Capture (CDC) Connector is now General Available
• Apache Spark
  • R language support with key library management capabilities is now in preview

Data Integration

New Microsoft 365 Pipeline Template Dataflows in Preview

A new pipeline template for Microsoft 365 data, coming soon in preview, will simplify the configuration experience by enabling a one-click experience to set up Mapping Data Flows. This new feature will eliminate the extra steps needed to connect Microsoft 365 source data for analytics, making it easier for you to configure an always synchronized and compliant integration. To learn more about it: Copy and transform data from Microsoft 365 (Office 365) - Azure Data Factory & Azure Synapse.

SAP Change Data Capture (CDC) Connector is now General Available

We launched the general availability of SAP Change Data Capture (CDC) in Azure Data Factory (ADF) and Azure Synapse Analytics. Combining a new data connector with predefined data flow templates, this solution streamlines the integration of SAP data within core Azure services like Azure Synapse Analytics and Azure Machine Learning. To learn more read in the official announcement blog for the SAP CDC connector.

Apache Spark

R language support with key library management capabilities is now in preview

Azure Synapse Analytics provides built-in R support for Apache Spark. As part of this, data scientists can leverage Azure Synapse Analytics notebooks to write and run their R code. This also includes support for SparkR and SparklyR, which allows users to interact with Spark using familiar Spark or R interfaces. To learn more read the official how-to Use R for Apache Spark with Azure Synapse Analytics (Preview).