patvdv
17th August 2001, 08:47
What database technology are you using at your site or alternatively as a consultant, what is the most used database for your implementations?

victor_cleto
17th August 2001, 11:04
From Baan I can say that:

NT OS installation use mostly MS SQL. Then Oracle/Informix in more or less equal parts.
HP-UX installations use mostly Oracle
SunOS installations use mostly racle, then Informix
AIX installations use mostly Oracle, then DB2/Informix
AS400 uses DB2/Oracle
Others systems are very unusual, but mostly use the cheapest solution (like Informix?)
Free OS, like SCO/Unixware usually use TBase or a remote commercial DB running on other UNIX/NT OS

Ravenscross
17th August 2001, 12:52
Being a consultant (and in a previous life, user), I come across many different versions. The most common one I work on is either NT with SQL or HP-UX with Informix. Of course, these both have the benefit of being cheaper that the usual mix and that also comes into play with the choice *see other forums for view of expense over choice*

Jason
17th August 2001, 14:44
I seem to remember hearing once that something like 53% of installations are on Oracle. Not sure how accurate this is. I think that over 50% use Oracle but not sure how many exactly.

patvdv
17th August 2001, 14:49
Let's see if our poll comes up with similar percentages :)

victor_cleto
17th August 2001, 15:25
Humm... most of the Baan installations are for small/medium companies, way under 100 concurrent users (read NT+SQL mostly). This can afford a stop of everything to do a MS backup...

Big companies (more than concurrent 100/200 users?) use robust and with added backup/restore functionality databases (read "Oracle"). This ones are usually 24x6/7 online.

So, if you count the installed base of Baan, the first one will win, but if you count the number of users, probably the second one will win.

Gerhard
17th August 2001, 16:41
There are still a lot of customers running older Baan software from Triton 3.1 to Baan IVc4, that are using Baan Base (tbase). From the german customers using a RDBMS about 65 % use Oracle.

lwatson
21st August 2001, 18:40
We use MS SQL 2000 w/ Baan 5c and 300 users.

Jason
21st August 2001, 18:45
at present Oracle has 55% so my early prediction wasn't too bad.
We'll see how things develop - the few votes cast so far hardly count for valid statistics! :)

victor_cleto
30th August 2001, 08:19
This is from a newsletter I received, regarding the statistics gathered by BWU [Baan World Users]:

1. What versions of Baan are being used ?
4% operate on a Triton version of Baan
54% operate on Baan IVC3 or earlier
31% operate on Baan IVC4
11% operate on Baan ERP

2. What databases do Baan sites utilize?
Oracle tops the list with 51% of our membership
Informix follows with 21% representation
SQL with 13%
MSSQL with 8%
Tribase with 5%
DB2 with 1%
Exchange with 1% (this is used also :eek: ?)

3. Ever wonder about multi-site ?
52% of the organizations that responded are Multi-Site
34% are Multi-Logistic
43% are Multi-Financial

superman
5th September 2001, 23:36
The poll should allow more than one vote. We use Oracle in production and tbase in development

patvdv
5th September 2001, 23:49
The poll only allows one vote to avoid that the actual outcome becomes too unreliable. The idea is that you indicate which technology you used most or which is used in your main environment, ie. production environments.

DavidS
11th September 2001, 12:30
Perhaps some polls could allow only one opportunity for each user to vote, but allow multiple selections to be made at that time if appropriate, a sort of proportional representation system as opposed to a first past the post?

patvdv
11th September 2001, 12:56
The poll option on the bulletin board is not one of the core strenghts, it is more of a gimmick or add-on. So bear with the limited functionalities of it :) Currently, multiple votes are not supported.

DavidS
13th September 2001, 18:09
Well, never mind...it works well enough as it is and I'm sure it isn't beyond the wi of most contrbuters here to determine which answer is most relevant for them.:)

DavidS
13th September 2001, 18:11
:eek: That should read "wit of most contributors", which I today seem to possess very little of!

patvdv
14th September 2001, 16:52
It is human to make typing errors but you maybe you have not noticed the option that you have to edit your own posts!