Getting Started with the CData ADO.NET Provider for HCL Domino
This guide explains everything you need to work with the CData ADO.NET Provider for HCL Domino. You will learn how to install the provider, set up a connection to your HCL Domino data, and run simple commands in your .NET applications using familiar ADO.NET patterns.
Whether you are building desktop apps, web apps, or background services, the provider enables secure, high-performance connectivity to live HCL Domino data without needing to manage API details manually.
Installation and Licensing
System Requirements
- Windows: Windows 10/11 or Windows Server 2016+
- .NET Versions: .NET Framework 4.0+, .NET 6+, .NET Standard assemblies
- IDE: Visual Studio 2017 or later
Installing the ADO.NET Provider
Windows Installation
- Download the ADO.NET provider installer from your CData account or the evaluation page.
- Run the installer and follow the installation wizard to completion.
- The installer registers the provider and places all assemblies in the appropriate CData installation folders.
-
You will be prompted for your license key during installation:
XXXX-XXXX-XXXX-XXXX-XXXX- Note: If you are using a trial, select Trial Key instead.
Activating your License
Licensing behavior varies depending on whether you are developing with the .NET Framework or .NET Standard. Use the steps below to activate the provider in your environment.
.NET Framework (Windows)
On Windows using the .NET Framework, no extra action is required. The installer or NuGet package automatically installs your development license.
.NET Standard (Windows/Mac/Linux)
For .NET Standard platforms like .NET Core, Mono, or Xamarin, you must install a license manually before using the provider.
Using the Install-License Tool
The toolkit includes an install-license utility in the
lib/netstandard2.0folder for applying trial or full licenses.
To install a trial license:
dotnet ./install-license.dll
To activate a full product license:
dotnet ./install-license.dll
After running the tool, your development machine is licensed and ready to use the provider in .NET applications.
Runtime Licensing
When deploying applications, specify the Runtime Key (RTK) in your connection string to enable redistribution.
| Property | Description |
|---|---|
| RTK | Your Runtime Key used for deployed ADO.NET applications. |
Common Licensing Questions
Can I use my license on multiple machines?
Yes, depending on your subscription tier. If unsure, review your order confirmation or contact [email protected].
I lost my license key. How do I retrieve it?
Email [email protected] with your order number.
Can I transfer my license to another machine?
Submit a License Transfer Request:
https://www.cdata.com/lic/transfer/
Once approved, an activation is added to your product key and the previous installation becomes invalid.
For more licensing support, visit portal.cdata.com or email [email protected].
Connection Configuration
Once installed, the next step is to configure a connection to HCL Domino. Connections are created using ADO.NET connection strings in your .NET application's code or configuration file.
Creating a connection manager
- Open Visual Studio.
- Navigate to View, select Server Explorer.
-
Click Connect to Database from the left sidebar.
- In the Add Connection dialog, click Change.
-
Choose CData HCL Domino data source, then click OK.
Configuring Connection Properties
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 Entra ID (formerly Azure AD) 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.
EntraID (formerly AzureAD)
This authentication method uses Entra ID (formerly Azure AD) as an IdP to obtain a JWT token. You need to create a custom OAuth application in Entra ID (formerly Azure AD) 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 "EntraID (formerly 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 Entra ID (formerly Azure AD) > Properties page.
Test your connection
- Click Test Connection.
- Once the connection is successful, you can explore the data inside Visual Studio.
Common Connection Issues
Authentication Failed
Solution: Verify OAuth settings, client IDs, secrets, or token permissions for your HCL Domino. Contact [email protected] for assistance.
Cannot Reach Server
Solution: Check firewall, proxy, and VPN configurations. Contact [email protected] for required port information.
Table Not Found
Solution: Confirm you selected the correct schema or database when querying HCL Domino.
What's Next
Now that you have installed, licensed, and configured the ADO.NET provider, here are scenarios you can use to explore our ADO.NET tools:
| ADO.NET Providers | Article Title |
|---|---|
| LINQPad | Working with HCL Domino in LINQPad |
| Microsoft SSAS | Build an OLAP Cube in SSAS from HCL Domino |
| TIBCO Spotfire | Visualize HCL Domino in TIBCO Spotfire through ADO.NET |
| .NET Charts | DataBind Charts to HCL Domino |
| DevExpress | DataBind HCL Domino to the DevExpress Data Grid |
| EF - Code First | Access HCL Domino with Entity Framework 6 |
| EF - LINQ | LINQ to HCL Domino |
| EF - MVC | Build MVC Applications with Connectivity to HCL Domino |
| PowerBuilder | Connect to HCL Domino from PowerBuilder |
Get Support
If you need assistance at any point:
- Technical Support: [email protected]
- Community Forum: CData Community Site
- Help Documentation: Installed locally and available online
FAQs
Installation and Licensing
-
Do I need administrator rights to install the ADO.NET Provider?
Yes, administrator rights are required to install components for use across Visual Studio. -
Do I need an RTK to deploy to Azure Data Factory?
Yes. Set the RTK property in your application's connection string before publishing.
Connecting
-
Can I use multiple HCL Domino accounts?
Create separate Connection =strings for each account. -
Can I connect through a proxy?
Yes. Configure proxy settings in the Connection string. -
How do I test my connection?
Click Test Connection in the Connection Manager UI.
Performance & Troubleshooting
-
How can I improve query performance
Apply filters, limit row counts, and leverage server-side paging properties. -
How do I enable logging?
Add the following to your connection manager:- Logfile: /path/to/logfile.log
- Verbosity: 3
Be prepared to securely upload the log file upon request when reaching out to [email protected] for troubleshooting analysis.
For questions not covered in this FAQ, contact [email protected].