Related Articles
QRG - Using Access to query data warehouse
(A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/1jcxI35q1Rpz_gLCbOonQaWSgO51duFq7/view ) Introduction Open Database Connectivity (ODBC) database. Similar to the state data warehouse, you’ll need to install an ...
Excel Querying Data Warehouse (Microsoft Query)
It appears recent Office 365 Updates (2024) have impacted the menu choices for those of you who use the Microsoft Query to access State Data Warehouse. If you no longer see the Microsoft Query in the 'Other' query option, please see below for ...
QRG - Using Excel to query data warehouse
(A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/1CzcUic3qykVURnFS1yrkN-roU5YvQzJv/view ) Introduction To access State Data Warehouse using excel or other tools, create a DTS helpdesk ticket, they need to install ...
Data Warehouse - Data Dictionary
Information Data Warehouse has published a Data Dictionary, sharing all of the State Datawarehouse Tables and Fields. Some tables have details and joins to use, where other less commonly used tables simply share the field names. This should be ...
Payment Plus Information
Background What is Payment Plus? Payment Plus allows vendors who meet certain requirements to receive payments as Visa payments through US Bank. Payments made to vendors signed up for Payment Plus will go to the US Bank VISA account and US Bank will ...