You can import well production and reservoir data from your company's database into a Harmony Enterprise project. You can also import from an open database compliant (ODBC) database into Harmony Enterprise.
Harmony Enterprise uses the Database Connection wizard to facilitate importing well production and attributes, along with wellbore, fluid, and reservoir properties from your company's proprietary database into the Harmony Enterprise database.
Important: The Database Connection wizard reads data from your company's database, but does not write to it. Therefore, there is no danger that Harmony Enterprise can corrupt your database. However, you must ensure that the SQL or Windows login you use to connect has read access.
If you want to watch a video of the import database wizard, see how to import data from a database (opens The Learning Center in a new window). Note that you need to create an account in order to access content on The Learning Center.
To import well and production data from your database:
1. Click the Import icon (
) in the main toolbar and select Database Connection.
The Import Database Wizard opens.
2. In the Import Database - Harmony dialog box, read the welcome message and click Next.
3. In the Specify Connection Settings dialog box:
- to create a new database connection, click New Connection.
- to edit an existing database connection, select the connection, then click Edit.
- to use an existing connection, select the connection, then click Next. Proceed to step 9.
- to delete an existing connection, select the connection, then click Delete, Yes.
- to copy an existing connection, select the connection, then click Duplicate. This copies the existing database mappings in a connection to a new connection.
- (not applicable to SE licenses) review your scheduled well updates (daily, weekly, or monthly). For more information, see scheduling well updates.
4. In the Set Up Connection Settings dialog box, type / edit your connection name.
Your connection name, data source, connection credentials, and schema are saved for this database connection and can be used by others. Your user name and password are saved on a per-user basis.
Click Access File and browse to your Microsoft Access database (.mdb, .accdb files).
Or, click Data Sources and select your data source from the drop-down list, or click Add New.
5. In the Specify Mapping dialog box (only applies to new database connections), select your initial mapping configuration (that is, Aries, IHS Views, Custom Mapping, Legacy Schema Mapping); click Next.
- Aries — We have provided a mapping based on the standard tables and columns available in an Aries database. Mapping is pre-configured for the default Aries data model.
- IHS Markit Views — If your DBA or other database support has already created a view in your database to map its content to Harmony Enterprise, select this option. Mapping comes from the SQL views or queries built within the data source.
- Custom Mapping —You can manually map the tables and columns in your database to recognized Harmony Enterprise data in the next part of the wizard.
- FieldDIRECT — We have provided a mapping based on the standard tables and columns available in a FieldDIRECT database. Mapping is pre-configured for the default FieldDIRECT data model.
6. In the Assign Mapping dialog box, set your initial mapping, or resolve any errors in the existing mapping as follows:
- In the left pane, tables are mapped by clicking the Client Tables/Views (source) cell. If you select a blank value, the table is not populated.
- In the left pane, select a table under Harmony Enterprise Views (destination). This populates the right pane with mapped columns for the selected table. In the right pane, select a cell under Client Column Name. This displays a drop-down list of available columns from the database you are importing.
Note: For well information, you can assign a field to more than one column. The Production History table does not have to be mapped. To download the View Definitions, see the Excel file.
7. To set your units, first resolve any errors in the right pane by clicking the Client Column Name cell, and selecting from the drop-down list. Then, click the Units cell, and select from the drop-down list. Click Next. (Errors are displayed in red text and warnings are displayed in orange text.)
Your source tables, source columns, and unit mappings are saved for this database connection, and are available for any user who connects to this source through the same Harmony Enterprise database.
8. In the Well Linking Criteria dialog box, select the attributes you want to use for linking wells; then click Next.
Note: The attributes you select for linking are saved for the current database connection only.
If there is no data in any of the columns you selected for well linking, the Entity Header Data Valuation dialog box opens, and it lists the columns with no data. You can change your mapping, change your well linking, or import anyway.
9. In the Set Up Filters dialog box, click Add to create a filter to restrict which wells are imported. If you do not enter any filters and click Next, all wells in the data source can be viewed and imported.
10. To create a filter, click Add. In the Filter a Column dialog box, select your filter from the Filter Column drop-down list, and then type / paste your values (lowercase or uppercase — filtering is case insensitive), or select from the checkboxes. Click OK; then click Next.
The validation of your filtering values is handled in the next step of the wizard, and your filters are saved for your database connection (not shared with others).
11. In the Select Wells to Import dialog box, a tree structure can be created to view available wells. To build a tree structure, click the Tree Hierarchy icon (
) and select attributes.
By default, all wells are selected. To exclude wells from import, click the checkboxes to deselect them. To see a preview of the production data, click the well's name. Click Next.
The wells you selected for import are saved for your database connection.
Note: When importing data with an irregular frequency (for example, WellTest data or synthetic data with a logarithmic time track), or all shut-in periods reported, click the Continuous Time Track checkbox. For more information, see continuous time track.
12. In the Select Analyses to Import dialog box, select the decline curves you want to import. Click Next.
13. In the Import Options dialog box, options are displayed for updating the data of existing wells, auto-calculating sandface pressures, reducing data, and scheduling well updates. To override the global settings on a one-time basis, select your data options from the drop-down lists. For more information on these options, see updating data (set in the Options dialog box). To automatically import data, see scheduling well updates.
14. Click Import (or Finish in the case of scheduled imports).
15. Review your merge options in the Confirm Import Merge Options dialog box. To change your settings, click the Options icon (
), which opens the Options dialog box. To proceed without make changes, click OK.
The database wizard remembers your last database connection, and it is automatically selected the next time you run the wizard.