DB.RTD

DB.RTD

Getting Started

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:

Dashboard source tables - weblogs

and downloads:

Dashboard source tables - downloads

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

Target dashboard

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:

Dashboard formula example

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.

What's New

Version 1.6, November 3, 2017

Bug fixes:

  • Registration wizard WebException in the offline mode

Version 1.5, August 22, 2017

Breaking changes:

  • Changed .NET platform from .NET Framework 4.0 Client Profile to .NET Framework 4.5.2.
  • Changes in requirements for Windows 7, Windows Server 2008, and Windows Server 2008 R2.
  • Removed support of Windows XP.
  • Removed support of SQL Server 2000.
  • Removed support of MySQL 5.0, 5.1, 5.2.
  • Removed support of MariaDB 5.1, 5.2, 5.3.

Improvements:

  • Updates examples

Bug Fixes:

  • Issues with registering products.

Version 1.4, August 1, 2017

New features:

  • Using SELECT statements as data sources.
    For example, you may place the following code to cell B1:
    SELECT o.CustomerID, d.Total FROM OrderDetails d, Orders o WHERE d.OrderID = o.OrderID
    And use the following formula:
    =RTD("db.rtd",,"sqlexpress",$B$1,"CustomerID",1,"SUM(Total)")
    See examples in the updated northwind.xlsx workbook.
    The code may contain up to 255 characters (Excel limit).
  • Azure Active Directory integrated authentication
  • Azure Active Directory password authentication

Version 1.3, July 5, 2017

Licensing changes:

  • The free edition allows getting data with 500 formulas (instead of 20).

New features:

  • Using connection strings in RTD formulas directly
  • SQLite support
  • Northwind example
  • Included .NET providers for Oracle Database, MySQL, PostgreSQL, NuoDB, Microsoft SQL Server Compact, and SQLite

Improvements:

  • Updated registration wizard
  • Updated installer
  • Using default schemas for MySQL and PostgreSQL
  • Improved SQL codes
  • Improved diagnostic messages

Version 1.2, May 31, 2017

Improvements:

  • Updated installer
  • Updated documentation

Version 1.1, May 11, 2017

Improvements:

  • Support of ODBC Driver 13 for SQL Server
  • Improved Spanish translation
  • Improved documentation

Version 1.0, May 1, 2017

The first release.

Edition Comparison

FeatureFreePersonalEnterprise
Number of unique formulas in all opened workbooks5005000Unlimited
One-time price per copy $49$99
Commercial usex

You may try all the features during a 15-day trial period.

Supported database platforms:

  • Microsoft SQL Server
  • Microsoft SQL Server Compact
  • Oracle Database
  • IBM DB2
  • MySQL and MariaDB
  • PostgreSQL
  • NuoDB
  • SQLite

Install and Uninstall

Installing

Close Microsoft Excel and run setup.exe.

Open Start Menu, All Programs, DB.RTD, Register Product to activate a trial.

Open Start Menu, All Programs, DB.RTD, gConnectionManager to edit connections in a visual mode.

Updating

Close Microsoft Excel and run setup.exe of a new version.

Uninstalling

To uninstall DB.RTD, open Control Panel, Programs and Features, then select DB.RTD and click the Uninstall button.

System Requirements

Supported Versions of Microsoft Excel:

  • Microsoft Excel 2007, 2010, 2013, 2016

Supported Architectures:

  • x86, x64

Supported Operating Systems:

  • Windows Vista SP2, 7 SP1, 8, 8.1, 10
  • Windows Server 2008 SP2, 2008 R2 SP1, 2012, 2012 R2, 2016

Supported Versions of Microsoft SQL Server:

  • Microsoft SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016 including Express LocalDB
  • Microsoft Azure SQL Database

Supported Versions of Microsoft SQL Server Compact:

  • Microsoft SQL Server Compact 3.5, 4.0

Supported Versions of Oracle Database:

  • Oracle Database 10g R1/R2, Oracle Database 11g R1/R2, Oracle Database 12c R1

Supported Versions of IBM DB2:

  • IBM DB2 9.5, 9.7, 9.8, 10.1, 10.5, 11.1

Supported Versions of MySQL:

  • MySQL 5.5, 5.6, 5.7

Supported Versions of SkySQL MariaDB:

  • MySQL 5.5, 5.6, 5.7

