MySQL and Business Objects Enterprise - do u use it?

[bessebo]

If MySQL is the database that ships with Business Objects XI Release 2 I am wondering what most people do here. Do you purchase SQLServer separately for the system database or do you use MySQL? I've never used it and am certified on SQLServer.

Thanks,
Bessebo

 

[Turkbear]

Hi,
We use MySql for our small scale development/test environment but Oracle is our 'real' CMS database...

We like having the CMS totally separate from the BOE server machine(s) and, since Oracle is our enterprise-wide standard database, we can take full advantage of our backup/archiving system.








To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[MJRBIM]

How big is your installation of BOE-XI (R2) going to be..?

Do you need back-up or fail-over for your CMS database...?

We have an 8-processor BOE-XI (R2) cluster - and use an external ORACLE 9i server for both the CMS and AUDIT databases.

 

[bessebo]

Not sure what you mean by how big is your installation? Crystal Enterprise 9 (our current environment) satisfies the needs of our company and external salespeople and a couple of West Coast divisions.

 

[MJRBIM]

Number of servers/processors...? Number of concurrent/named users...?

 

[bdreed35]

You should think about how quickly you need your system back in the event of a server failure or a disaster.
If you use Oracle or SQL Server, you would have the tools to perform backups and be able to get the system back up in a short amount of time. Think about how much time it would take to recreate the system from scratch (republishing reports, creating users and folders, configuring, etc).

Also, if you have a large number of reports and users, SQL Server or Oracle would be better equiped to handle the volumne of transactions that my occur.

~Brian

 

[synapsevampire]

You can point it to SQL Server, so go with what you know.

You don't want to hear my horror stories of people trying to implement MYSQL in various applications in the past, it just isn't ready for primetime, but since it's a free database, BO must be passing those savings along to...

Sorry, couldn't keep that going and hold a straight face

-k

 

[bessebo]

Thanks all for the information. I will be using SQLServer.

Regards,
Bessebo