We are in need of developing a SSMS add-in for SQL Server 2012, 2008/R2, and 2005. The add-in will show a form on the right to allow connecting to our web app to submit object details about the table/view or query. The form will validate the request, present an optional popup, so connection details and object details can be adjusted / reviewed / confirmed, and it will make request to web app. The dialog will also show the results from the web app. The results can be viewed in a grid and/or shared via email. clipboard. There will be a 'share' menu item.
The add-in will also have a settings box for entering web app credentials (which will validated in a secure way). There will be a way to calling the web-app, by optionally passing parameters and downloading data from the web app and displaying on the grid. We will try to add a new folder (below the standard SQL menu Tables/Views/Synonyms/..../Security) with a list of nodes obtained from the web app, with the option to view the data when right-clicked upon and also store the results to a table. A button will be placed on the toolbar as well.
The add-in will have an event log file showing all the communication between web app, activity will also be posted to windows event, a check for update functionality needs to be implemented. The add-in needs an installer and uninstaller. We will implement a basic help system afterwards.
The tool will also be able to download a log file from the web app, showing activity and usage, and display on the grid.
Ideally, you know how to call RESTful API, pass HTTP headers, are familiar w/ JSON data. This will help greatly while doing the project. The add-in is actually connecting to submit details about the selected table/view/query, and will receive a response from our server. There will be a way to call our server to fetch data and view it inside our SSMS add-in form.