Db Sync Oracle to SQLlite

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