Db Sync Oracle to SQLlite

Закрито Опубліковано %project.relative_time Оплачується при отриманні
Закрито Оплачується при отриманні

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

Android Java Oracle SQL SQLite

ID Проекту: #17034143

Про проект

6 заявок(-ки) Дистанційний проект Остання активність 5 роки(ів) тому