Access Live HCL Domino Data in Excel 365 Online (Excel for the web)

Microsoft Excel for the web represents a cloud-native iteration of Microsoft Excel. When integrated with CData Connect Cloud, you gain immediate access to HCL Domino data directly from within Excel. This access facilitates data analysis, collaborative work, calculations, and more. This article provides a step-by-step guide on connecting to HCL Domino within your Connect Cloud instance and accessing live HCL Domino data in Excel for the web spreadsheets, whether for viewing or updating purposes.

CData Connect Cloud provides a pure cloud-to-cloud interface for HCL Domino, allowing you to easily access live HCL Domino data in Excel for the web. Simply use the Connect Cloud Add-In to query live data (or write your own). Using optimized data processing out of the box, CData Connect Cloud pushes all supported query operations (filters, JOINs, etc) directly to HCL Domino, leveraging server-side processing to quickly return HCL Domino data.

Configure HCL Domino Connectivity for Excel

Connectivity to HCL Domino from Excel is made possible through CData Connect Cloud. To work with HCL Domino data from Excel, we start by creating and configuring a HCL Domino connection.

1. Log into Connect Cloud, click Connections and click Add Connection
2. Select "HCL Domino" from the Add Connection panel
3. Enter the necessary authentication properties to connect to HCL Domino.

   Connecting to Domino

   To connect to Domino data, set the following properties:

   • URL: The host name or IP of the server hosting the Domino database. Include the port of the server hosting the Domino database. For example: http://sampleserver:1234/
   • DatabaseScope: The name of a scope in the Domino Web UI. The driver exposes forms and views for the schema governed by the specified scope. In the Domino Admin UI, select the Scopes menu in the sidebar. Set this property to the name of an existing scope.

   Authenticating with Domino

   Domino supports authenticating via login credentials or an Azure Active Directory OAuth application:

   Login Credentials

   To authenticate with login credentials, set the following properties:

   • AuthScheme: Set this to "OAuthPassword"
   • User: The username of the authenticating Domino user
   • Password: The password associated with the authenticating Domino user

   The driver uses the login credentials to automatically perform an OAuth token exchange.

   AzureAD

   This authentication method uses Azure Active Directory as an IdP to obtain a JWT token. You need to create a custom OAuth application in Azure Active Directory and configure it as an IdP. To do so, follow the instructions in the Help documentation. Then set the following properties:

   • AuthScheme: Set this to "AzureAD"
   • InitiateOAuth: Set this to GETANDREFRESH. You can use InitiateOAuth to avoid repeating the OAuth exchange and manually setting the OAuthAccessToken.
   • OAuthClientId: The Client ID obtained when setting up the custom OAuth application.
   • OAuthClientSecret: The Client secret obtained when setting up the custom OAuth application.
   • CallbackURL: The redirect URI defined when you registered your app. For example: https://localhost:33333
   • AzureTenant: The Microsoft Online tenant being used to access data. Supply either a value in the form companyname.microsoft.com or the tenant ID.

     The tenant ID is the same as the directory ID shown in the Azure Portal's Azure Active Directory > Properties page.

4. Click Create & Test
5. Navigate to the Permissions tab in the Add HCL Domino Connection page and update the User-based permissions.

With the connection configured, you are ready to connect to HCL Domino data from Excel for the web.

Access Live HCL Domino Data in Excel for the web

The steps below outline connecting to CData Connect Cloud from Excel to access live HCL Domino data.

1. Log into Excel, create a new sheet (or open an existing one).
2. Click Insert and click Office Add-ins. (if you have already installed the Add-In, jump to step 4).
3. Search for CData Connect Cloud Add-In and install the Add-in.
4. Click Data and open the CData Connect Cloud Add-In.
5. In the Add-In panel, click Authorize to authenticate with your CData Connect Cloud instance
6. In the CData Connect Cloud panel in Excel, click Import
7. Choose a Connection (e.g. Domino1), Table (e.g. ByName), and Columns to import
8. Optionally add Filters, Sorting, and a Limit
9. Click Execute to import the data

Live Access to HCL Domino Data from Cloud Applications

New, you have a direct, cloud-to-cloud connection to live HCL Domino data from your Excel workbook. You can add more data to your workbook for calculations, aggregations, collaboration, and more.

Try CData Connect Cloud and get real-time data access to 100+ SaaS, Big Data, and NoSQL sources directly from your cloud applications.