Templates Direct Database Connexion
A previous post looked at how the NHS "Statistical Process Control (XmR) Tool" Excel Template works with Public View's data, with data being manually exported from Public View and pasted into the Excel Template.
This post looks at doing that more efficiently, with a direct database connexion to Public View's Database Service!
Data Warehouse
Excel
NHS Excel Template
Tutorial
Database Connectoid
database service
sql
facts and dimensions
statistical process control
SPC Charts
26 Aug 2021
read more…
Public View Database Service
We're starting to receive user feedback on the Public View Database Service, which went live earlier this month.
The new Service delivers direct schema access to the Public View Data Warehouse.
dimensions
facts
schema access
sql
Data Warehouse
SSMS
SQL Server Management Studio
23 Aug 2021
read more…
Public View Database Service
The new Public View Database Service is now formally out of Beta test and humming nicely.
database service
dimensions
sql
launch
facts
schema access
Data Warehouse
SSMS
SQL Server Management Studio
06 Aug 2021
read more…
Release 1.4, Database Access
You may well not notice the little version number at the bottom right-hand side of our web pages, but it's there. It's a complicated number as we need to know precisely what version is which.
release
database service
dimensions
sql
facts
schema access
Data Warehouse
SSMS
SQL Server Management Studio
29 Jul 2021
read more…
See all tags.