I have worked through this solution on my end and have everything in place to extract data in MS Excel using a 32 bit ODBC driver as a bridge. Configure authentication for NotesSQL. So I’m slightly confused! So yes turns out this is the case, however the core problem was the security system mcafee thinking Alteryx was malware, so it was blocking the connection. Alteryx Everything, Leave no one behind.

Uploader: Yozshull
Date Added: 28 February 2013
File Size: 60.42 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 55313
Price: Free* [*Free Regsitration Required]

No meta data view to select tables or build query, no errors. Below you can find the steps I’ve learned through these experiments. What should I do?

Mat Newman

What i now get is just a table list, but no visible schema. Since there isn’t a 64 bit Notes client available we have tried installing the 64 bit Domino server.

Now I have nsf file on my local machine and lotus notes. I tried on https: Your browser appears to have JavaScript disabled or does not support JavaScript.

Please refer to your browser’s help file to determine how to enable JavaScript. I want to use a Domino database on a server as a potential SQL source for other systems.

If compiled in 64 bits the error is thrown. Thank you very, very much. If at first you don’t succeed, try, and ontessql, and try, and try, and try, and try again! Remove all spaces between IBM entries Copy notes.


HOWTO: Connecting to a Lotus Notes / Domino application using ODBC and Linked Server – OutSystems

Can this be clarified? Disable the Lotus Domino Services to make sure they don’t start when you restart the machine you really need to this, otherwise the odbc connection will not work.

Hope this helps someone out there in the community! Choose to configure it as a “Domino Utility Lofus when asked. I have a requirement to pull some legacy data from Lotus Notes and at the moment I am working through a 32 bit Lotus Notes Client. It is not available on the regular NotesSQL page. I already reinstalled lotus notes with no success.

Solved: Connecting to Lotus Notes SQL – Alteryx Community

Traveler 9. Option 2 should be possible but does imply an additional redirection as you cannot manipulate the database which is managed by OutSystems. Path seeting reboot doesn’t litus to be required, Windows 7 64bit Enterprise Add this to path variable or equivalent for your machine Is this the correct installation pack for that purpose?

Now we can spend many hours trawling google again for error and ‘Setup cannot locate a supported version’ errors, before finally giving up until the next release.


I haven’t been able to figure out the exact permissions needed but, for a proof of concept phase, you can just give this user sysadmin permission and it will work fine.

If there is anyone out there who has set this up would appreciate any insight. Configure authentication lootus NotesSQL. Running a simple grap everything query was returning a “Root element is missing” message, which then suddenly righted itself after a few attempts We use Lotus Notes version 8.

Two options came up as the most promising ones Using Interop to orchestrate the Lotus Notes Client or It is possible ,otus other version of the ODBC file installer are needed for different Notes versions. But the driver still will not work. This site uses different types of cookies, including analytics and functional cookies its own and from other sites.