1. Home
  2. Modules & Add Ons
  3. Microsoft Azure Data Warehouse User’s Guide

Microsoft Azure Data Warehouse User’s Guide

The Microsoft Azure Data Warehouse feature allows clients to have their data stored in a cloud environment for querying. This can be used by clients to run additional reporting from or have a third party pull the data from the warehouse for other use. Unless otherwise stated, there is a standard data set defined in a data dictionary that is provided.

Configuration Steps

  • Developer will create a new Microsoft Azure Account for the client with a service plan commensurate with the expected client usage.
  • Tables will likely follow [dbo]. schema naming convention. — IDSTC/Admin access only.
  • Views should follow [ClientName]. schema naming convention. — Client specific access, IDSTC will have access also.
  • Verify that views outlined in change order are present in the Azure database and are accurate.
  • Select top 1000 from each of the views to make sure there are no errors.
  • Verify that base procedures/functions/views have been created. (Minimum operable level; GetDownline sprocs, zip code tables, etc).

Project Management Acceptance Testing Checklist

  • Verify client-specific Azure user credentials exist in client outlook contact card, are valid (can login), and access is restricted appropriately (views only).
  • Verify super user (IDSTC) credentials exist in client outlook contact card, are valid (can login), and access is NOT restricted.
  • Verify that views outlined in change order are present in the Azure database and are accurate.
  • Validate data dictionary exists in client P folder, is updated and accurate to change order.
  • Verify nightly sync process is setup and configured correctly per client needs (frequency).
  • Verify nightly sync process is working (alter some piece of data and ensure change propagates to the table).

smss

Client Data

  • Verify client account credentials and deliver to client, with the data dictionary and Azure database name (client will need to be sure to set this as the default database if logging in through a tool like SQL Server Management Studio)
    • Client Username, Password, SMSS/Database Server and Database Name

Was this article helpful?

Yes No