How to publish and share Outlook Data dashboards with Tableau Server

Integrate connectivity to Outlook data into your enterprise reporting capabilities. The CData ODBC Driver for Outlook enables you to access live Outlook data in business intelligence tools like Tableau Server. Connectivity to Outlook APIs enables you to monitor changes to your data in real time. Other members of your organization can access your dashboards from a Web browser and get updates from their mobile phone.

This article explains how to configure a DSN on the client and server machines, publish a data source for Outlook to Tableau Server, and publish an entire Workbook to Tableau Server (including the data source). If you publish a data source, you will be able to create new, refreshable workbooks in Tableau Server.

Connect to Outlook as an ODBC Data Source

To create a data source or workbook in Tableau Desktop and publish the data source or workbook to Tableau server, you will need to configure a DSN on each machine (Desktop and Server), specifying connection properties and creating DSNs using the same name on each machine. Information for connecting to Outlook follows, along with different instructions for configuring a DSN in Windows and Linux environments.

Using OAuth Authentication

Microsoft Graph API uses OAuth 2.0 for authentication. You must register an application in the Microsoft Azure Portal to obtain OAuth credentials (Client ID and Client Secret).

Obtaining OAuth Credentials

1. Log in to the Azure Portal.
2. Navigate to Azure Active Directory > App registrations.
3. Click New registration to create a new application.
4. Enter an application name and select the appropriate account types.
5. Set the Redirect URI to your application's callback URL (e.g., http://localhost:33333 for desktop apps).
6. Click Register to create the application.
7. On the application overview page, copy the Application (client) ID - this is your OAuthClientId.
8. Navigate to Certificates & secrets and create a new client secret.
9. Copy the client secret value - this is your OAuthClientSecret.
10. Navigate to API permissions and add the required Microsoft Graph API permissions:
    • Mail.Read - For accessing email messages
    • Contacts.Read - For accessing contacts
    • Calendars.Read - For accessing calendar events
    • Tasks.Read - For accessing To Do tasks
    • offline_access - For obtaining refresh tokens
11. Click Grant admin consent to grant these permissions.

Connecting with OAuth

After setting the following connection properties, you are ready to connect:

• AuthScheme: Set this to OAuth.
• InitiateOAuth: Set this to GETANDREFRESH. The CData API Profile for Outlook will automatically walk through the OAuth process in order to obtain the access token.
• OAuthClientId: Set this to the Application (client) ID from Azure Portal.
• OAuthClientSecret: Set this to the client secret value from Azure Portal.
• TenantId: Set this to your Azure AD tenant identifier (GUID or domain name like 'contoso.onmicrosoft.com').
• CallbackURL: Set this to the Redirect URI you specified in your app registration (e.g., http://localhost:33333 for desktop apps).

Example connection string

Profile=C:\profiles\Outlook.apip;AuthScheme=OAuth;InitiateOAuth=GETANDREFRESH;OAuthClientId=your_client_id;OAuthClientSecret=your_client_secret;TenantId=your_tenant_id;CallbackUrl=http://localhost:33333;

When you configure the DSN, you may also want to set the Max Rows connection property. This will limit the number of rows returned, which is especially helpful for improving performance when designing reports and visualizations.

Windows

If you are installing the CData ODBC Driver for Outlook on Windows, DSN configuration is the last step of the driver installation. If you already have the driver installed, or you wish to configure new DSNs, you can use the Microsoft ODBC Data Source Administrator.

Linux

If you are installing the CData ODBC Driver for Outlook in a Linux environment, the driver installation predefines a system DSN. You can modify the DSN by editing the system data sources file (/etc/odbc.ini) and defining the required connection properties.

/etc/odbc.ini

[CData API Source]
Driver = CData ODBC Driver for Outlook
Description = My Description
Profile = C:\profiles\Outlook.apip
AuthScheme = OAuth
InitiateOAuth = GETANDREFRESH
OAuthClientId = your_client_id
OAuthClientSecret = your_client_secret
TenantId = your_tenant_id
CallbackUrl = http://localhost:33333

For specific information on using these configuration files, please refer to the help documentation (installed and found online).

Publish the Outlook Data Source to Tableau Server

With the connections to Outlook data configured, you are ready to publish a Outlook data source on Tableau, ready to be leveraged by users in your organization to create workbooks based on Outlook data.

Create and Publish a Data Source

1. In the Connect pane, click More -> Other Databases (ODBC). Select CData API Sys, the system DSN.

   The driver installation automatically creates matching user and system DSNs: The system DSN is needed to connect from Tableau Server.

   👁 The connection to the DSN. (Salesforce is shown.)
   
2. In the Database menu, select CData.
3. In the Table box, enter a table name or click New Custom SQL to enter an SQL query.
4. Drag the table onto the join area. 👁 A connection to a single table. (Salesforce is shown.)
   
5. From the Server menu, click Publish Data Source -> (YOUR DATA SOURCE). 👁 Image
   
6. Enter the URL to the server. For most instances, you will authenticate with the Tableau Server username and password. Other authentication scenarios can be found below:
   • If Tableau is configured to use Kerberos and your computer has valid Active Directory credentials, Tableau connects to the server.
   • If Tableau is configured to use SAML, a login prompt for your external identity provider is displayed.
   • If Tableau is configured to use Active Directory, enter your Windows username and password.
7. In the resulting dialog, set the Project, Data Source, and other properties. If you want to schedule refreshes, select Embedded Password in the Authentication menu. Click Publish.

You and other users in your organization can now create and share workbooks based on the published data source.

👁 Connectivity to your data source from the Web authoring environment in Tableau Server. (Salesforce is shown.)

Refresh Workbooks

With a system DSN configured on the client (Tableau Desktop) machine and server (Tableau Server) machine, you can refresh workbooks connected to the Outlook data source. From the Web interface for Tableau Sever, click Data -> (YOUR DATA SOURCE) -> Refresh.

👁 Refresh the data extract on demand from Tableau Desktop. (Salesforce is shown.)

Publish a Completed Workbook with Outlook Data to Tableau Server

If you have a specific Workbook that you wish to share with your organization, you can create the Workbook on Tableau Desktop and publish the Workbook directly to Tableau Server.

1. To connect to Outlook and select data, follow steps 1-5 above. 👁 A connection to a single table. (Salesforce is shown.)
   
2. Click Server -> Sign in and configure the connection to the server. For most instances, you will authenticate with the Tableau Server username and password. Other authentication scenarios can be found below:
   • If Tableau is configured to use Kerberos and your computer has valid Active Directory credentials, Tableau connects to the server.
   • If Tableau is configured to use SAML, a login prompt for your external identity provider is displayed.
   • If Tableau is configured to use Active Directory, enter your Windows username and password.
3. With the data selected, select dimensions and measures to visualize and select a type of chart or graph to build your visualization(s). 👁 Image
   
4. Once the Workbook is complete, click Server -> Publish Workbook to publish the Workbook to Tableau Server. 👁 Image
   
5. In the resulting dialog, set the Project, Name, Description and other properties. If you want to schedule refreshes, click Edit under Data Sources and change the Authentication option to Embedded Password. Click Publish. 👁 Image
   

You and other users in your organization can now review the published workbook from Tableau Server.

👁 Connectivity to your published Workbook from the Web authoring environment in Tableau Server. (Salesforce is shown.)