Page Comparison

The data integration feature in WSO2 EI supports data federation, which means that a single data service can expose data from multiple datasources. However, if you have multiple RDBMSs connected to your data service, and if you need to perform IN-ONLY operations (operations that can insert data and modify data in the datasource) in a coordinated manner, the RDBMSs need to be defined as XA datasources. Consider a scenario where you have two MySQL databases. You can define a single data service for these databases and insert data into both as explained below.

...

1. Log into the management console of WSO2 EI and click Create under Data Service.
2. Add a name for the data service and go to the next step.
3. Select the Enable Boxcarring and the Disable Legacy Boxcarring Mode check boxesbox.
4. Click Next to go to the Datasources screen.
5. Create a datasource connection for the CompanyDetails database follows:
   1. Enter XAoffices as the datasource ID.
   2. Select RDBMS as the datasource type.
   3. Select External Datasource from the adjoining field.
   4. Select MySQL as the database engine.
   5. Enter the following database class corresponding to MySQL: com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
      
   6. Click Add Properties and create the connection settings for the OfficeDetails database.
      URL: jdbc:mysql://localhost:3306/OfficeDetails
      USER: root
   
6. Save the XAoffices datasource.
7. Create a datasource connection for the EmployeeDetails database as follows:
   1. Enter XAemployees as the datasource ID.
   2. Select RDBMS as the datasource type.
   3. Select External Datasource from the adjoining field.
   4. Select MySQL as the database engine.
   5. Enter the following database class corresponding to MySQL: com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
      
   6. Click Add Properties and create the connection settings for the OfficeDetails database.
      URL: jdbc:mysql://localhost:3306/EmployeeDetails
      USER: root
   
8. Save the XAemployees datasource.

...