Hi, is it possible to access one odb file from different applications?
What we would like to accomplish. We have one app (runs on Wildlfy server) and it uses xyz.odb DB file. The other two apps would be for API and BI, one would need to read data from the xyz.odb and the other one would be for exposing the DB data via web services.
Do all these apps need to have the same DB schema. The BIRT addon connects to the odb file, could it be adapted to make queries to the database.
The customer would like to use our APP but he asks how the data from the DB can be used to fill its DWH and how can he integrate (since there is no JDBC or ODBC drivers) with other DB/systems (we have some Web Services within the APP but he would like to do some integration directly)
Does anybody have experience with this.