Stand-alone query tool

NvanBeest · #1 11th November 2003, 13:31

Hi all!

In my spare time, I started building a stand-alone, direct query tool for Baan. It is a Windows based application, and uses TCP/IP messaging and qptool to execute the queries, and thus is database independant like Baan itself. When starting the program, the data dictionary of Baan is scanned and stored. Thereafter, the program displays a query tool like the one found in Crystal and other packages, with drag-and-drop.

With this poll I would like to find out whether there is any interest for such a tool. I will then dolly it up, and make it available as a shareware utility program.

OmeLuuk · #2 17th December 2003, 10:30

I cannot opt for "I use standard Baan tools (ttadv3180m000, qptool, gcommand, queries in reports and 3GL programming) already...

Francesco · #3 17th December 2003, 18:44

But knowing Nico a little, I am sure his tool will bring added value.

Jacobwd · #4 19th December 2003, 16:16

Nice idea Nico, no disrespect but my guess is many companies would be nervous about trusting their reporting capability to shareware.

Lots of users in the UK are talking about a company called Cyberscience - who are apparently replacing Crystal and Safari as the report-writer of choice for Baan???

If there is something they DON'T do, maybe that's your opportunity?

Jacob

NvanBeest · #5 27th October 2004, 22:22

The idea is still somewhere in the cupboard...

The idea is not to build a reporting tool, but just a tool to do adhoc queries. If possible, I will try to make it comparable with MS Query, so the results could be imported/stored in Excel. The idea started when I was doing a lot of data analysis, using ASCII dumps and importing it into Excel, which is not the best way of doing things...

Well, for 14 people I might just pull the idea out of the cupboard, and actually make it a project. More voters/comments?

~Vamsi · #6 28th October 2004, 00:15

What would be the model of distribution. Is this going to shareware/commercial/open source/freeware.

After you posted this thread, we have had Nasdaq come up with a product already

. Also I wrote something up that I use from within Excel using standard windows libraries - based on the ideas you posted in this and one other thread.

NvanBeest · #7 28th October 2004, 11:01

Quote:

What would be the model of distribution. Is this going to shareware/commercial/open source/freeware.

I was actually thinking of a style similar to the board: donationware!

Quote:

After you posted this thread, we have had Nasdaq come up with a product already

.

Hmmm... Will have to look into it... Any links?

Quote:

Also I wrote something up that I use from within Excel using standard windows libraries - based on the ideas you posted in this and one other thread.

Hey man! Good for you! Is this the BaanXL? Or some other tool? Where can I find it? Seems to me I really have to stay in touch with the board more...

bamnsour · #8 28th October 2004, 13:10

Thank you ~VAMSI for pointing to our product BaanMate.

BaanMate is really a powerful tool for accessing the Baan Database. It works in the meantime with Oracle ODBC and SQL Server, and in addition, uses QPTOOL to access any Baan Database include T-Base, Informix, DB2 or any other.

It is a really friendly tool. It allows you to work with the Baan Data Dictionary instead of writing queries with company numbers and 4 digit variable names.

Here is the link for downloading an evaluation copy http://www.nazdaq-it.com/utilities.php?prod=baanmate

~Vamsi · #9 28th October 2004, 18:38

The Nazdaq tool is here http://www.nazdaq.co.il/ask-qptool.shtml.

The tool I wrote is not available to the public - atleast not at this time.

NvanBeest · #10 6th April 2006, 20:36

One thing still needed... (IMNSHO

)

This tool will show the tables names and fields as they exist in the database, not? Thus, wish I could modify it to read the real table and field names from the Baan data dictionary...

Just a thought!

PS. Since I have not been working with Baan for a couple of years now, this project is still shelved...

norwim · #11 18th April 2006, 16:33

Hi there,

I just posted something related to this topic in the german board.
Summary: With some shell and awk scripts evaluating some bdbpre-dumps of certain tools tables and of course the files in the data dictionary, I managed to get a pretty good tool to
a) create sql scripts and data files to create and fill tables in any DB (tested and running with mysql so far) and
b) compress and translate dbs.logs to reasonable small and human readible protocols of Inserts/Updates on Baan tables
I will be happy to share these scripts with you.
I am afraid that some further scripting will have to be done for installation routines and suchlike, the state of these tools atm requires some knowlege of shell programming, awk and last not least Baan to get them to run.

regards and complements to this excellent board

Norbert

NvanBeest · #12 4th April 2008, 23:21

Always happy to share!

If you need some help with extra scripting, post it here or PM, and I (or someone else) will gladly help!