Connection to and Extraction from IBM Database

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

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

Connection to and Extraction from IBM Database

Postby CMB123 » Tue May 01, 2012 5:08 pm

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: 2164
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Connection to and Extraction from IBM Database

Postby DataMystic Support » Wed May 02, 2012 11:56 am

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.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

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

Re: Connection to and Extraction from IBM Database

Postby CMB123 » Thu May 03, 2012 8:49 pm

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: 2164
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Connection to and Extraction from IBM Database

Postby DataMystic Support » Fri May 04, 2012 9:46 am

Excellent! Thanks for letting us know.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: Baidu [Spider], Google [Bot] and 9 guests