Establishing a Connection
Configure a Connection Profile
From the CData ribbon, click Get Data and select From Domino connection/s to launch the CData Query window. To setup a new connection, you will have to click the New Domino Connection button. Here you can set the connection settings, test the connection, and save the connection profile.
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.
- DataSource: The datasource to connect to on the Domino URL.
Notes
- DataSource: is the scope name found in your Domino Admin UI. Go to your Domino Admin UI, navigate to the Scope Management page, and obtain the scope name you want to connect to.
Authenticating to Domino
Domino supports the following types of authentication:- OAuthJWT
- AzureAD
OAuthJWT
This authentication method exchanges Domino user credentials for a JWT token. This method uses Domino's internal JWT provider. To authenticate using OAuthJWT authentication, set AuthScheme to OAuthJWT and set the following properties:- User: The username of the authenticating Domino user.
- Password: The password associated with the authenticating Domino user.
AzureAD
This authentication method uses Azure Active Directory as an IdP to obtain a JWT token. This method is used as an external JWT provider. You need to create a custom OAuth application in Azure Active Directory and configure it as an IdP. To do so, follow the instructions here: https://opensource.hcltechsw.com/Domino-rest-api/howto/IdP/configuringAD.html. To authenticate using AzureAD authentication, set AuthScheme to AzureAD and set the following properties:- OAuthClientId: Set this to the Client ID obtained when setting up the custom OAuth application.
- OAuthClientSecret: Set this to the Client secret obtained when setting up the custom OAuth application.
- CallbackURL : Set this to the redirect URI defined when you registered your app. For example: https://localhost:33333
Notes
- AzureTenant is generally supplied in the form companyname.microsoft.com, but it is
also acceptable to specify the tenant Id. (The tenant Id is the same as the directory Id shown in the Azure Portal Azure Active Directory > Properties page.)
When OAuthGrantType is set to CODE (the default), AzureTenant is usually not needed unless the user belongs to multiple tenants. When OAuthGrantType is set to CLIENT, AzureTenant is required.
- The AzureAD AuthScheme is generally used with a custom OAuth application to establish the required OAuth credentials. These usually take the form of an account identifier or cllient ID, and the account password or client secret.
Connection Properties
The Connection properties describe the various options that can be used to establish a connection.
Managing Connections
After successfully authenticating to Domino you will be able to customize the data you are importing. To learn more about this, see Managing Connections.
See Also
- Querying Data: Use the data selection wizard to pull data into a spreadsheet. You can also configure scheduled data refresh here.
- Using the Excel Add-In: Find other ways to interact with Domino data, such as using the available CData Excel Functions.