Database integration
Databases are a common integration middleware. Many existing integration scenarios are handled by exchanging data through database tables.
For example, third party reporting tools typically read directly from the application database, or from its datawarehouse.
In the other direction, third party application can directly insert data into the application database. The good practice is to input the data into staging tables and to use a batch process to integrate this data into the application tables.
SQL integration continues to be an option on-premise. Third party components and applications can read and write from the Sage X3 database.
SQL integration is not possible in the Online deployment of the SAFE X3 platform because third party applications and components cannot connect directly to the SQL database. Only application and reporting solutions that have been bundled with it can access this database.