Supported Versions of NuoDB:

  • NuoDB 2.0.4, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6

Supported Versions of PostgreSQL:

  • PostgreSQL 8.0, 8.1, 8.2, 8.3, 8.4, 9.0, 9.1, 9.2, 9.3, 9.4

Supported Versions of SQLite:

  • SQLite 2, 3

End-User License Agreement

This End-User License Agreement (EULA) is a legal agreement between you (either an individual or a single entity) and Gartle Technology Corporation for any DB.RTD software, use examples and documentation (Software) that accompany this EULA.

YOU AGREE TO BE BOUND BY THE TERMS OF THIS EULA BY INSTALLING, COPYING, OR OTHERWISE USING THE SOFTWARE.

IF YOU DO NOT AGREE, DO NOT INSTALL, COPY, OR USE THE SOFTWARE.

Your licensing of Software is in accordance with the terms of the EULA in effect at the time of such licensing. By licensing Software, you accept and agree to the EULA in effect at such time.

  1. GRANT OF LICENSE: Gartle Technology Corporation grants you the following rights provided that you comply with all terms and conditions of this EULA:
    1. Trial Period: You may install, use, access, display and run the Software for purposes of evaluation of the Software for a period of fifteen (15) days from the date of installation of the Software to determine if the Software meets your needs. Upon completion of your evaluation or at the end of the 15-day trial period, whichever occurs first, you must do one of four things: either
      1) register the DB.RTD Free edition in order to continue use of Software;
      2) purchase license for the DB.RTD Personal or Enterprise edition in order to continue use of Software;
      3) purchase a subscription for the DB.RTD Personal or Enterprise edition in order to continue use of Software;
      or 4) discontinue use of the Software, and uninstall the Software from any and all machines.
    2. Installation and Use: You may install, use, access, display and run one (1) copy of the Software per license, on a non-exclusive basis and without right of sublicense or concurrent use, on a single computer or machine, such as a workstation.
      The commercial use of the DB.RTD Personal edition is not permitted, including the use by professional traders and institutional investors.
    3. Software Transfer: You may transfer the Software to a different internal workstation or user so long as you have purchased a License for each such workstation or user. You may not, however, transfer the Software to a Third Party.
    4. Use of Examples: You may install, access, modify and use Software examples, including Microsoft Excel workbooks, databases, SQL codes, and batch files, for your private or company-internal purposes.
  2. LIMITATIONS: You may not use, copy, modify, display, rent, lease, loan, transfer, distribute, download, merge, or make any translation or derivative work of the Software, except as expressly provided herein. You may not reverse engineer, decompile, or disassemble the Software, except and only to the extent that such activity is expressly permitted by applicable law notwithstanding this limitation.
  3. INTELLECTUAL PROPERTY RIGHTS AND CONFIDENTIALITY: The Software, including methods, processes and/or techniques utilized therein, is owned by, proprietary to and valuable trade secrets of Gartle Technology Corporation and is protected by Russian Federation copyright law and international treaties. You agree to take no actions that impair or infringe Gartle Technology Corporation's intellectual property rights in the Software. You agree not to remove, efface or obscure any copyright notices, other proprietary markings or confidentiality legends placed upon or contained within the Software.
  4. DISCLAIMER OF WARRANTIES: Gartle Technology Corporation disclaims all warranties concerning the Software and Services (if any), express, implied, or statutory, including without limitation, any warranties, duties or conditions of merchantability or fitness for a particular purpose, warranties of reliability or availability, of accuracy or completeness of responses, of results, of workmanlike effort, of lack of viruses, and of lack of negligence, all with regard to the Software, and the provision of or failure to provide support or other services, information, software, and related content through the Software or otherwise arising out of the use of the Software. Gartle Technology Corporation does not warrant that the Software will operate in combination with other software products selected by you, or that the Software will operate uninterrupted or error-free. Additionally, Gartle Technology Corporation and its suppliers provide the Software and Services AS IS AND WITH ALL FAULTS. THERE IS NO WARRANTY OR CONDITION OF TITLE, QUIET ENJOYMENT, QUIET POSSESSION, CORRESPONDENCE TO DESCRIPTION, OR NONINFRINGEMENT WITH REGARD TO THE SOFTWARE.
  5. NO LIABILITY: TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, IN NO EVENT SHALL GARTLE TECHNOLOGY CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY SPECIAL, INCIDENTAL, PUNITIVE, INDIRECT, OR CONSEQUENTIAL DAMAGES WHATSOEVER (INCLUDING, BUT NOT LIMITED TO, DAMAGES FOR LOSS OF PROFITS OR CONFIDENTIAL OR OTHER INFORMATION, FOR LOSS OF DATA, FOR BUSINESS INTERRUPTION, FOR PERSONAL INJURY, FOR LOSS OF PRIVACY, FOR FAILURE TO MEET ANY DUTY INCLUDING OF GOOD FAITH OR OF REASONABLE CARE, FOR NEGLIGENCE, AND FOR ANY OTHER PECUNIARY OR OTHER LOSS WHATSOEVER) ARISING OUT OF OR IN ANY WAY RELATED TO THE USE OF OR INABILITY TO USE THE SOFTWARE, THE PROVISION OF OR FAILURE TO PROVIDE SUPPORT OR OTHER SERVICES, INFORMATION, SOFTWARE, AND RELATED CONTENT THROUGH THE SOFTWARE OR OTHERWISE ARISING OUT OF THE USE OF THE SOFTWARE, OR OTHERWISE UNDER OR IN CONNECTION WITH ANY PROVISION OF THIS EULA, EVEN IN THE EVENT OF THE FAULT, TORT (INCLUDING NEGLIGENCE), MISREPRESENTATION, STRICT LIABILITY, BREACH OF CONTRACT OF GARTLE TECHNOLOGY CORPORATION OR ANY SUPPLIER, AND EVEN IF GARTLE TECHNOLOGY CORPORATION OR ANY SUPPLIER HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.
  6. LIMITATION ON REMEDIES: Within the first thirty (30) days after your receipt of the Software, should you encounter and report to Gartle Technology Corporation within such time period a reproducible error that causes the Software not to perform in all material respects as set forth in the Software documentation, then Gartle Technology Corporation will, at its sole discretion, either: a) resolve the error or malfunction, and modify or replace the Software (if deemed necessary by Gartle Technology Corporation); or b) allow you to terminate this EULA with respect to the non-conforming Software and, upon your return of the Software to Gartle Technology Corporation, Gartle Technology Corporation shall provide you with the lesser of a) the actual damages incurred by you; or b) the amount you paid for the non-conforming Software. The remedies described in this section shall be your sole and exclusive remedies under this EULA.
  7. GENERAL PROVISIONS
    1. Reservation of Rights and Ownership: Gartle Technology Corporation reserves all rights not expressly granted to you in this EULA. The Software is licensed, not sold.
    2. Consent to Use of Data: You agree that Gartle Technology Corporation and its affiliates may collect and use technical information gathered as part of the Software support services provided to you, if any, related to the Software. Gartle Technology Corporation may use this information solely to improve Gartle Technology Corporation products or to provide customized services or technologies to you and will not disclose this information in a form that personally identifies you.
    3. Links to Third Party Sites: We may link to third-party sites through the use of the Software. The third-party sites are not under the control of Gartle Technology Corporation, and Gartle Technology Corporation is not responsible for the contents of any third-party sites, any links contained in third-party sites, or any changes or updates to third-party sites. Gartle Technology Corporation is not responsible for webcasting or any other form of transmission received from any third-party sites. Gartle Technology Corporation is providing these links to third-party sites to you only as a convenience, and the inclusion of any link does not imply an endorsement by Gartle Technology Corporation of the third-party site.
    4. Additional Software/Services: This EULA applies to updates, supplements, add-on components, or Internet-based services components, of the Software that Gartle Technology Corporation may provide to you or make available to you after the date you obtain your initial copy of the Software, unless Gartle Technology Corporation provides other terms along with the update, supplement, add-on component, or Internet-based services component. Gartle Technology Corporation reserves the right to discontinue any Internet-based services provided to you or made available to you through the use of the Software.
    5. Upgrades: To use Software identified as an upgrade, you must first be licensed for the software identified by Gartle Technology Corporation as eligible for the upgrade. After upgrading, you may no longer use the software that formed the basis for your upgrade eligibility.
    6. Applicable Law: This EULA is governed by the laws of the Russian Federation. Any legal action or proceeding relating to this EULA shall be instituted in a court of arbitration in the Moscow City, Russian Federation. Gartle Technology Corporation and you agree to submit to the jurisdiction of, and agree that venue is proper in, these courts in any such action or proceeding. The prevailing party in any action to enforce this EULA will be entitled to recover its attorney fees and costs in connection with such action.
    7. Waiver: The failure of either party to enforce any of the terms of this EULA shall not be construed as a waiver of future enforcement of that or any other term.
    8. Entire Agreement and Severability: This EULA (including any addendum or amendment to this EULA which is included with the Software) is the entire agreement between you and Gartle Technology Corporation relating to the Software and the support services (if any) and it supersedes all prior or contemporaneous oral or written communications, proposals and representations with respect to the Software or any other subject matter covered by this EULA. To the extent the terms of any Gartle Technology Corporation policies or programs for support services conflict with the terms of this EULA, the terms of this EULA shall control. If any provision of this EULA is held to be void, invalid, unenforceable or illegal, the other provisions shall continue in full force and effect.
    9. Termination: Without prejudice to any other rights, Gartle Technology Corporation may terminate this EULA if you fail to comply with the terms and conditions of this EULA. In such event, you must destroy all copies of the Software and all of its component parts and you will not be entitled to any refund of monies.

