Unanswered: lotus notes data to DB2 UDB
Currently I am reporting on Lotus Notes databases (.nsf) through Notes SQL drivers. This works, but since Lotus Notes databases are non-relational there are many limits (can not create intermediate views, not having SQL functions in database)
I was contemplating to somehow upload data from the .nsf file to DB2 tables to get more functionality. Has anyone had a crack at this before, or any usefull links on this subject?
Senior Application Developer BI
SQL, SQL server