Real-Time Views for Microsoft Excel
RealTimeToDB allows updating databases with real-time data.
RealTimeToExcel, an included companion product, allows getting real-time data from databases into Microsoft Excel.
You can refresh data in Excel in an easy way.
Getting Data Using SaveToDB Add-In
The RTD database contains preconfigured views with Excel formulas for RealTimeToExcel with the SaveToDB add-in installed.
The SaveToDB add-in converts text formulas from views into native Excel formulas. Just open any view in Excel.
Pasting Formulas into Excel
Also, you can copy formulas using Copy or (Copy) Transposed links and insert formulas into Microsoft Excel.
Select commas or semicolons depend on a separator in your version of Microsoft Excel.
Then adapt the data provider name to your database connections.
For example, change rtd-mysql to rtd-ora if you use Oracle Database.
Configuring RealTimeToExcel Providers
RealTimeToExcel has predefined data providers for every database server:
- rtd-mssql for Microsoft SQL Server.
- rtd-sqlce for Microsoft SQL Server Compact.
- rtd-mysql for Oracle MySQL or SkySQL MariaDB.
- rtd-ora for Oracle Database.
- rtd-db2 for IBM DB2.
- rtd-nuodb for NuoDB.
- rtd-pgsql for PostgreSQL.
These providers are used in the formulas.
You have to specify a correct connection string before the first use.
Edit connection properties for your database in the data provider configuration file in the DataProviders directory.
Preconfigured Real-Time Data Views
* Click on the view name to go to the view description.