[Enterprise Plone] Using SQL Server [UNCLASSIFIED]
John Spence
We are looking at using SQL Server for the relational hierarchical table we use to drive some dynamic content. I am interested to know if anyone else has done this and/or if there are any issues with using SQL Server. I understand that we may need to use the ODBC driver to do this.
www.govt.nz - your guide to finding and using New Zealand government services
Any opinions expressed in this message are not necessarily those of the Ministry of Business, Innovation and Employment. This message and any files transmitted with it are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivery to the intended recipient, be advised that you have received this message in error and that any use is strictly prohibited. Please contact the sender and delete the message and any attachment from your computer.
Nathan Van Gheem
You should look at sqlalchemy integration--you can use the pyodbc or pymssql package with it: http://docs.sqlalchemy.org/en/rel_1_0/core/engines.html#microsoft-sql-server
I've also even routed django objects with postgresql through Plone. Django can also work with sql server.
Any specifics on how you want the integration to work?
_______________________________________________
Enterprise mailing list
Enter...@lists.plone.org
https://lists.plone.org/mailman/listinfo/plone-enterprise
John Spence
Thanks for your response nice to know that there is others using SQL Server with Plone.
We will be using a set of questions up to 3 that determine the items that will be displayed in a table. The answers to the questions and the determination of the items to be displayed as a result use a fairly complex data model. The data model will be stored in SQL Server and content in the ZEO database, we will be using ZRS to replicate for DR purposes. The SQL server is already configured for replication. We are at an early development stage so have no more details than this re database integration.
We will be using Solr for searching I have no idea how this will integrate with both database types and how they are organised. Any suggestions would be welcome. As to why we are using the 2 database types it is difficult to explain other than it was mostly mandated.