Offline reporting requirements

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
andre
Posts: 3
Joined: Mon May 15, 2006 11:01 pm
Location: South Africa

Offline reporting requirements

Post by andre »

Scenario

Application run on AwareIM Server. User enters and edits data online. To view reports he/she will have a local copy of e.g. MYSQL.

1. Will it be possible to setup a data replication process within Aware that populate a subset of data (based on a filter) in the offline version of MYSQL on the user's laptop? This is necessary for reporting areas of no connectivity.

2. Any licensing requirements for this?

3. If a fully functional copy is necessary on both the server and the laptop, is my assumption correct that you need the server to run on both machines (with 2 x runtime licences). How will AwareIM synchronise the data?

4. Can you integrate e.g. Crystal reporting into AwareIM apps?

5. Any plans of integrating OMR Scanning (e.g. checkbox surveys) and bar-coding solutions in the future

Appreciate your answers (not to clear in the documentation)

Andre
aware_support2
Posts: 595
Joined: Sun Apr 24, 2005 2:22 am
Contact:

Post by aware_support2 »

Andre,

> 1. Will it be possible to setup a data replication process within Aware that populate a subset of data (based on a filter) in the offline version of MYSQL on the user's laptop? This is necessary for reporting areas of no connectivity.
The short answer is yes. This can be done by configuring an Aware IM process that uses Web Services as a communication channel between two Aware IM systems. One would be running on the central server and the other on a laptop. The process will control filtering, synchronization and other data transfer issues. Depending on the amount of transferred data a more efficient channel may be desirable. Such a channel can be built and plugged into Aware IM. We provide development services for building custom channels.

> 2. Any licensing requirements for this?
If you purchase the Professional Edition for use within your organization, then each holder of the named user license can install a single-user version on his/her laptop. Certain number of the named user licenses is included with the Professional Edition of Aware IM. Additional named user licenses can be purchased separately. If you distribute your applications to your clients using Aware IM Runtime then a separate Aware IM Runtime license would be required for each installation of Aware IM, whether on the central server or a laptop. Please refer to Aware IM licensing page for more details.

> 3. If a fully functional copy is necessary on both the server and the laptop, is my assumption correct that you need the server to run on both machines (with 2 x runtime licences). How will AwareIM synchronise the data?
Please see the answers to #1 and #2.

> 4. Can you integrate e.g. Crystal reporting into AwareIM apps?
Since Aware IM uses a standard SQL database you should be able to use it as a data source for report engines that work with SQL databases.

> 5. Any plans of integrating OMR Scanning (e.g. checkbox surveys) and bar-coding solutions in the future
Support of special software/hardware can be added to Aware IM as custom plug-ins written in Java. Aware IM comes with documentation on building plug-ins including the necessary APIs. We also provide development services for building custom plug-ins.
Aware IM Support Team
andre
Posts: 3
Joined: Mon May 15, 2006 11:01 pm
Location: South Africa

Post by andre »

Thanks for the reply

Regarding question 1 - maybe I did not express myself correctly

The Laptop user wil not run the AwareIM application on the Laptop. The Laptop wil only contain a SQL DB with e.g. Crystal reporting running on it for reporting. So the question is actually can you replicate data (using web services) from a DB running under Aware to a DB only (without the Aware Server). Or must you use a MySQL replication services between the two DB's - without using AwareIM?

Thanks
aware_support2
Posts: 595
Joined: Sun Apr 24, 2005 2:22 am
Contact:

Post by aware_support2 »

Andre,

Aware IM is designed to run web applications, including the storage of application data in a database. Pure replication of data in a database is not a part of Aware IM functionality. You would have to use a third party tool for that.
Aware IM Support Team
Post Reply