Closed

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

Skills: Android, Java, Oracle, SQL, SQLite

See more: android sync sqlite with mysql, sqlite oracle connection, sqlite-sync tutorial, sqlite sync github, sqlite database synchronization, oracle database mobile server, sqlite replication synchronization, sqlite-sync xamarin, WPF Windows App + (Local MySQL DB + Sync Proc, iphone db sync, virtuemart multiple product changes, oracle sql days week, aspnet event calendar multiple days, multiple oracle login firefox, answers multiple choice oracle 10g

About the Employer:
( 2 reviews ) Blairgowrie, South Africa

Project ID: #17034143

6 freelancers are bidding on average R4074 for this job

R5000 ZAR in 7 days
(144 Reviews)
7.5
anuragiitk

I am an IITK graduate and I have 11 years of experience in software development. I have 100% completion rate and I have finished projects with the highest level of customer satisfaction. I have a team of rock star dev More

R3888 ZAR in 10 days
(22 Reviews)
5.4
bhavnadixit07

Hello , I am an android developer and I have more than 4 years of experience in android . I have completed more than 30 apps successfully . I have worked on features like Google map plotting, location tracki More

R2222 ZAR in 7 days
(4 Reviews)
1.7
R3888 ZAR in 1 day
(1 Review)
0.9
R5555 ZAR in 3 days
(0 Reviews)
0.0
sudhirchhag

Hi, Trust you are doing good. I understand your requirements for DB Sync to SQLite Our Expertise: [login to view URL] SDK, Versions, API level [login to view URL] component like Activity, Services, Content Provider, Broadcast R More

R3888 ZAR in 10 days
(0 Reviews)
0.0