Completed

Interface / Job for synchronization of items between to system (webservers at both ends)

Summary:

- An interface is needed between an ERP System and a Product Management System (PMS) regarding synchronizing items.

- The interface should be in form of a Web API built for Microsoft IIS 7.0 (HTTP based interface).

- The language behind the web API should be C#. Project will be in Microsoft Visual Studio or compatible environment.

- Data will be extracted from a PMS webserver and will be put on a local network SQL Server (in the same network, but on a different machine in the deployment environment). SQL Server name, schema and credentials used for accessing the SQL Server should be parameterized (saved in configuration files).

- The data received from PMS webserver will be received in XML format. The data will be parsed by the interface and will be saved in special tables on the SQL Server side and a store procedure will be called for processing imported data within the SQL Server database.

- Additionally, the interface requires a programmable job (initially it will be on a half hour schedule), that extracts data from PMS webserver and put the data in local network SQL Server. This automatically connection will ask only for the items that were modified since the previous day.

- The synchronization interface will have to log operations in a log file (only the main steps: invoke method / automatically fire the job, connection to PMS server success / fail, connection to the SQL Server success / fail, ending the job). The log for the automation job can be different from the log for manually invoking methods, that is not a problem. The request is for having a log for each attempt of synchronization.

- The volume of items synchronized can be very large at some points, so the interface should process the load quickly enough. We can provide test files with around 10000 items, in order to check that the interface is optimized.

- The stored procedures will be created by us, thus will not be covered by the current project.

- For calling PMS webserver we can provide a VS .NET test project in C# with connection method and authentication data, with examples for calling for synchronizing one item or for calling to receive the items that were modified since a number of days.

Deliverables:

- The Web API interface installed on a test environment and instruction for installing on the go-live environment

- The programmable job / service for files synchronization installed on a test environment and instruction for installing on the go-live environment

- The code / project solution

- 1 month post-deployment free service if needed

Skills: .NET, ASP.NET, C# Programming, Microsoft SQL Server

See more: executive summary job board marketing plan, job listing items ebay, post items ebay job, how to keep two database in sync, synchronize sql server databases in different remote sources, mysql sync tables between databases, synchronization between two sql server database, how to sync 2 databases after every write operation, django sync two databases, sql server sync tables between databases, data synchronization between two databases, executive summary sample job, write quick job summary graphic designer, job translation interface, list items ebay job, oracle application customer interface job log, paid job listing items ebay, quartz job user interface, quickbooks import job items, quartz job scheduler web interface

About the Employer:
( 3 reviews ) sat Darvari, com. Ciorogarla, Romania

Project ID: #19287129

Awarded to:

giviniinternet

hi Daniela as we discussed in other chat. thanks Girish ....................................... ..................

$250 USD in 2 days
(272 Reviews)
8.2

4 freelancers are bidding on average $204 for this job

poojavachhani

Hello, Pooja here from Techie IT [login to view URL] have 20+ Team experts with Mobile App Development(iOS and Android) and Web Design and development with and Unique logo [login to view URL] have helped our clients achieve their g More

$211 USD in 3 days
(2 Reviews)
0.5
fastwebsoft

Hello Sir, I have great knowledge in core,cordignetor and Laravel. More than 6+ year experience.. I have read your requirement carefully.. I can do this job easily.. 1. What will be the payment gateway More

$200 USD in 5 days
(0 Reviews)
0.0
pandeysindhu23

Hi I am ready to start work if you give me chance , i am having about 15 years of experience in .net Thanks

$155 USD in 3 days
(0 Reviews)
0.0