Suljettu

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

Taidot: Android, Java, Oracle, SQL, SQLite

Näytä lisää: 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

Tietoa työnantajasta:
( 2 arvostelua ) Blairgowrie, South Africa

Projektin tunnus: #17034143

6 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

R5000 ZAR 7 päivässä
(144 arvostelua)
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 Lisää

R3888 ZAR 10 päivässä
(22 arvostelua)
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 Lisää

R2222 ZAR 7 päivässä
(4 arvostelua)
1.7
R3888 ZAR 1 päivässä
(1 arvostelu)
0.9
R5555 ZAR 3 päivässä
(0 arvostelua)
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 Lisää

R3888 ZAR 10 päivässä
(0 arvostelua)
0.0