we need a windows app(works both in system tray and as a windows service) performs defined sql queries according their schedulet time . This app will output the query result into different file format such as ,Excel,PDF, Jpeg or text .
App needs configurations (for defining Databases, Companies, Queries and Tasks) which will record to a cloud backend system with restapi (simple CRUD ) for each configuration with using predefined user.
It should also be connected to a websocket. and listens for instant messages so will perform the defined queries but giving privilege to asked over websocket rather than tech scheduled ones.
Query Results will be stored on local folder on the computer and will be uploaded to s3 bucket with the predefined folder which will backend api informs.
And it should have windows installer for non-technical guy to install on a windows environment.
All the configuration(Company, DBs, Queries,Tasks) files should be saved in a config file to future retouching.
It should support to connect all SQLServers and Oracle databases and should be stable working on windows /windows server platforms.
9 freelancer chào giá trung bình$654 cho công việc này
Hi I think you want to make C# app similar as Navicate This job is possible for me I hope to discuss with you about this job I already get idea how to complete this job Thanks