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.

• D_SITES

• D_PROJECTS

• D_PROGRAMS

• D_SUPPLIERS

• D_REGIONS

• D_MILESTONES

• D_MILESTONE_TEMPLATES

• D_RPT_MILESTONE_TYPES

• D_ADHOC_TASKS_ASSIGNEE

• D_ADHOC_TASKS_TYPE

• D_ADHOC_TASKS_STATUS

• D_ADHOC_TASKS_PRIORITY

• D_ADHOC_TASKS_ASSIGNED_BY

• D_ENTITY_DETAILS

• D_CONTACTS

• D _ENTITY_DETAILS_CONTACTS

    

• D_ENTITY_STATUSES

• D_ENTITY_TYPES

• D_PO_HEADER

• D_TARGETS

  • D_MILESTONE_DETAIL_CONTACTS

    

• DM_PROSPECTS

• DM_FILES

  • DM_ENTITY_ATTRIBUTES_MULTI 

• D_PROJECT_BASELINE_VERSIONS

• D_WF_ENTITY

• DM_TRADEAREAS_SITES

• DM_TARGETS

• DM_ENTITY_ENCROACHMENTS

• DM_MILESTONES_HISTORY 

  • DM_ALL_STORES_TA 

  • DM_STORE_SALES

    

1. FACT TABLES.

   • F_BUDGETS 

   • F_POS 

   • F _COS 

   • F_INVOICES

     

   • F _MILESTONES 

   • F_MILESTONE_BENCHMARKS 

   • F_STORES_PROJECTS_SITES 

   • F_MILESTONE_BASELINE_DTL 

   • F_ENTITY_COMMENTS 

   • F_PROJECT_COUNTS 

     F_STORE_COUNTS 

   • F_SITE_COUNTS 

   • F_EWA_EXT_AUTH 

   • F_PROJECT_BASELINE_DETAIL 

   • F_WF_APPROVAL_HISTORY 

   • F_TARGET_COUNTS