Trial Version Limitations

You can use DB.RTD Enterprise during a 15-day trial period for free.

You have to activate the trial.

When the trial period has expired, you have the following options:

  1. To register the DB.RTD Free edition for free.
  2. To purchase a license and register the DB.RTD Personal or Enterprise edition.
  3. To purchase a subscription and register the DB.RTD Personal or Enterprise edition.
  4. To stop the use and remove DB.RTD from a computer.

See also

Using DB.RTD

Data Formulas

DB.RTD has the following formula format:

=RTD("db.rtd",,"<Connection string or connection name>","<Database table or view name>"
    [,"<Where column>","<Where value>"[,"<Where column>","<Where value>"[,...]]]
    ,"<Data field>")

For example:

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

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

As you may see, DB.RTD formulas are similar to the GETPIVOTDATA Excel formula.

In this example, sqlexpress is a name of the connection string. It is a default name for a local Microsoft SQL Express database.

You may create named connection strings for your databases in a visual mode using Connection Manager.

Also, you may use connection strings directly. See Connection Strings below.

dbo.quotes and dbo.historical_prices are names of tables or views. You may specify names including a database like test3.dbo.quotes.

Symbol and Date are table columns.

Close is a data field. RTD.DB uses the MAX formula by default. You may specify the aggregate formulas like COUNT(Close) or MIN(Close).

