SSIS Connection to Outlook Mail (Office 365)

SSIS PowerPack API Connectors
1

Introduction

In this article, we’ll guide you through the process of connecting to Outlook using the ZappySys connector within SSIS. This powerful integration allows you to retrieve and manage your Outlook data efficiently, enabling seamless integration into your workflows and applications.

Prerequisites

  • SSIS PowerPack: Download and install the ZappySys SSIS PowerPack from the Customer Download Area or trial version
  • Microsoft account: Ensure you have a Microsoft account to access Outlook services.

Steps

Create an Application from the Microsoft side

  1. Log into the Azure Portal and navigate to Azure Active Directory.

  2. Click on App registrations in the left menu.

  3. Select New registration and provide a name for your application.

  4. Choose the supported account type and specify the Redirect URI as https://login.microsoftonline.com/common/oauth2/nativeclient.

  5. Copy the Application (client) ID, TenantID, and Secret ID from your App configuration.

    Microsoft configuration
    Microsoft configuration1226×374 38.4 KB

Connect with Outlook connector in SSIS:

  1. Add a Data Flow task to your SSIS package.

  2. Add an API Source component within the Data Flow.

  3. Create a new connection and select the Outlook Mail (Office 365) connector. Then, proceed to the next step.

  4. Fill in the connector fields with the Client ID, Client Secret, and appropriate Authorization and Token URLs:

  • Authorization URL: https://login.microsoftonline.com/daed1250-xxxx-xxxx-xxxx-ef0a982d3d1e/oauth2/v2.0/authorize
  • Authorization URL (Without TenantID):
    https://login.microsoftonline.com/common/oauth2/v2.0/authorize
  • Token URL: https://login.microsoftonline.com/daed1250-xxxx-xxxx-xxxx-ef0a982d3d1e/oauth2/v2.0/token
  • Token URL (Without TenantID): https://login.microsoftonline.com/common/oauth2/v2.0/token

  1. Generate the token and save the configuration.

    Outlook Connector
    Outlook Connector1082×774 38 KB

  2. Select a table/endpoint and preview the data.

    Outlook example
    Outlook example888×605 41.4 KB

Considerations

Save the credentials for easy access in the future.

Video Tutorial

Conclusion

Following these steps, you can easily connect to Outlook using the ZappySys connector within SSIS, streamlining data retrieval and integration processes. This integration enhances your ability to manage Outlook data efficiently, making it a valuable addition to your data management toolkit. If you encounter any issues or need further assistance, our support team can help via chat on our website.

References

For additional information, refer to our Outlook connector article.