We currently have two database applications which exchange data on a batched basis using another application. I know you can import and export to Aware using it's own method, is it possible for another application to write to the underlying table in a scheduled manner.
If you know what you are doing you can access Aware IM database tables directly bypassing Aware IM (there is one issue with Derby database here - if you want to do it with Derby you have to shutdown Aware IM first, because Derby allows only one application to connect to it).
Mapping between database table and column names and business objects/attributes is fairly straightforward - you can study SQL tab of a query in the Configuration Tool for hints. Let us know if you want more detailed info on this.
Another option is to let Aware IM do it - you can define a service in Aware IM that imports or exports the data. Aware IM will automatically create a SOAP-based web service that can be called by another application.