Exporting data from Bloomberg to your data warehouse is subject to strict licensing restrictions. Here’s what you need to know:
✅ What
is
typically allowed:
- Manual exports (e.g., copy-pasting or downloading via Bloomberg Excel Add-In) for internal use only, and often limited in volume.
- Using Bloomberg data within licensed tools like Excel, Power BI (via manual upload), or internal dashboards — if they do not expose data externally or to unlicensed users.
- Storing small volumes of data in internal systems for internal analysis, assuming you comply with Bloomberg’s entitlement rules and contractual limitations.
❌ What is
not
allowed:
- Automated extraction of large volumes of data using scripts or APIs into a data warehouse or cloud environment without explicit Bloomberg permission.
- Sharing Bloomberg data with third parties, including cloud providers or business partners, unless specifically permitted.
- Redistributing or reselling Bloomberg data.
- Storing data beyond what’s covered under your enterprise agreement, especially in multi-tenant or cloud-based data lakes/warehouses.
🚨 Important Notes:
- Bloomberg’s Data License (DL) product offers a legal way to obtain bulk data for ingestion into databases and data warehouses — but it’s different from the Bloomberg Terminal (BQL/Excel) license and involves separate fees.
- Bloomberg audits usage regularly, and violations can lead to fines or termination of service.
✅ Best Practice:
- Review your Bloomberg license agreement carefully.
- Talk to your Bloomberg account representative before building any automated pipeline to a warehouse.
- If you need bulk data, consider licensing the Bloomberg Data License product.
- Isolate Bloomberg-derived data in your warehouse to maintain auditability and compliance.