For the first formula, DB.RTD generates and executes the following SQL query:

SELECT MAX([last]) AS [last] FROM [dbo].[quotes] WHERE [symbol] IN ('AAPL') GROUP BY [symbol]

For the second formula, DB.RTD generates and executes the following SQL query:

SELECT MAX([last]) AS [last] FROM [dbo].[historical_prices]
         WHERE [symbol] IN ('AAPL') AND [date] IN (<TODAY() value>) GROUP BY [symbol], [date]

Refresh Intervals

You may set the refresh interval for tables using formulas like this:

=RTD("db.rtd",,"sqlexpress","dbo.quotes","RTD_RefreshInterval",15*60)

You may set values in seconds like shown above or as a time value like 0:15:00.

Tick Fields

Tick fields allow understanding value change directions and may be used with conditional formatting.

Add the :tick suffix to the underlying data field name. For example:

=RTD("db.rtd",,"sqlexpress","dbo.quotes","symbol","AAPL","last")

=RTD("db.rtd",,"sqlexpress","dbo.quotes","symbol","AAPL","last:tick")

Formula Examples

Tables with Identity Fields

Tables with identity fields have a single column like id with auto-incremented value like this:

Table of stock tick prices

Getting values for such tables requires two types of formulas:

  1. Getting id values.
  2. Getting data values.

To get the last id value for the YHOO symbol, we may use the formula:

=RTD("db.rtd",,"sqlexpress","test3.dbo.tick_history","symbol","YHOO","id")

We may use cell values in regular Excel formulas like this:

=Id formula example for stock tick prices

In the next steps, we use the id value to get other data. For example:

=RTD("db.rtd",,"sqlexpress","test3.dbo.tick_history","id",4,"date")

This is a model:

Date formula example for stock tick prices

Tables with Multiple Key Fields

The typical scenario is getting historical prices from tables like this: 

