Đã hoàn thành

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

Kĩ năng: .NET, ASP.NET, Lập trình C#, Microsoft SQL Server

Xem nhiều hơn: 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

Về Bên Thuê:
( 3 nhận xét ) sat Darvari, com. Ciorogarla, Romania

ID dự án: #19287129

Được trao cho:

giviniinternet

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

$250 USD trong 2 ngày
(272 Đánh Giá)
8.2

4 freelancer đang chào giá trung bình $204 cho công việc này

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 Thêm

$211 USD trong 3 ngày
(2 Nhận xét)
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 Thêm

$200 USD trong 5 ngày
(0 Nhận xét)
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 trong 3 ngày
(0 Nhận xét)
0.0