Check out this press release for MySQL 5.0.
http://www.mysql.com/news-and-events/news/article_976.html

From the article:

Industry Support for MySQL 5.0

...

SSA Global, a leading global provider of extended enterprise solutions and services, will certify SSA ERP LN 6.1 with MySQL Network 5.0 before the end of this year. "MySQL 5.0, with its enterprise-class features, represents a very cost-effective and proven database alternative capable of meeting our customers' toughest requirements," said Rick Bernard, vice president Solutions Management, SSA Global. "SSA Global is committed to Open Source solutions, and support for MySQL is the next significant step in delivering value to our customers."

Hi All,

From the same article the following quote from Chicago Metallic, an existing BAAN customer in Belgium:


""MySQL 5.0 represents a huge leap in features and functionality for the MySQL database," said Gunter Rombauts, European IT manager for Chicago Metallic. "As a worldwide leader in metal ceiling systems, it's critical that our database supports heavy-duty enterprise applications with speed and reliability. We are looking forward to using MySQL 5.0 as a key component of Chicago Metallic's global IT infrastructure."

The comments of SSA Global in this article relate to certifying MySQL 5.0 as a supported database for LN6.1.
It would be great if the same can be done for BAAN IV any time soon.

"Technology is a commodity and it is the solution that matters" is a statement often made by Mike Greenough, CEO of SSA Global.
That is why we at Qtris are looking forward to supporting the combination of SUSE (Linux based Operating System) and MySQL (OpenSource database) for LN6.1 customers as they would not have to pay one cent on their license costs for the database.

Check out our website http://www.qtris.com/ to find out more on our current BAAN2Linux program for BAAN IV, BAAN V and LN6.1.

Forgive me for being wicked, but I just can't resist this one.

Mr Greenough is well-known for his commodity speech. I don't accept this standpoint, but he must admit that it is, at least, persistent.

CEO's are transient, at best.

Good news. Porting set 7.6b for HPUX has the following comment in the release notes:

List of changes for portingset: 7.6b
MaintDvorak: # 27719 (BDUX20044): MySQL driver: give error 512 on missing column in table
Date: Mon, 3 Oct 2005 16:14:15 +0200 (CEST)

I am amused by the quote credited to Greenough that :"Technology is a commodity and it is the solution that matters". If it is true I think that it would be equally true to say that "solutions" are commodities, and indeed you can buy a whole bunch of ERP solutions that are each lauded by many uses across the globe from the same guy.

I am prepared to give Mike credit for being an outstanding bean-counter and/or Charted Accountant (UK term). He has very cleverly collected the Legacy ERP systems that people still love and are prepared to pay SSA an enormous amount in annual support fees for systems that do not need much support at all. He has even floated the company and raise cash for he and his pals to pocket in return for their small initial investment.

As to running a software company, I think even he would not claim any special expertise or flair. Without going over our earlier debates on the topic, SSA are not a serious developer or marketer of software and show no signs of ever becoming one.

The certification of MYSQL supports the notion that SSA are not big league players or even serious at competing with the big guys. What will MySql give them ? A few small customers who don't want to or who can't pay a reasonable price for licence seats. Will the the Fortune500 companies rush to SSA software so that they can avoid buying Oracle RDBMS licences?

Terry

Found this online...

Development teams from both companies plan to release MaxDB 7.6, which will support 64-bit Linux and HP-UX, said Edwin DeSouza, senior director of product management at MySQL, whose headquarters is in Sweden.

"SAP sees this as very important to reduce the overall TCO of an SAP implementation," DeSouza said. "And SAP is protecting itself also -- by having MaxDB as an alternative to the other vendors out there. The customer can spend most of their dollars on SAP rather than give a whole bunch of it to Oracle or Microsoft or whoever."

Maybe SSA is doing it to reduce the total cost of ownership. They want
to get rid of tbase due to obvious limitations (2GB filesize). but it seems
that the big-boys all have some strategy for releasing a "free" DB with their ERP. Working with MySQL saves them development cycles and gives them a "brand name" Free database..

Dave

...Maybe SSA is doing it to reduce the total cost of ownership...

