Getting Started with DB.RTD

Getting Started with DB.RTD

DB.RTD allows creating refreshable reports and models, for business and trading, based on database data in Microsoft Excel in an easy way.

Suppose, we have two database tables, or views, like weblogs:

and downloads:

We want to create a simple dashboard to monitor visitors and downloads:

To solve this task using native Excel features, we have to create:

  1. A pivot table for pages and months from dbo.weblogs;
  2. A pivot table for pages and weeks from dbo.weblogs;
  3. A pivot table for files and months from dbo.downloads;
  4. A pivot table for files and weeks from dbo.downloads.

So, the target dashboard table will contain four types of formulas.

Moreover, if we want to refresh data periodically, we have to record a macro to refresh tables and call the macro on timer events.

DB.RTD has a simple and elegant solution.

Just use the RTD formula to get and refresh database data like this:

=RTD("db.rtd",,"sqlexpress","test3.dbo.downloads","file","dbrtd.zip","week","4/23/2017","count(id)")

For example, the target table may look like this:

All formulas in the table are regular and have the same structure.

So, you may get refreshable data from any database and any table, with any supported aggregate formula like count, max or min.

As a result, you may create reports and models with fewer efforts, in less time, and with clear structures.

Start learning with the Using DB.RTD topic.

DB.RTD requires registration to start a trial. See the Product Registration topic for details.