HCL Domino Ideas Portal
Welcome to the #dominoforever Product Ideas Forum! The place where you can submit product ideas and enhancement request. We encourage you to participate by voting on, commenting on, and creating new ideas. All new ideas will be evaluated by HCL Product Management & Engineering teams, and the next steps will be communicated. While not all submitted ideas will be executed upon, community feedback will play a key role in influencing which ideas are and when they will be implemented.
For more information and upcoming events around #dominoforever, please visit our Destination Domino Page
Hi Thomas, after I tried that driver I didn't succed (have a support call open). Also the CDATA driver is yet in beta version since your post (1year and half ago) and they saied it will be released only in Q1 of 2023!
Notes SQL ODBC drivers are succeeded by CDATA drivers which are now supporting HCL Domino. https://www.cdata.com/
A demo was done at the Domino V12 launch event: https://youtu.be/FnJ-Z5Zzb0c?t=1662
Well, just install Domino 9 , 64b on the server hosting windows server 64b (maybe you can try on Windows 10) and your software talking thru ODBC. Just install, no setup needed. That will install and register ODBC Dlls ...
The idea for HCL would be to propose a simple setup to install only DLLs dealing with ODBC for Domino, without having to install a whole Domino server
Interesting, more info on the local Domino Server install please. What Domino version have you tried this on ??
I have a government client that currently uses 32bit ODBC to legacy notes apps for reporting. Moving to O365 Pro Plus = no 32 bit ODBC support .
Clients will be doing cartwheels if they can connect PowerBI to their Notes databases. 64bit ODBC looks to be the closest 'quick win' option as far as I can see...
Actually, it seems you have to install Domino server for 64b to have ODBC dlls installed properly on your windows computer... (just install, not use domino server)
Improving import/export would be one way to address this but it would need to provide a way to programmatically access this import/export functionality. We have systems built that provides a web-based reporting structure too much of our data on a real-time basis so programmatic support for data access is really important.
This is a matter of improving regular export/import, not ODBC.
ODBC and NotesSQL are hopelessly outdated.
We are using QlikSense for data analytics and dashboards. Need 64 bit ODBC to be able to load data into it directly. Direct download of data from view to Excel would be great for ad-hoc reports/analysis.
The business requirement I am thinking about is of being able to analyse Notes/Domino data using Pivot tables and Pivot charts in Excel. To do this I need to be able to import Notes data into an Excel 'table' before creating the pivot tables and charts. This spreadsheet can then be given to business users who can slice and dice and derive extremely useful ad hoc information from their Notes data. One key requirements is for the users to be able to refresh the data (from Notes into Excel) with a single button click.
One way to make all this happen would be with ODBC, but this is not possible today as most Excel installs I see are 64bit and so can't use the current NotesSQL drivers. This is why I suggested having NotesSQL support 64bit applications.
If another method was provided that allowed Excel to connect directly to Notes data, with the ability to use the Excel refresh button to pull in the latest data, then I would have much less need for ODBC.
Is this question about the ODBC driver in specific or in general about a more clever method to create ad hoc reports, data exports, etc. from a Domino data source?