Completed

.NET Interface between two systems, through several GET and SET methods and additionally, dropping CSV data on a FTP site

Summary:

- An interface is needed between an ERP System and a Product Management System.

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

- The request-response message system will be in a JSON / XML format.

- The server-side of the web API should expose several get and set methods.

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

- Data will be stored / extracted from a SQL Server (in the same local 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 for Web API GET methods will be extract from the SQL Server by calling an SQL Server stored procedure for each request.

- The data for Web API SET methods will be received from the Web API clients in JSON / 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 each type of 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 SQL Server by calling a stored procedure for each type of file, put each data set in a CSV file and drops the CSV files on a FTP location

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

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: net age systems, use net interface metatrader, dot net interface autocad, visual studio 2017 publish include extra files, how to fetch a file from ftp and import into sql server automatically, sql server ftp get file, visual studio 2017 publish include folder, visual studio publish include extra files, filesforpackagingfromproject, copyallfilestosinglefolderformsdeploydependson, amazon rds sql server import database, asp net interface, asp net interface basics, mt4 dot net interface, net interface metatrader, net web browser control set proxy password, sage erp vb net interface, sql database vb net interface project, vb net exam systems, vb net interface asterisk pbx

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

Project ID: #18848452

Awarded to:

giviniinternet

hi, As we discussed in other chat window on freelancer. I have 8+ year exp. in asp.net mvc web development and deployment thanks, Girish

$500 USD in 7 days
(270 Reviews)
8.2

3 freelancers are bidding on average $518 for this job

nitanandsingh

hi sir, i have gone through the job description and ready to start development immediately. i have proven experience in web api, aspnet mvc , csv creation and sql server. please provide me this opportunity. i will More

$555 USD in 10 days
(4 Reviews)
4.3
dedycatedinc

I have successfully delivered many projects in many different company and client. I have a strong Programming and Management skills and always updates myself with Research and Development of new technologies to strengt More

$500 USD in 14 days
(2 Reviews)
2.1