Table of historical stock prices

To get values for the specific symbol and date, we may use a formula:

=RTD("db.rtd",,"sqlexpress","test3.dbo.historical_prices","symbol","YHOO","date",TODAY(),"open")

To get values for the last trade data, we have to use two types of formulas:

  1. the first to get the last date,
  2. and the second to get data.

For example:

=RTD("db.rtd",,"sqlexpress","test3.dbo.historical_prices","symbol","YHOO","date")

This is a model:

Date formula example for historical stock prices

The second formula example is

=RTD("db.rtd",,"sqlexpress","test3.dbo.historical_prices","symbol","YHOO","date","4/13/2017","open")

This is a model:

Open formula example for historical stock prices

Tables with Single Key Fields

This is the simplest case. The tables have a single primary column like this:

Table of stock quotes

You may use a formula like this:

=RTD("db.rtd",,"sqlexpress","test3.dbo.quotes","symbol","YHOO","open")

This is a model:

Date formula example for stock quotes

Connection Strings

As mentioned above, you may use connection strings or connection names in the RTD formulas.

Using the connection names is much better as you may create connections in a visual mode and encrypt the connection strings.

However, you may use the connection strings directly in the following forms:

<.NET provider>;<.NET connection string>

System.Data.OleDb;<OLEDB connection string>

OLEDB;<OLEDB connection string>

<OLEDB connection string>

System.Data.Odbc;<ODBC connection string>

ODBC;<ODBC connection string>

<ODBC connection string>

OLEDB is as a synonym of System.Data.OleDb and ODBC is as a synonym of System.Data.Odbc.

You may omit the OLEDB provider if the OLEDB connection string starts with 'Provider='.

Also, you may omit the ODBC provider if the ODBC connection string starts with 'Driver='.

DB.RTD includes .NET providers for Microsoft SQL Server, Microsoft SQL Server Compact, Oracle Database, MySQL, PostgreSQL, NuoDB, and SQLite.

You have to download and install .NET, OLEDB or ODBC providers to connect to IBM DB2.

Below are examples of the connection strings.

Connection Strings for Microsoft SQL Server

System.Data.SqlClient;Data Source=.\SQLEXPRESS;Initial Catalog=test;Integrated Security=SSPI

System.Data.SqlClient;Data Source=.\SQLEXPRESS;Initial Catalog=test;Password=Pa$$w0rd!;User ID=sa

System.Data.OleDb;Provider=SQLOLEDB;Data Source=.\SQLEXPRESS;Initial Catalog=test;Integrated Security=SSPI

System.Data.OleDb;Provider=SQLOLEDB;Data Source=.\SQLEXPRESS;Initial Catalog=test;Password=Pa$$w0rd!;User ID=sa

System.Data.Odbc;Driver=SQL Server;Server=.\SQLEXPRESS;Database=test;Trusted_Connection=Yes

System.Data.Odbc;Driver=SQL Server;Server=.\SQLEXPRESS;Database=test;Pwd=Pa$$w0rd!;UID=sa

Driver=ODBC Driver 13 for SQL Server;Server=.\SQLEXPRESS;Database=test;Trusted_Connection=Yes

Driver=ODBC Driver 13 for SQL Server;Server=.\SQLEXPRESS;Database=test;Pwd=Pa$$w0rd!;UID=sa

You may download and install Microsoft ODBC Driver 13.1 for SQL Server to use the latest features of Microsoft SQL Server 2016 and Microsoft Azure SQL Database.

However, try the built-in .NET provider first.

Connection Strings for Microsoft SQL Server Compact

System.Data.SqlServerCe.4.0;Data Source=d:\data\test.sdf;Password=

Note that you have to specify the absolute path to the database file.

You may use the following formula to get the path to the file in the active workbook folder:

="System.Data.SqlServerCe.4.0;Data Source="&LEFT(CELL("filename"),FIND("[",CELL("filename"),1)-1)&"test.sdf;Password="

Connection Strings for Oracle Database

Oracle.DataAccess.Client;Data Source=localhost/test;Password=Pa$$w0rd!;User ID=system;

System.Data.OleDb;Provider=OraOLEDB.Oracle;Password=Pa$$w0rd!;User ID=system;Data Source=localhost/test;PLSQLRSet=True

