Fermé

database synchronisation over port 80

Synchronisation of 2 or more servers through webservices based on Soap.

The merces server is usually on a central server on the web.

The local systems communicate with the server through SOAP port 80 or 443

For offline purposes we need a local server, that synchronizes with the central server.

This synchronisation must be customizable and work in both directions for in-serts, updates and deletes or mark as deleted.

Following issues have to be mentioned:

Tablelist with all needed parameters

Event triggered or scheduled execution

Abstraction of the structures: building sql-statements automatically from ta-bledefs

Key constraints: how to prevent them?

Delta synchronization: timestamp/flag criteria

Security: authentication before execution

Load: packages of data for big tables.

Protokoll: SOAP, JSON, others?

The list of tables contains all common tables of the involved databases (about 150 tables).

The datamodel of the involved databases is congruent.

There are no key restrictions to observe

The sql statements are build automatically with tablename, fieldlist observing excluded fields, wherecondition

There is a configuration table with all tables and all needed information

The conditions are stored in a table like this:

tablename

fieldlist (read from tabledef?)

fields_excluded

direction: 1>2, 1<2, 1<>2

triggers: timestamp, recordcount,

whereCondition

Type: insert before update, update before insert, only insert, only update

LastRun

Compétences : Industrie Manufacturière, Design de produits, Approvisionnement de Produits, Sourcing Fournisseur

Voir plus : database port, type of data structures, mark fields, list of data structures, list in data structures, list data structures, execution table, data structures through c, data structures list, common data structures, about data structures in c, about data structures, list of web servers, timestamp, ta, port, observe, database security, database building 2, build database sql, json insert sql, web configuration database table, insert json sql server, big databases, authentication needed

Concernant l'employeur :
( 1 commentaire ) Teufen, Switzerland

N° du projet : #1657336

1 freelance a fait une offre moyenne de 1500 $ pour ce travail

khangmartin

This can be done by our team in Atlanta, Georgia. We would need to set the test environment and then fullfill your requirement 5 - 8 hour working days. Synergy Technology Group.

1500 $ USD en 5 jours
(0 Commentaires)
0.0