Hi Alex, I got a strange notification from the mailing list because the Peter Mac email filter ate your response, so I've had to copy your email in here rather than replying directly, sorry. > Maybe could you address the alternatives to components other > than just the database engine (eg Reporting Services, > Integration Services, Analysis Services, MDM, DQS). This is also a good topic: there are a few open source projects that I have looked at in more-or-less detail at different times. The ones that provide the most coverage are Pentaho and Jaspersoft, with Talend doing a lot of the data work too (eg. SSIS, MDM, DQS) but not so much of the reporting. Considering the broader platform is important in that there is not a lot of licence benefit in moving the database engine on its own if you still need SQL Server licences for SSRS, SSAS, SSIS and Sharepoint. However, from the perspective of gradually acclimatising your IT department to open source software, though, picking off something like the database engine might be best. A topic for March? Kind regards, William Rose Business Intelligence Manager Information Management +61 3 9656 5231 | Level 8, St Andrews Place, East Melbourne VIC 3002 <http://www.hisa.org.au/page/bigdata2013> ________________________________ From: chai-t-bounce@xxxxxxxxxxxxx [mailto:chai-t-bounce@xxxxxxxxxxxxx] On Behalf Of Rose William Sent: Thursday, 14 February 2013 1:42 PM To: chai-t@xxxxxxxxxxxxx Subject: [chai-t] Re: February meeting plans Hi Peter, I think this would be a good topic for a future meeting! I have not really come across people buying MySQL or PostgreSQL enterprise support, mostly because it seems to be people using them for non-critical systems or otherwise as part of an application where the application team manages the DBA work associated with the database. For instance, Business Objects comes bundled with MySQL and it can be used as the report and job repository, and they would support it if we ran into problems (I think). I set up a PostgreSQL server on Linux last year for an application for one of our research teams and developed some scripts to do automated backups, etc. I've done similar things for MySQL on Linux, but less on Windows. To me, there is no great advantage to the "enterprise support" aspect of software licensing for SQL Server / Windows Server: you still end up needing your own IT support people to be DBAs and system administrators, so why not teach them MySQL and PostgreSQL and Linux and pay nothing in licensing? Presumably there's a workforce aspect to consider and perhaps a familiarity aspect, but most of these environments include some kind of GUI development environment now anyway. I am happy to coordinate a session showing off some of the management tools and comparing and contrasting MySQL, PostgreSQL and SQL Server from a developer perspective. Given how closely most of us end up managing our own infrastructure, it probably doesn't matter whether that aligns to an enterprise standard as much. Kind regards, William Rose Business Intelligence Manager Information Management +61 3 9656 5231 | Level 8, St Andrews Place, East Melbourne VIC 3002 <http://www.hisa.org.au/page/bigdata2013> ________________________________ From: chai-t-bounce@xxxxxxxxxxxxx [mailto:chai-t-bounce@xxxxxxxxxxxxx] On Behalf Of DAVEY, Peter Sent: Thursday, 14 February 2013 10:34 AM To: chai-t@xxxxxxxxxxxxx Subject: [chai-t] Re: February meeting plans William, An idea perhaps for a discussion at a future meeting. Last week our IT people were telling us about the changes to MS licencing and SS 2012 in particular and it wasn't pretty. It led me to wonder about the feasibility of using MySQL or PostgreSQL in organisations like ours and how they could work in a BI environment. The Enterprise version of MySQL costs money but I haven't been able to find out much about the licencing details and PostgreSQL appears to be free. Does anybody know much about this area? Cheers Peter Davey | Manager Clinical Information Analysis & Reporting | Austin Health PO Box 5555 Heidelberg Vic 3084 ph. +61 3 9496 5517 | fax. +61 3 9496 5856 email. peter.davey@xxxxxxxxxxxxx | www.austin.org.au <http://www.austin.org.au/> From: chai-t-bounce@xxxxxxxxxxxxx [mailto:chai-t-bounce@xxxxxxxxxxxxx] On Behalf Of Rose William Sent: Wednesday, 13 February 2013 08:55 To: chai-t@xxxxxxxxxxxxx Subject: [chai-t] February meeting plans Hi all, I think most of you have been forwarded the invitation from Stefan Romiti at Microsoft to the event they are hosting on Thursday 21/02/2013 from 2:30 to 5pm, at their Southbank office. The topic is Tabular & PowerPivot - Analysis Services. We will not be meeting otherwise this month (e.g. not this Friday), so I hope to see you there next week! Kind regards, William Rose Business Intelligence Manager Information Management +61 3 9656 5231 | Level 8, St Andrews Place, East Melbourne VIC 3002 <http://www.hisa.org.au/page/bigdata2013> This email (including any attachments or links) may contain confidential and/or legally privileged information and is intended only to be read or used by the addressee. If you are not the intended addressee, any use, distribution, disclosure or copying of this email is strictly prohibited. Confidentiality and legal privilege attached to this email (including any attachments) are not waived or lost by reason of its mistaken delivery to you. If you have received this email in error, please delete it and notify us immediately by telephone or email. Peter MacCallum Cancer Centre provides no guarantee that this transmission is free of virus or that it has not been intercepted or altered and will not be liable for any delay in its receipt. <http://webmail.austin.org.au/2012-Health-Award-signature.gif> ***************************************************************** This email contains confidential information intended only for the person named above and may be subject to legal privilege and confidentiality obligations imposed by legislation or be subject to intellectual property protection or copyright. If you are not the intended recipient, any use, disclosure, copying or distribution of this transmission is prohibited. If you have received this message in error, please notify us immediately by return email and delete the original email and any attachments. Austin Health provides no guarantee that this transmission is free of virus or that it has not been intercepted or altered. ***************************************************************** This email (including any attachments or links) may contain confidential and/or legally privileged information and is intended only to be read or used by the addressee. If you are not the intended addressee, any use, distribution, disclosure or copying of this email is strictly prohibited. Confidentiality and legal privilege attached to this email (including any attachments) are not waived or lost by reason of its mistaken delivery to you. If you have received this email in error, please delete it and notify us immediately by telephone or email. Peter MacCallum Cancer Centre provides no guarantee that this transmission is free of virus or that it has not been intercepted or altered and will not be liable for any delay in its receipt. This email (including any attachments or links) may contain confidential and/or legally privileged information and is intended only to be read or used by the addressee. If you are not the intended addressee, any use, distribution, disclosure or copying of this email is strictly prohibited. Confidentiality and legal privilege attached to this email (including any attachments) are not waived or lost by reason of its mistaken delivery to you. If you have received this email in error, please delete it and notify us immediately by telephone or email. Peter MacCallum Cancer Centre provides no guarantee that this transmission is free of virus or that it has not been intercepted or altered and will not be liable for any delay in its receipt.