Connection to and Extraction from IBM Database

[CMB123]

Thank you for TPP - I have been a happy and satisfied user for around 3 years now.

Can TPP extract text from an IBM Louts Notes 8.5 DB? I don't need to update tables, just extract.
The help section referenced the Filters\Special section and Database connection using the 'build' function, but I only see MS Access.
Is it as simple as browsing to the DB? Is there an example of a 'connection string'? Would DataPipe be a better choice? Thanks.

[DataMystic Support]

Hi there,

DataPipe is for modifying data while it stays in the database, so for extracting, TP is the better choice.

With TextPipe, use the database filter and click the [Build] button. Using this you should be able to browse to your notes db (provided the correct DB drivers are in place).

To test it, put text in the trial run area like

Code: Select all

select * from tablename

And press [F5] for a trial run.

[CMB123]

Thank you Simon.

I was able to install the NotesSQL driver from IBM, setup the ODBC connection on my workstation and then used the database filter to build a connection to the database.
TextPipe worked like a champ.

Thanks again.

[DataMystic Support]

Excellent! Thanks for letting us know.