Installing MDM Workflow with Microsoft SQL Server
Overview
MDM Workflow requires XA transactions enabled with Microsoft SQL Server. However, there is a known issue between Bitronix, the Transaction Manager shipped by Bonitasoft for the Tomcat bundle and inside Deploy bundle for Tomcat, and Microsoft SQL Server driver. For more information, see Understanding XA Transactions.
To solve this problem, you need to install MDM Workflow using the JBoss bundle provided by Talend. Contact Talend Support to receive the JBoss bundle.
Prerequisites
- MDM Workflow Server requires MS SQL Server to use UTF8 and case insensitive charset.
- JBoss Bundle 7.1.1 will only works with Java JDK 7. Install a JDK 7 and configure the JAVA_HOME for the JBoss Bundle appropriately.
- Only Microsoft SQL Server 2012 R2 is supported by Bonitasoft 6.5. For more information, see Hardware and software requirements.
Clearing the MDM Workflow Server installation in the Talend installer
Procedure
Configuring Microsoft SQL Server For XA Transactions
This section explains how to install XA Transaction.
MDM Workflow Server (Bonitasoft) uses XA Transactions when working with Microsoft SQL Server. For more information, see Understanding XA Transactions.