Bridge program/script between MS SQL database and iOS app

Cancelled Posted Mar 1, 2015 Paid on delivery
Cancelled Paid on delivery

We are looking to have a bridge program developed to pass data back and forth between our MS SQL database and a third part iOS app.

On one side we have our MS SQL database. On the other we have a third party iOS device which will scan barcodes. The iOS device will be using Direct Scan to URL (DSU). By doing this it will POST scan data directly to the URL and it will be using our LAN as the URL (it will not be going out to the web).

We will have several mobile devices scanning at the same time and will need the local database server to instantly validate and report back to each device. This needs to be optimized for high volume simultaneous requests back to the database server.

Flow:

Barcode is scanned in the iOS device and the iOS software will send the variables via HTTP POST to the database server

A program (or other means) on the database server (running Windows 7) will receive the request and check it against the tables (about 6 tables) to see if the scanned number is valid. If it's valid it would update the database.

It will then send an xml response back to the iOS app.

The project requires a program to catch the HTTP POST data, pass it along and validate on the SQL database, update the database and then return a result back to the iOS app.

I can furnish more details on the iOS api and the database flow upon request. I would rather not create a stored procedure within the database for this bridge and have it run as a small program if possible.

.NET Microsoft SQL Server Software Architecture

Project ID: #7229206

About the project

3 proposals Remote project Active Mar 5, 2015

3 freelancers are bidding on average $361 for this job

mteodoro

Hi. I can do that. I will create a web service to handle that. Install it on your web server, probably the same or not... I would need that you tell me what tables and columns should be used for validation and p More

$277 USD in 3 days
(9 Reviews)
4.9
murtaza1981

Hi, An ASP.NET,c#,vb ,SqlServer,JQuery,Javascript expert here. Please feel free to discuss the project with me. Thanks, Murtaza

$250 USD in 3 days
(12 Reviews)
4.7
johnbenz

Dear Sir, I am a Professional Programmer since 2008, I have many programs developed and successfully finished in my past employer, I am expert in IT Industry both Hardware and Software Programming, I will give you t More

$750 USD in 10 days
(9 Reviews)
4.4
shtafun

Dear Client, My name is Alexander. I have 12+ years experience in programming. I can start this project immediately, I am free now. I can make this program using Entity Framework and Self-Host ASP.NET Web API 2 More

$555 USD in 10 days
(4 Reviews)
3.6