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


- 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.


- 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

Квалификация: .NET, ASP.NET, Программирование на C#, SQL-сервер Microsoft

Показать больше 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

О работодателе:
( 3 отзыв(-а, -ов) ) sat Darvari, com. Ciorogarla, Romania

ID проекта: #19287129



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

$250 USD за 2 дней(-я)
(272 отзывов(-а))

4 фрилансеров(-а) в среднем готовы выполнить эту работу за $204


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 Больше

$211 USD за 3 дней(-я)
(2 отзывов(-а))

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 Больше

$200 USD за 5 дней(-я)
(0 отзывов(-а))

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 за 3 дней(-я)
(0 отзывов(-а))