Create an online database with updates fed by xml

This is a straight forward project to create an online customer database - that can be updated/parsed with feeds sent to it by XML feeds online in a secure manner.

The XML feed has two schema - but the fields are very similar


This can be secured by SSL and a password that comes while the XML feed is being sent out - so no bogus data goes to the database



There needs to be a admin console that controls the system

We need to add other users (admin) and non-admin - with passwords and username

We also need to control for each user - what details of a customer record they can access.

For example, with some employees, we may want to restrict access to phone number or even email records

We also want to log what a non-admin user is accessing, especially if its a high number of searches of the system.


All users may need to search for a customer's details - such as by order number, email or even zip code

This needs to be tight - as we want to restrict how many records come up as a security feature to prevent any copying/ harvassing of the data by any user, as data security is paramount


We need a way for users to enter sales that they have made - by marking an existing order on the system

We need to then be able to generate reports for each user during any interval in the admin console


We need to backup the data regularly and keep it clean, and other periodic maintenance

I have attached some documents that provide background of the XML and some suggestions on how it may work

Note, we already have existing system but we dont have the sales control or central monitoring on it, so a new system is required



Skills: Big Data, Database Administration, MySQL

See more: data backup, search work online, sales administration, online database work, online administration work, mysql search performance, mysql customer database, create log online, online mysql database, search console, email administration, database performance , create similar access, code new feature, backup database, customer details database, create zip code, generate code database record, xml schema access database, create access database reports, create add note, create schema mysql, mysql create schema, email data access 2013, log periodic

About the Employer:
( 283 reviews ) London, United Arab Emirates

Project ID: #4321118