Baanboard.com

Go Back   Baanboard.com > Forum > CMS - Forum Integration > Polls and Surveys

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

View Poll Results: Would you be interested in a stand-alone query tool for Baan?
Yes, definitely! 28 49.12%
Maybe, depends on the price... 21 36.84%
No, since we have third-party tool already 8 14.04%
Voters: 57. You may not vote on this poll

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 11th November 2003, 12:31
NvanBeest's Avatar
NvanBeest NvanBeest is offline
Guru
 
Join Date: May 2003
Location: South Africa
Posts: 521
NvanBeest is on a distinguished road
Baan: BaanIVc4 - DB: Oracle, TBase, SQL Server - OS: AIX, Linux, Window$
Stand-alone query tool

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.
__________________
Regards,
Nico
  #2  
Old 17th December 2003, 09:30
OmeLuuk's Avatar
OmeLuuk OmeLuuk is offline
Guru
 
Join Date: Mar 2002
Location: The Netherlands
Posts: 1,072
OmeLuuk is on a distinguished road
Baan: Infor LN 6.1 10.2.1 - DB: MS SQL2008 - OS: VM WindowsServer2008R2
I cannot opt for "I use standard Baan tools (ttadv3180m000, qptool, gcommand, queries in reports and 3GL programming) already...
__________________
Also read Luke 24:4-8
  #3  
Old 17th December 2003, 17:44
Francesco's Avatar
Francesco Francesco is offline
Guru
 
Join Date: Aug 2001
Location: Antwerp, BE
Posts: 727
Francesco is on a distinguished road
Baan: 5b - DB: Oracle - OS: Solaris
I second that one

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

Francesco
..............................................................

Admiral Business Solutions | My World | Baan Board | IT Happens!

"If everyone is thinking alike, then somebody isn't thinking" -- George Patton
"It's easy to cry 'bug' when the truth is that you've got a complex system and sometimes it takes a while to get all the components to co-exist peacefully." -- Doug Vargas
  #4  
Old 19th December 2003, 15:16
Jacobwd's Avatar
Jacobwd Jacobwd is offline
Junior Member
 
Join Date: Oct 2003
Location: UK
Posts: 16
Jacobwd is on a distinguished road
Baan: 4c4 - DB: SQL7 - OS: NT
Stand-alone Query Tool

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
  #5  
Old 27th October 2004, 21:22
NvanBeest's Avatar
NvanBeest NvanBeest is offline
Guru
 
Join Date: May 2003
Location: South Africa
Posts: 521
NvanBeest is on a distinguished road
Baan: BaanIVc4 - DB: Oracle, TBase, SQL Server - OS: AIX, Linux, Window$
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?
__________________
Regards,
Nico
  #6  
Old 27th October 2004, 23:15
~Vamsi's Avatar
~Vamsi ~Vamsi is offline
Guru
 
Join Date: Aug 2001
Location: San Diego CA, USA
Posts: 590
~Vamsi will become famous soon enough
Baan: ~*~ - DB: ~*~ - OS: ~*~
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.
__________________
~Vamsi
Vamsi Potluru
Baan XL Yet another tool to format Baan output in Excel from Baan Board
This one just happens to be free :)

Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Sponsored Links
  #7  
Old 28th October 2004, 10:01
NvanBeest's Avatar
NvanBeest NvanBeest is offline
Guru
 
Join Date: May 2003
Location: South Africa
Posts: 521
NvanBeest is on a distinguished road
Baan: BaanIVc4 - DB: Oracle, TBase, SQL Server - OS: AIX, Linux, Window$
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...
__________________
Regards,
Nico
  #8  
Old 28th October 2004, 12:10
bamnsour's Avatar
bamnsour bamnsour is offline
Senior Member
 
Join Date: Nov 2001
Location: Nazareth
Posts: 156
bamnsour is on a distinguished road
Baan: 4b, 4c, 5b, 5c - DB: all - OS: Unix, NT
The Nazdaq Tool - BaanMate

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
__________________
- Bader

Visit our web site at www.nazdaq-it.com

Last edited by bamnsour : 24th January 2006 at 16:10.
  #9  
Old 28th October 2004, 17:38
~Vamsi's Avatar
~Vamsi ~Vamsi is offline
Guru
 
Join Date: Aug 2001
Location: San Diego CA, USA
Posts: 590
~Vamsi will become famous soon enough
Baan: ~*~ - DB: ~*~ - OS: ~*~
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.
__________________
~Vamsi
Vamsi Potluru
Baan XL Yet another tool to format Baan output in Excel from Baan Board
This one just happens to be free :)

Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
  #10  
Old 26th January 2006, 19:41
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,028
NPRao will become famous soon enough
Baan: iBaanERP-5.2a(Reger),SSA-ERP-LN-6.1,Infor LN-10.x - DB: Oracle-10g,11g,12c,MS-SQL - OS: HP-UX, Linux, Windows
Thumbs up Oracle DB

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

http://www.oracle.com/technology/pro...tor/index.html
__________________
The art of perfection does not lie in doing extraordinary things but, doing ordinary things extraordinarily well. [-N. Prashanth Rao]
How To Ask Questions The Smart Way,BaaNBoard,NPRao

Last edited by NPRao : 22nd February 2006 at 20:52.
  #11  
Old 6th April 2006, 02:31
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,028
NPRao will become famous soon enough
Baan: iBaanERP-5.2a(Reger),SSA-ERP-LN-6.1,Infor LN-10.x - DB: Oracle-10g,11g,12c,MS-SQL - OS: HP-UX, Linux, Windows
Download Oracle SQL Developer 1.0 (formerly Project Raptor)

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

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.
__________________
The art of perfection does not lie in doing extraordinary things but, doing ordinary things extraordinarily well. [-N. Prashanth Rao]
How To Ask Questions The Smart Way,BaaNBoard,NPRao
  #12  
Old 6th April 2006, 19:36
NvanBeest's Avatar
NvanBeest NvanBeest is offline
Guru
 
Join Date: May 2003
Location: South Africa
Posts: 521
NvanBeest is on a distinguished road
Baan: BaanIVc4 - DB: Oracle, TBase, SQL Server - OS: AIX, Linux, Window$
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...
__________________
Regards,
Nico
  #13  
Old 18th April 2006, 15:33
norwim's Avatar
norwim norwim is offline
Guru
 
Join Date: Oct 2001
Location: Germany Moenchengladbach
Posts: 450
norwim is on a distinguished road
Baan: some - DB: more - OS: many
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
__________________
Have a nice day
  #14  
Old 4th April 2008, 22:21
NvanBeest's Avatar
NvanBeest NvanBeest is offline
Guru
 
Join Date: May 2003
Location: South Africa
Posts: 521
NvanBeest is on a distinguished road
Baan: BaanIVc4 - DB: Oracle, TBase, SQL Server - OS: AIX, Linux, Window$
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!
__________________
Regards,
Nico
Closed Thread


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ERPJewels Hitesh Shah Third Party Products 10 6th November 2006 05:38
Query Tool for on APS Database Frank Rogers Third Party Products 8 5th February 2003 14:27


All times are GMT +2. The time now is 02:16.


©2001-2017 - Baanboard.com - Baanforums.com