Microsoft Exchange

The Microsoft Exchange component uses the Microsoft Exchange API to retrieve data to load into a table—this stages the data, so the table is reloaded each time. You can then use transformations to enrich and manage the data in permanent tables.

Properties

Reference material is provided below for the Connect, Configure, Destination, and Advanced Settings properties.

Connect

Authentication Type = drop-down

Select OAuth 2.0 Authorization Code from the drop-down menu.

Auth Secret = drop-down

Choose your profile from the drop-down menu. To create your own OAuth connection, use the following steps:

Click Manage in the Auth Secret dialog.
Click Add OAuth connection in the OAuth tab to open Add new OAuth.
Give an appropriate OAuth name.
Use the drop-down menu to select the Microsoft Exchange provider.
Select OAuth 2.0 Authorization Code Grant from the Authentication type drop-down.
Enter your Azure Tenant ID. For information about how to create a tenant ID, read Create a new tenant in Microsoft Entra ID.

Note

Azure Active Directory is now Microsoft Entra ID. For more information, read New name for Azure Active Directory.
Click Authorize.

:mod-connection-options:

Configure

:mod-mode: :mod-sql-query: :mod-data-source: :mod-data-selection: :mod-data-source-filter: :mod-combine-filters: :mod-row-limit:

Destination

Select your cloud data warehouse.

Advanced Settings

:mod-auto-debug: :mod-debug-level:

Data model

The JDBC driver for this component models Microsoft Exchange APIs as relational tables, views, and stored procedures, which are documented in the data model. You'll also find API limitations and requirements. The connection option SupportEnhancedSQL is set to true by default and typically circumvents most API limitations.

View the Microsoft Exchange (MSGraph) data model to learn more.

Deactivate soft delete for Azure blobs (Databricks)

If you intend to set your destination as Databricks and your stage platform as Azure Storage, you must turn off the "Enable soft delete for blobs" setting in your Azure account for your pipeline to run successfully. To do this:

Log in to the Azure portal.
In the top-left, click ☰ → Storage Accounts.
Select the intended storage account.
In the menu, under Data management, click Data protection.
Untick Enable soft delete for blobs. For more information, read Soft delete for blobs.

Snowflake	Databricks	Amazon Redshift
✅	✅	✅