SSIS Connection to Outlook Mail (Office 365)

SSIS PowerPack API Connectors
1

Introduction

This article demonstrates how to connect to Outlook with the ZappySys connector inside SSIS, enabling efficient data retrieval and integration.

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

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.

Conclusion

Following these steps, you can seamlessly connect to Outlook within SSIS, leveraging the ZappySys tool for efficient data retrieval and integration. For assistance or inquiries, contact our support team via chat on our website or through email at support@zappysys.com.

References

For additional information, refer to our Outlook connector article.