Find Jobs
Hire Freelancers

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

$30-250 USD

Completed
Posted almost 5 years ago

$30-250 USD

Paid on delivery
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
Project ID: 19287129

About the project

4 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
hi Daniela as we discussed in other chat. thanks Girish ....................................... ..................
$250 USD in 2 days
5.0 (272 reviews)
8.2
8.2
4 freelancers are bidding on average $204 USD for this job
User Avatar
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.0 (0 reviews)
0.0
0.0

About the client

Flag of ROMANIA
sat Darvari, com. Ciorogarla, Romania
5.0
3
Payment method verified
Member since Jul 30, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.