QlikView ODBC Lotus Notes

Thanks to QV - Community Post for details : http://community.qlik.com/thread/12541

Very useful for LOTUS Note Connection

To use Notes data through ODBC, you must have:

• Notes SQL, the Lotus Notes ODBC driver
• An ODBC Driver Manager version 3.5 or later
• One of the following:
  • Microsoft Windows 2000, or XP
  • Microsoft Windows 2003 Server Standard Edition or Enterprise Edition
  • Microsoft Windows Vista
  • Microsoft Windows 2008
  • Microsoft Windows 7
• One of the following:
  • Lotus Notes Client release 6.0 or later
  • Lotus Domino release 6.0 or later
  • Lotus Notes Designer release 6.0 or later
  • Lotus Domino Off-Line Services release 1.01 or later

OK, and then few steps: (this works in windows 7 x64)

1) Install NotesSQL - driver  to C:\NotesSQL

2) add your Lotus Notes directory to the %PATH% Variable

3) Reboot

4) run c:\windows\syswow64\odbccad.exe

5) You should now find the NotesSql ODBC driver to create the ODBC connection normally

QlikView - How to delete category from Access Point !

Customer Requirement:

QV Server Admin / Customer usually creates Document Categorization for Access Point Application grouping.

This is done using under 

• "http://localhost:4780/QMC/UserDocuments.htm#" - > "User Documents" - > "Document Information"

Issues:

•  Also during UAT phase Multiple Categorization were created.
• But as we move to live environment and everyone would like to delete category from the Access Point.
• At this moment - there is no Wizard or QMC settings to do the same.

Solution:

We need to manually delete the categorization under  

•  C:\ProgramData\QlikTech\ManagementService\QVPR\Category.xml 
• Delete the line that corresponds to the category you are looking for.

Thanks QV Support & Community Posts for helping on this issue.