Page 1 of 1

Connection to and Extraction from IBM Database

Posted: Tue May 01, 2012 5:08 pm
by 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.

Re: Connection to and Extraction from IBM Database

Posted: Wed May 02, 2012 11:56 am
by 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.

Re: Connection to and Extraction from IBM Database

Posted: Thu May 03, 2012 8:49 pm
by 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.

Re: Connection to and Extraction from IBM Database

Posted: Fri May 04, 2012 9:46 am
by DataMystic Support
Excellent! Thanks for letting us know.