While there is an advantage to separating components, doing so assumes that the network connections between servers have high bandwidth and low latency. These servers should be on the same local area network with gigabit connections. Any increase in latency will have an effect on the ETL performance.
The Primavera Data Warehouse schema supports multiple P6 EPPM and Primavera Unifier data sources for a single data warehouse instance. With the internationalization of the corporate operations, it’s likely that the data sources might be distributed across geographic regions and connected via corporate WAN instead of the high-speed, low-latency LAN. Data extraction is a high volume operation, and the bandwidth and network latency impact performance. Oracle has a 10-10 rule for the corporate WAN connections:
- Minimum network bandwidth: 10 mbps
- Maximum network latency: 10 ms
For a successful deployment, you should have network parameters that are better than these minimum requirements.