Skip to Main Content
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

Status Shipped
Workspace Domino
Created by Guest
Created on Jul 20, 2018

64bit Notes ODBC driver to support 64bit applications (eg. 64bit Excel) on client machines

Currently, to connect using ODBC to a Notes database on Domino the application needs to be 32bit, so 64bit Excel (the majority) can't use the current ODBC drivers to read Notes data.

This is a severe limitation, especially as there is no other easy way to read Notes data using applications such as Excel or other reporting tools.

If this was available it would open up many ad hoc reporting and querying possibilities with tools such as Excel and Access.  As these are tools that many people already use and are familiar with, it would allow both Developers and power users to create quick and effective solutions to many information requirements.

  • Attach files
  • Guest
    Reply
    |
    Dec 19, 2022

    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!

  • Admin
    Thomas Hampel
    Reply
    |
    Aug 13, 2021

    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

  • Guest
    Reply
    |
    Feb 26, 2020

    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

  • Guest
    Reply
    |
    Feb 24, 2020

    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...

  • Guest
    Reply
    |
    Feb 24, 2020

    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)

  • Guest
    Reply
    |
    Feb 14, 2020

    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.

  • Guest
    Reply
    |
    Feb 9, 2019

    This is a matter of improving regular export/import, not ODBC.

    ODBC and NotesSQL are hopelessly outdated.

  • Guest
    Reply
    |
    Sep 11, 2018

    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.

  • Guest
    Reply
    |
    Jul 22, 2018

    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. 

  • Admin
    Thomas Hampel
    Reply
    |
    Jul 21, 2018

    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?