The Tango Data Mart provides SQL database access to a customer’s information. The database follows a dimension and fact model.

Connection Information

The Data Mart is an online data store SQL database access to a customer’s information.

Host Information

The Data Mart IP for access will be shared via Support Ticket as requested (if subscribed to Datamart).

Authentication

Access to the Data Mart is provide through a SQL-authenticated user ID and password. User credentials will be provided via secure email.

Refresh Timing

The Data Mart is currently refreshed (full load) between 04:30 Eastern Time and 06:00 Eastern Time each day.

Summary of Objects

Below is a visual representation of the various objects in Data Mart.

DIMENSION TABLES:

• DM_PROPERTIES

• DM_BUILDINGS

    

• DM_DEPARTMENTS

• DM_FLOORS

  

• DM_SPACE_TYPES

• DM_BUILDING_CONTACTS

• DM_FLOORS

• DM_ASSETS

• DM_MAILZONES

• DM_MAC_GROUPS

• DM_PERSONS

  
  

• DM_SPACE_SCENARIOS

• DM_SPACE_AREA

• DM_BATCH_EVENTS

  
  

• 
  

• DM_SPACE_DEPT_PERSON_ALLOC

  

  DM_SPC_DEPT_PERSON_ALLOC_STANDARD

• 

• DM_DEPARTMENT_METRICS_CONNECTBY

  
  

1. FACT TABLES.

   • DM_SPACES

   • DM_SPACE_AREA_ASSOCIATIONS

   • DM_BUILDING_ATTR_TRENDS 

   • DM_MOVE_REQUESTS

   • DM_MAC_ALERTS 

   • DM_STORE_STRATEGIES 

   • DM_SPACE_ALLOCATIONS 

   • DM_DEPARTMENT_METRICS

   • DM_FACT_DEPARTMENTS 

   • DM_SPACE_ALLOC