Connection to and Extraction from IBM Database

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
CMB123
Posts: 2
Joined: Tue May 01, 2012 4:33 pm

Connection to and Extraction from IBM Database

Post 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.
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Connection to and Extraction from IBM Database

Post 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.
CMB123
Posts: 2
Joined: Tue May 01, 2012 4:33 pm

Re: Connection to and Extraction from IBM Database

Post 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.
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Connection to and Extraction from IBM Database

Post by DataMystic Support »

Excellent! Thanks for letting us know.
Post Reply