Is that what SAP are really doing? Or is Mr DeSouza saying 'me too'. They may never sell a site using MySql but may like to be able to get a tick in a comparative analysis.

...but it seems that the big boys all have some strategy for releasing a "free" DB with their ERP...

In the analyses I see the big boys after SAP are No1 ORACLE and No 2 MICROSOFT. Both have pproprietry RDBMS neither of which are free but each claim to be able to prove lowest total cost of ownership.

The fact that SAP can offer MySql counteracts to some extent the negatives I saw with SAA adopting it.

However, I am of the mind that you 'get what you pay for'. If you don't pay for it you can't expect to get much. But will you really not pay much in the long term? May be the company will pay the employee or consultant who pushes the 'free-ness' of MySql for open ended support. I think there is always a case for 'top-drawer' products.

Terry

However, I am of the mind that you 'get what you pay for'. If you don't pay for it you can't expect to get much. But will you really not pay much in the long term? May be the company will pay the employee or consultant who pushes the 'free-ness' of MySql for open ended support. I think there is always a case for 'top-drawer' products.

I think the line is getting thinner in that area though. MySQL isn't too bad from what I've seen although I prefer PostgreSQL. I honestly think that MySQL is better than tbase though! and there are still plenty of people on tbase. I think that overall SSA sees it's market in the mid range and companies in that lower middle range like these types of solutions.

Dave

Is there any update or news on MySQL support for Baan IV or BaanLN

MySQL is limited availability for the latest porting sets of ERP LN.

Can you explain what "limited availability" means?

Is there any docs available? All my searches in ever changing baan support site did not find any useful results.

Any help from board members is really appreciated in advance.

That is the problem with MySQL and even with Linux.
It is supported by Infor SSA BAAN to up to 50 users for LN (hence "limited availability").
But since the service partners are only interested in selling SQL Server, Oracle, etc. to get their commissions, MySQL in combination with LN is going nowhere.
There are some people in BAAN Development who care about MySQL but everybody else do not care at all.
I do not want to sound pessimistic about the chances of MySQL in the BAAN world but as far as I am concerned it is already a lost cause.

The real challenge with MySQL is MySQL itself. The current implementation is not ready to serve more than 50 users. If MySQL solves the outstanding issues I believe that it can become much more mature.

Kind regards,
Dick

In other words: It is the chicken or the egg?

That is the problem with MySQL and even with Linux.
But since the service partners are only interested in selling SQL Server, Oracle, etc. to get their commissions, MySQL in combination with LN is going nowhere.

:D

I want to say something fair about we as service partners. We do want to push the Linux+MySQL platform to the customers. We prefer them to spend more money on ERP licence and service, rather than spend on the handware, OS and database. But it seems the customers are glad to hear the ERP can support Linux+MySQL, but they just not choose this platform at the end.

So far, the most popular platform among our new customers is Windows 2003 + SQLserver. The second popular is AIX + Oracle.

If any new customer in Greater China region can commit to try the Linux+MySQL or Linux+Oracle on Ln, we can offer them the best discounted price we can offer on Ln licence and service for them to be the pioneer.

As someone already mentioned, there are still many customers on tbase.
And as a matter of fact, in small environments tbase performs fine and it is the most stable backend for baan, requiring hardly any maintenance and thus not only saving on license fees but also on the cost of hiring someone with sufficient DBA skills.

Now the benefit I see in supporting a linux/MySQL environment is that it allows baan professionals to run a simple baan environment at home. This would do wonders for the (re-)adaptation of baan as a major player in the ERP field as creativity and innovation will be boosted by the user base.

Unfortunately we all know how Infor/SSA feels about sharing their precious licenses and oh so secret sources.

The real challenge with MySQL is MySQL itself. The current implementation is not ready to serve more than 50 users. If MySQL solves the outstanding issues I believe that it can become much more mature.

Kind regards,
Dick

we have less than 50 users. so any way i can use MySQL for Baan IV?

we have less than 50 users. so any way i can use MySQL for Baan IV?

No. The MySQL driver is only (limited) available for ERP LN.

No. The MySQL driver is only (limited) available for ERP LN.

ok... how is the mysql performance compare to other DB... cause i see under mysql exterprise support require an annual maintenance support....