We have a requirement to have offline capability on an android client.
As a start I would like to test out the SYMETRIC-DS framework ( Or other to see how they manage two way synchronization of data between the Android Client and the Oracle Server.
Goal
1. Synchronize the PROD_INST table between ORA and SQLlite
2. The PROD_INST table contains all SERIAL NUMBERS, however the SQLlite should only contain those SERIALS for that agent
Below are the fields for the PROD_INST table
Name Null Type
--------------- -------- -------------
ID NOT NULL NUMBER(20)
SUPPLIER_ID NOT NULL NUMBER(20)
PROD_ID NOT NULL NUMBER(20)
SERIAL_CODE NOT NULL VARCHAR2(100)
COST_PRICE NOT NULL NUMBER(20,4)
COMPANY_ID NUMBER(20)
SITES_ID NUMBER(20)
AGENT_ID NUMBER(20)
LOADED_DATE DATE
EXPIRY_DATE DATE
STATUS NOT NULL VARCHAR2(100)
ELOADED_DATE DATE
ACTIVATION_DATE DATE
PORTED_DATE DATE
TOT_REV NUMBER(20,6)
TOT_COMM NUMBER(20,6)
MSISDN VARCHAR2(20)
LAST_TX_DATE DATE
BOX_ID NUMBER(20)
RECYCLED_DATE DATE
The client would contain a subset of that data under his agent_id
i.e. we would only sync the stock that is listed under his/her agent_id
select * from prod_inst where agent_id = ?
Deliverable
1. Demonstrate a SQLlite database inside an Android App
that is able to bidirectionally synchronize changes in the PROD_INST table
2. The SQLlite database will only have a subset of data for that AGENT_ID
3. You should show it working with multiple agents and demonstrate that the there is a 2 way sync
A possible Frame works has been identified
[login to view URL]
You are free to choose any framework that is suitable. Ideally The framework should be open source OR; cheap enough that we can consider it
Expected Delivery Dates
1. We will prepare a database that just has PROD_INST table in, along with a backup of the table PROD_INST_TMP you can use to refresh the database
2. We would like a working demo in a few days