DB RTD Connection Wizard

The SaveToDB add-in ships a companion product, DB RTD.

DB RTD allows getting data from database tables and views using Excel RTD formulas like

=RTD("db.rtd",,"sqlexpress","dbo.quotes","Symbol","AAPL","Close")

=RTD("db.rtd",,"sqlexpress","dbo.historical_prices","Symbol","AAPL","Date",TODAY(),"Close")

You can use DB RTD as an alternative to creating multiple pivot tables or linking table data using Excel formulas.

For example, you can load anonymous data from online systems and add customer data from on-premise systems.

Moreover, your users can get access in the office only according to their permissions.

See more details in the DB RTD help.

This wizard helps to create DB RTD formulas.

The wizard has five steps:

1. Selecting a provider
2. Connecting to a database
3. Selecting a source object
4. Selecting fields and aggregates
5. Inserting a table

Then you can use created formulas as you need.

Step 1. Selecting Provider

Select the desired data provider as described in the Database Connections topic.

Step 2. Connecting to Database

Connect to a database as described in the Database Connections topic.

Step 3. Selecting Source Object

Select a source table or view.

Here is a sample screenshot:

Step 4. Selecting Fields and Aggregates

Select fields to get aggregated values in the leftmost column S and the fields used keys in the rightmost column W.

Here is a sample:

Step 5. Inserting Table

Paste a table into a worksheet. In a couple of seconds, you will get results.

Here is a sample table: