Data Handling

 

Leave it on the EDW server and connect to it directly

Advantages 

  • data is as "real time" as it gets
  • don't have to setup warehouse/shadow system
  • structural changes in EDW database minimized

Disadvantages

  • speed is slower
  • access and security  procedure would apply to all who used your query

Set Up Warehouse locally

Advantages

  • speed is in your control
  • easier integration and delivery of local data with EDW data
  • access and security procedures are in your control

Disadvantages

  • setting up extract process time consuming
  • responsibility for access and security high
  • being at the nth level makes dependency accommodation difficult

Tips: