#dominoforever | Product 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

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.

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Jul 20 2018
  • Likely to implement
  • Attach files
  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    26 Feb 07:54am

    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

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    24 Feb 10:44pm

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

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    24 Feb 03:49pm

    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)

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    14 Feb 02:10pm

    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.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    9 Feb, 2019 04:31am

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

    ODBC and NotesSQL are hopelessly outdated.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    11 Sep, 2018 10:43am

    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.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    22 Jul, 2018 10:18pm

    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 commented
    21 Jul, 2018 12:26am

    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?