Provider=OraOLEDB.Oracle;Password=Pa$$w0rd!;User ID=system;Data Source=localhost/test;PLSQLRSet=True

Connection Strings for IBM DB2

IBM.Data.DB2.10.5.0;Server=localhost;Database=test;UserID=db2admin;Password=Pa$$w0rd!

Driver=IBM DB2 ODBC DRIVER;Hostname=localhost;Port=50000;Protocol=TCPIP;Database=test;Pwd=Pa$$w0rd!;UID=db2admin;LONGDATACOMPAT=1

You have to install IBM DB2 .NET provider or ODBC driver to your computer.

Use "IBM Data Server Client Packages" phrase to find the required IBM DB2 connectivity components.

Connection Strings for MySQL

MySql.Data.MySqlClient;Server=localhost;Password=Pa$$w0rd!;User ID=root;Database=test

Driver=MySQL ODBC 5.3 ANSI Driver;Server=localhost;Database=mysql;Pwd=Pa$$w0rd!;UID=root;OPTION=67108864

Driver=MySQL ODBC 5.3 Unicode Driver;Server=localhost;Database=mysql;Pwd=Pa$$w0rd!;UID=root;OPTION=67108864

Connection Strings for PostgreSQL

Npgsql;Server=localhost;Database=test;User Id=postgres;Password=Pa$$word!

Connection Strings for NuoDB

NuoDb.Data.Client;Server=localhost;User=DBA;Password=goalie;Database=test

Connection Strings for SQLite

System.Data.SQLite;Data Source=d:\data\test.db;Version=3;

Note that you have to specify the absolute path to the database file.

You may use the following formula to get the path to the file in the active workbook folder:

="System.Data.SQLite;Data Source="&LEFT(CELL("filename"),FIND("[",CELL("filename"),1)-1)&"test.db;Version=3;"

gConnectionManager

gConnectionManager allows editing DB.RTD connections in a visual mode.

You may create new connections, enable or disable the existing connection strings.

The connection strings are stored in the configuration file in your personal application folder.

You may also encrypt connection strings.

To open the connection manager, use Start Menu, All Programs, DB.RTD, gConnectionManager.

The connection manager looks like this:

gConnectionManager

Click the "..." button to edit the connection string.

Select a database connection provider at the first step:

gConnectionManager - Selecting a database provider

gConnectionManager shows installed providers only. You may see a shorter list.

Enter the information required to connect to a database:

gConnectionManager - Connecting to a database

The different database servers have specific features. Click the Help button or the Examples link to get the context help during the connecting.

The wizard tests the connection in the background and activates the Finish button if the connection succeeds.

If the Finish button is disabled, click the Test Connection button to test the connection.

Application Fields

Application fields allow getting information about application settings, queries, and value changes using RTD formulas.

Server Fields

Formula format:

=RTD("db.rtd",,"<Data field>")

For example:

=RTD("db.rtd",,"rtd_server_Version")

=RTD("db.rtd",,"rtd_server_Registration")

Complete list of fields:

FieldMeaning
rtd_server_VersionThe DB.RTD version
rtd_server_RegistrationInformation about the registered edition and trial period
rtd_server_TimeZoneThe TimeZone setting
rtd_server_DateTimeThe current date and time adjusted to the specified time zone
rtd_server_DateThe current date adjusted to the specified time zone
rtd_server_TimeThe current time adjusted to the specified time zone

Tick Fields

Tick fields allow understanding value change directions and may be used with conditional formatting.

Add the :tick suffix to the underlying data field name. For example:

=RTD("db.rtd",,"sqlexpress","dbo.quotes","symbol","AAPL","last")

=RTD("db.rtd",,"sqlexpress","dbo.quotes","symbol","AAPL","last:tick")

Tick values:

Tick ValueMeaning
1The value is changed up
0The value is unchanged
-1The value is changed down

Row Specific Fields

Use the following fields to get the information about queries at the row level:

FieldMeaning
rtd_LastUpdateThe date and time of the last update
rtd_LastUpdateDateThe date of the last update
rtd_LastUpdateTimeThe time of the last update
rtd_LastErrorThe last error code
rtd_LastMessageThe last error message

For example, if a data formula is

=RTD("db.rtd",,"sqlexpress","dbo.quotes","symbol","AAPL","last")

you may monitor the status like:

