Developing a C# windows Service that can communicate to an ODBC Data Source
and Run Multiple SQL Statements against the DATABASE.
the List of Quires is stored in an external Txt File. one SQL Statment Per Line.
the program can extract the data from the ODBC connection and store them in CSV File (one CSV File Per query ).
the program can after that has the ability to upload the CSV files to the Microsoft Sharepoint folder online.
the Conditions for this project:
1- The process of extracting the CSV Files and Uploading them should be secure and Robust.
2- if the process failed there should be a guarantee automatic mechanism to retry the process until it a success ( 10 times for example before giving an error message inside a log file )
3- the Query and Uploading Process should have a timer that can happen one or more times (at a certain time or interval time per day)
4- the developer should add comments for His/Her Code and also provide documentation about how to use and install the service
5- the Developer should delivery the Source Code
7- there should be setting File outside the source code for Defining SQL quires, SharePoint user/pass/folder, ODBC Name
6- after testing the program ( maximum 2 days ) and if everything is fine we will pay the fee for this project.
21 freelancers are bidding on average $219 for this job
The program will be written in C# and run as a Windows service. It will read the settings from a settings file and run as described. The quote assumes I will have access to the server via TeamViewer to install and test
Hi, I can create a service in .net core so that you would be able to host it anywhere you want. On prem or at cloud. Windows or linux. I am sure it would be in best time frame and budget. Lets talk. Cheers, Afnan