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.

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

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

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

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?

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.

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!

After you posted this thread, we have had Nasdaq come up with a product already :).Hmmm... Will have to look into it... Any links?

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

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

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.

Raptor is Oracle’s free version of Toad and it does not require a Oracle client install.

http://www.oracle.com/technology/products/database/project_raptor/index.html

Download Oracle SQL Developer 1.0 (formerly Project Raptor)

Dear OTN Member:

SQL Developer (formerly Project Raptor) has hit a nerve: It's been downloaded more than 100,000 times since the first Early Adopter Release in late December.

Now in production, SQL Developer (which is available on Mac OS X as well as Windows and Linux, BTW) makes basic database development a visual experience; it offers all the benefits of the command line along with a slick GUI (based on the same stack as Oracle JDeveloper), and it's free. Get more information at oracle.com/technology/sql-developer.

Refer to the - Oracle SQL Developer, Pricing FAQ (http://www.oracle.com/technology/products/database/sql_developer/files/pricing_faq.html)

Oracle SQL Developer Cost Questions:

Is SQL Developer free?
Yes.

Will the production version be free?
Yes.

Oracle SQL Developer Support Questions:

Is the production release of SQL Developer supported by Oracle Support?
The production release of SQL Developer is supported by Oracle Support for any customers with support for the database they are using SQL Developer against.

One thing still needed... (IMNSHO :D)

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

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

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!