There are several approaches:
- Build the relational tables and use DECS (Domino Enterprise Connectivity Services) to map the document fields to relational columns.
- Consider using a more sophisticated tool like Lotus Enterprise Integrator or third party tools from Percussion, Casahl or Trilog Group.
- Build a Java program that accesses Domino data through the Domino Java API and pushes the data to the relational tables using JDBC calls.
- Convert the Domino data to XML using DXL and push it through an XML/relational bridge. This approach allows you to be independent of the database (SQL Server, Oracle, DB2).
- It is possible that Domino 7 with the DB2 backend may have some additional capabilities in the final version.
Do you have comments on this Ask the Expert question and response? Let us know.