We are proud to announce SaveToDB 8.

We have made SaveToDB 8 more productive for database developers and more powerful for business users.

New highlighted features include:

  1. Editing tables with foreign keys
  2. Editing data from views and stored procedures
  3. Editing tables with many-to-many relations
  4. Checkbox fields
  5. Application Installer
  6. Application Workbook Maker
  7. Planning Application for SQL Server
  8. Change Tracking Framework for SQL Server
  9. Permission Management Application for SQL Server
  10. Simplified SaveToDB Framework
  11. Improved user interface
  12. SQL query logging

You may find details below.

 

Also, if you do not download these free e-books yet, take a look. You will learn about cool SaveToDB 7 features.

Editing Tables with Foreign Keys

For example, a database contains the following tables:

Cash Flow Application Database Diagram

When you connect to the Payments table in Excel, you get a ready-to-use editable table:

Cash Flow Application Table in Excel

You may do the same with SaveToDB 7. However, this requires three lines of configuration.

 

Editing Data from Views and Stored procedures

For example, a database contains the following procedure that selects data from the Payments table:

CREATE PROCEDURE [cf80].[uspPayments]
    @AccountID int = NULL
    , @CompanyID int = NULL
    , @ItemID int = NULL
AS
BEGIN
 
SET NOCOUNT ON

SELECT
    *
FROM
    cf80.Payments p
WHERE
    COALESCE(@AccountID, p.AccountID, -1) = COALESCE(p.AccountID, -1)
    AND COALESCE(@CompanyID, p.CompanyID, -1) = COALESCE(p.CompanyID, -1)
    AND COALESCE(@ItemID, p.ItemID, -1) = COALESCE(p.ItemID, -1)

END

When you connect to this procedure in Excel, you get the same table as for source Payments table!

Cash Flow Application Table in Excel

SaveToDB 8 analyzes views and stored procedures and creates the configuration automatically.

Grant the VIEW DEFINITION permission on the desired views and procedures to enable this feature.

You may get the same result with SaveToDB 7. However, this requires six lines of configuration.

Editing Tables with Many-to-Many Relations

For example, a database contains the following tables:

Example Diagram of Many-to-many Relations

We may add the _State_ column to the connected EmployeesTerritories table and refresh data.

The add-in updates the _State_ column with 1 each refresh and deletes rows if you set 0 into this column.

Employees-Territories Table in Excel

Note also, the add-in uses names instead of identity values automatically.

So, we may create a pivot table:

Excel Pivot Table Used to Edit Many-to-many Relations

To assign a manager to the territory, set 1. To remove the assignment, set 0.

You may use the Save button on the pivot worksheet.

You may get the same result with SaveToDB 7. However, this requires three procedures to save changes.

Checkbox Fields

SaveToDB 8 formats bit fields as checkboxes using conditional formatting:

Checkbox Columns in Excel

Also, you may format any range as checkboxes using a new Form Wizard button.

You may double-click on such cells to rotate values.

You may get the same result in SaveToDB 7. However, this requires several steps with conditional formatting.

Application Installer

SaveToDB 8 includes new Application Installer that replaced SaveToDB Framework Installer.

You may install, upgrade, and delete SaveToDB Frameworks and built-in applications:

SaveToDB Application Installer

This feature saves times for developers and allows getting hidden powerful features.

Early, you may do the same operations using SaveToDB 7 SDK.

Application Workbook Maker

SaveToDB 8 includes new Application Workbook Maker:

SaveToDB Application Workbook Maker

Business users may create workbooks specific for installed database applications.

We plan to extend this feature to allow loading workbook templates from a database.

So, companies may significantly improve the workbook template distribution process.

Planning Application for SQL Server

SaveToDB 8 includes Planning Application for Microsoft SQL Server.

You may install it using the Application Installer as shown above.

Business users may create workbooks using the Application Workbook Maker as shown above.

This is a ready-to-use application. It includes a lot of features of such applications like SAP BPC.

You may use it for free. Also, the commercial support is available.

You may download the e-book that shows all configuration and usage steps:

https://www.savetodb.com/planning-application.htm

You may use the application with SaveToDB 7. Just download it as a separate package.

The application requires the SaveToDB Enterprise edition.

Change Tracking Framework for SQL Server

SaveToDB 8 includes Change Tracking Framework for Microsoft SQL Server.

You may add change tracking features to a database and track changes using SSMS or Microsoft Excel.

Also, you may extend the Microsoft Excel context menu to allow business users to track and rollback changes.

You may install it using the Application Installer.

Administrators may create a workbook to configure features using the Application Workbook Maker.

You may download the e-book that shows all configuration and usage steps:

https://www.savetodb.com/change-tracking-framework.htm

You may use the framework with SaveToDB 7. Just download it as a separate package.

Permission Management Application for SQL Server

SaveToDB 8 includes Permission Management Application for Microsoft SQL Server.

This application is designed for business users to allow editing permissions using Microsoft Excel.

You may create a workbook to configure features using the Application Workbook Maker.

You may use this with SaveToDB 7. Select SQL Server Management objects in the Data Connection Wizard.

Simplified SaveToDB Framework

SaveToDB Framework 8 includes only four tables and one view:

  • xls.objects
  • xls.handlers
  • xls.translations
  • xls.formats
  • xls.queries

Moreover, it has the same names and structures for all database platforms.

Improved User Interface

SaveToDB Ribbon in Excel

SaveToDB 8 includes improved UI including element labels. The ribbon tab has the Database name by default.

 

SQL Query Logging

SaveToDB 8 allows logging SQL queries:

Logging SQL Queries in Excel

Application developers may use this to debug event handlers easily.

 

Conclusion

SaveToDB 8 brings new features that make the job more productive.

You may solve typical tasks with zero configurations.

For example, you may use Microsoft Excel as a master data editor for a lot of tables, from-the-box.

Also, you may install and start using built-in ready-to-use applications and frameworks in a minute.

 

You may download SaveToDB 8 here:

https://www.savetodb.com/download.htm

 

Feel free to contact us at and .