=RTD("db.rtd",,"sqlexpress","dbo.quotes","symbol","AAPL","rtd_LastUpdate")
=RTD("db.rtd",,"sqlexpress","dbo.quotes","symbol","AAPL","rtd_LastError")
=RTD("db.rtd",,"sqlexpress","dbo.quotes","symbol","AAPL","rtd_LastMessage")

Table Specific Fields

Use the following fields to get the information at the table level:

FieldMeaning
rtd_RefreshIntervalThe refresh interval (get and set)

For example, if a data formula is

=RTD("db.rtd",,"sqlexpress","dbo.quotes","symbol","AAPL","last")

you may get the table refresh interval like:

=RTD("db.rtd",,"sqlexpress","dbo.quotes","rtd_RefreshInterval")

and set the interval (in seconds) using the formula like this (15 minutes):

=RTD("db.rtd",,"sqlexpress","dbo.quotes","rtd_RefreshInterval",15*60) 

Application Settings

RTD.DB loads application settings from the db.rtd.dll.config file located in the local application folder like

C:\Users\<Your user name>\AppData\Gartle\DB.RTD\db.rtd.dll.config

You may open the file using Start Menu, All Programs, DB.RTD, Configuration File.

To edit connections in a visual mode, use Start Menu, All Programs, DB.RTD, gConnectionManager.

The configuration file contains connection strings and configuration parameters.

Configuration file example:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <appSettings>
        <add key="TimeZone" value=""/>
    </appSettings>
    <connectionStrings>
        <add name="sqlexpress"
            connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=master;Integrated Security=True"
            providerName="System.Data.SqlClient" />
    </connectionStrings>
</configuration>

The sqlexpress connection string is shipped by default.

Configuration parameters:

TimeZone
The string value defines the time zone used in the rtd_LastUpdate, rtd_LastUpdateDate, and rtd_LastUpdateTime fields.
The default value is the current Windows time zone.
See available time zones at http://technet.microsoft.com/en-us/library/cc749073(v=ws.10).aspx.

You may get setting values in Excel using application fields.

Troubleshooting

The formula returns #N/A
Use the rtd_LastMessage field to check errors like this:
=RTD("db.rtd",,"sqlexpress","dbo.quotes","Symbol","AAPL","rtd_LastMessage")
The data are not refreshed
You may check the refresh interval using the formula like this:
=RTD("db.rtd",,"sqlexpress","dbo.quotes","rtd_RefreshInterval")
and set the interval in seconds like
=RTD("db.rtd",,"sqlexpress","dbo.quotes","rtd_RefreshInterval",15*60)

Product Registration

DB.RTD requires registration to start a trial and to use it after the trial period.

To register, open Start Menu, All Programs, DB.RTD, Register Product.

Selecting Edition

You may register the trial version or the DB.RTD Free edition for free, the product code is not required.

To register the DB.RTD Personal or Enterprise edition fill in the product code received after purchasing.

DB.RTD Registration - Select the edition

Licensee Data

Please fill in the registration form like this:

DB.RTD Registration - Fill personal data

The Next button is enabled when all the required fields are filled.

Don't forget to check the required field about the personal data use.

Online Registration

This step allows you to check your email address. If the email is valid, click Next.

You may return to the previous step using the Back button.

DB.RTD Registration - Check the email

After clicking the Next button, the DB.RTD connects to the registration server.

If the connection is successful, the final step screen is shown.

If any error occurred during connection, you might try to register the product later or try to register the product by email.

DB.RTD Registration - The final step

You may set the registration for all users of the computer. This action requires administrator privileges.

Click Finish.

Registration by Email

If you choose the Register by email option on the Licensee Data step, the following screen is displayed:

DB.RTD Registration - Check and start the registration email

The Next button starts the default email program, creates a registration email, and activates the next step.
Don't forget to send the email.

If starting of the email program has failed, you may create the registration email manually using the shown registration data.
Please carefully copy the To, Subject, and the Message fields.

The registration server sends the reply in a couple of seconds; but you may close the dialog box and open it again, in the same step.

Please copy the activation code from the received registration email and paste it into the Activation code field.

DB.RTD Registration - Check and start the registration email

The Next button is enabled when the activation code is valid.

Click Next to continue.

The wizard checks the registration data and confirms the registration.

DB.RTD Registration - The final step

You may set the registration for all users of the computer. This action requires administrator privileges.

Click Finish.