Features of NotesDB
NotesDB allows you to
- export data directly into databases or
- create an SQL stream with all INSERT-statements necessary to export the whole database.
- run automated on a day-by-day basis to allow automated export.
- run only using a Notes client installation.
Database size
NotesDB has no limits regarding database size. So your database can have hundred-thousands of documents and gigabytes of data.
Automatic and optimized table creation
NotesDB will scan all your documents in the database and use this data to size the database tables.
So your database tables will be created depending on the maximum size of data in the document fields.
NotesDB allows to add a buffer percentage so your data will be able to grow further in the RDBMS.
File attachments
File attachments are automatically exported to the local filesystem.
NotesDB creates separate folders for each document and stores all attachments in it.
Configurable folder structure
The name of the folders is the DocumentUniqueID by default, but can be configured using a Notes formula. This means
you can use your own unique key for the folder name of each document.
Meta-Information about all attachments
A separate database table provides information on all the attachments contained in each document.
The database table provides details about the attachment:
- filename
- filesize (in bytes)
- date created
- date last accessed
- date last modified
- full path of the attachment
Store all attachments as BLOBs
The Enterprise Edition allows you to store the HTML content and all file attachments into your database.
The HTML content will be stored as CLOB, the file attachments will be stored as BLOBs.
You can customize the data type in a configuration file.
Richtext items
NotesDB allows you to convert all the richtext data into HTML-format and MS Word / RTF format easily, without any programming.
By pressing just the export richtext-button, NotesDB will extract all documents in the database in HTML format.
Afterwards, you can convert the HTML documents to MS Word/Richtext format easily.
The HTML documents will include all embedded images, attachment references and any document links.
Export of Richtext items is only supported by the Enterprise Edition.
Embedded Objects 
The Enterprise Edition allows you to extract the Embedded Objects in their original, editable format.
You can extract any MS Word embedded objects as an editable MS Word file.
Supported formats include
- All versions of MS Word (6.0, 2003, 2007)
- All versions of MS Excel (5.0, 97, 2003, 2007).
Additional formats are available on demand.
Export of Embedded objects is only supported by the Enterprise Edition.
Folder references
NotesDB can export all the folders a document is contained in.
This enables you to reuse the existing folder infrastructure in the new relational database.
NotesDB does this by searching through all database folders individually.
This means, that this feature is independent of the new "Folder References" feature since R5, which keeps track of the folder references in a separate
document item.
Export of Folder references is only supported by the Enterprise Edition.
|
View sample conversion results (HTML, Word Richtext) of a sample database
