Choose federation when you need data freshness that ETL cannot provide, or when governance rules prevent copying data to your analytics system. Choose ETL when you run the same queries repeatedly or when performance predictability matters more than data freshness.