Event Engineering

This section provides one example of "Event Engineering": selecting source data and transforming it to the WellLine data model, and uploading to the WellLine TimeLine Service.

When starting on a WellLine project one of the first questions you will need to start thinking about is:

"What events do I want to put onto the Timeline?"

The choices made this stage will ultimately set the course and scope of the data inclusion effort(s). The selection of source data is usually made by a subject matter expert (SME) or someone with an understanding of the types of events that would be meaningful to end users.

After selection, source data must be transformed to the WellLine data model. This data transformation is traditionally performed by someone with data processing skills, particularly data management and transformation.

The output of this processing should produce events and entities in the form of JSONL files, which can then be uploaded to the TimeLine Service (which powers the WellLine Knowledge Application) through our Command Line Interface (CLI) Tool.

Event Engineering Roles

Data Sources Determination

Ideal people filling the role of the "SME" as part of Event Engineering typically have had the following titles (or similar) in the past:

  • Drilling Engineer

  • Production Engineer

  • Drill Site Manager

  • Petroleum Engineer

  • Drilling Technologist

  • Reservoir Engineer

  • Operations Geologist

The person fulfilling this role ideally has the following skills/knowledge:

  • An understanding of the asset (i.e. wells) they are modeling, including how they are drilled, completed, intervened and abandoned

  • An understanding of the source data structures that will be used to create events from

    • These typically are databases that are used in upstream to capture operations activities (WellView, OpenWells, PI, Production Systems, etc.)

  • Ability to use and demonstrate WellLine confidently

  • A good understanding of the language used at well sites, for example in daily drilling reports, incident logs, and lessons learned reports.

Data Source Transformation

Ideal people filling the role of "data transformer" as part of Event Engineering typically have had the following titles (or similar) in the past:

  • Data Analyst

  • Database Administrator

  • ETL Developer

  • Data Migration Specialist

  • Data Integration Engineer

  • Data Warehouse Engineer

The person fulfilling this role ideally has the following skills/knowledge:

  • An ability to use ETL tools to turn the source data into WellLine events

  • Knowledge of the options available to extract portions of source data

  • An understanding of the WellLine data model, especially how subject and reference entities work in the system

  • Ability to use and demonstrate WellLine confidently

Prerequisites

Source Data

  • There is no limit to the type of data that can be uploaded to a WellLine installation

  • All data sources must be transformed to fit the WellLine Data Model

  • See Data Sources Determination for tips on selecting data sources for inclusion in the product

ETL / Data Manipulation and Conversion Tool

  • The WellLine team uses Alteryx for transforming source data into the WellLine Data Model, but any software can be used

  • For users of Alteryx, templates in the form of Alteryx workflow containers have been created to help bootstrap this process

    • The latest versions of these templates are available upon request

WellLine CLI (Command Line Interface) Tool

  • This tool enables quick command-line based uploading of data (formatted as per the WellLine Data Model) to the WellLine TimeLine Service

  • It is available online in a GitHub repository

    • Access to this repository can be granted upon request