Unlock useful information from OpenWells and EDM
Halliburton Landmark OpenWells is used by oil and gas teams to manage drilling and well operations information. JUIA provides scoped services around OpenWells/EDM data extraction, analysis, migration planning and reporting.
Our service approach combines specialist well-data and relational database expertise with practical assessment of each customer’s OpenWells environment.
OpenWells services
- Review of OpenWells / EDM data structures and reporting requirements
- Database querying, data extraction and operational data validation
- Power BI data models and drilling performance reporting
- Historical data preparation and source-to-target migration mapping
- EDM integration analysis and project-based technical assistance
- Data dictionaries, documentation and practical training
Connected systems and analytics
We can assess pathways for authorised exchange of OpenWells data with SQL databases, Snowflake, Power BI and other enterprise reporting platforms.
Our goal is reliable, explainable operational information—not introducing unnecessary platform complexity.
These checks are general data-engineering practices; the final mapping must be established from the customer's permitted EDM environment. Read the OpenWells EDM extraction guide.
- Define the intended reporting grain: one record per well, wellbore, job, report or event.
- Identify the keys and relationships required to prevent missing or duplicated rows.
- Agree the meaning of important measures and reporting periods with operational users.
- Validate extracted totals against application views and representative wells before publishing dashboards.
EDM reporting work should begin with a short source and access assessment rather than assuming a particular schema or extracting every table. Confirm which applications and versions use the EDM environment, which wells and operational periods are in scope, and whether a reporting database or approved interface is available.
Questions to resolve before an OpenWells / EDM reporting project
Frequently asked questions
What is EDM in relation to OpenWells?
EDM (Engineer’s Data Model) is the underlying data environment used by Landmark applications, including OpenWells in applicable deployments. Actual database access and schema depend on the customer’s system and configuration.
Can JUIA extract OpenWells data into Power BI?
JUIA can assess permitted EDM data access, map relevant well and operational records, and propose validated Power BI reporting or data integration solutions.
Does JUIA replace official OpenWells vendor support?
No. JUIA is an independent consultancy and does not claim to be Halliburton Landmark or an authorised vendor support provider.