The SaveToDB plug-in allows you to use Microsoft Excel as a SQL Server client, Windows Azure SQL Azure, SQL Server Compact, Oracle Database, IBM DB2, MySQL. Also, the plugin allows you to download data from the web and text files, and save the data to a database. Using Microsoft Excel as a client gives the following benefits:
- User-friendly interface.
- Use of ready and powerful functionality Excel from the beginning of the project.
- Involvement of users in the prototyping of the final system.
- Reducing the costs of training and user support.
- Reducing the time and cost of development.
- Reducing project risks.
The SaveToDB plug-in already provides the entire infrastructure for bi-directional data exchange, report management and their parameters. Interface design and configuration is performed on the server side through views and stored procedures. Capabilities: SaveToDB adds the following key features to Microsoft Excel:
- Switching requests to the server from the list of requests on the tape.
- Change the settings for running stored procedures on the tape.
- Translation on the fly to the "business language" of the names of database objects and object fields.
- Save and restore formula columns and conditional formatting when changing queries.
- Saving the Excel changes to flat DB tables out of the box.
- Saving changes Excel to normalized database tables by using stored procedures.
- Handling change events in cells and Double-Click server procedures.
- Contextual database queries from the context menu.
- Run macros from the context menu with context options.
In fact, SaveToDB already provides a complete stack of solutions for implementing applications with the capabilities that users expect from desktop applications. The distribution includes applications and examples. You can start work or project very quickly.