We’re planning to move our Domino database to DB2.
Would it be possible to access the Domino databases (NSFDB2) tables on DB2 directly by an other system?
Case: I want to put a Domino database with consolidated data on DB2 and do some reporting on it using a tool interfacing with the DB2 RDBMS system. So the reporting tool needs to access the DB2 database tables directly (which are in a NSFDB2 db).
Thanks for your thoughts and suggestions!
best regards,
Chris Neddermeijer
Subject: Not directly but you can use a DAV to build the tables you can access
The table structure of the database in db2 is not just a simple one. If you need data in NOtes to be available in db2 then use a db2 access view (dav) to build the table. It’s by-directional link to Notes data.
You can then use the new query views can access any of the tables in db2 and display them in a notes view.
Subject: Thanks!
It took me some time to reply, sorry. But I’ll have a look at the DB2 DAV feature!