Petrel Play and Prospect Assessment 2016

Connecting with the GeoX database

Schlumberger Public
Copyright Notice
Copyright © 2016 Schlumberger. All rights reserved.
This work contains the confidential and proprietary trade secrets of Schlumberger and may not be copied or stored in an
information retrieval system, transferred, used, distributed, translated or retransmitted in any form or by any means,
electronic or mechanical, in whole or in part, without the express written permission of the copyright owner.

Trademarks & Service Marks

Schlumberger, the Schlumberger logotype, and other words or symbols used to identify the products and services
described herein are either trademarks, trade names or service marks of Schlumberger and its licensors, or are the
property of their respective owners. These marks may not be copied, imitated or used, in whole or in part, without the
express prior written permission of Schlumberger. In addition, covers, page headers, custom graphics, icons, and other
design elements may be service marks, trademarks, and/or trade dress of Schlumberger, and may not be copied,
imitated, or used, in whole or in part, without the express prior written permission of Schlumberger. Other company,
product, and service names are the properties of their respective owners.

Schlumberger Private – Customer Use

Petrel® is a mark of Schlumberger.
An asterisk (*) is used throughout this document to designate other marks of Schlumberger.

Security Notice
The software described herein is configured to operate with at least the minimum specifications set out by
Schlumberger. You are advised that such minimum specifications are merely recommendations and not intended to be
limiting to configurations that may be used to operate the software. Similarly, you are advised that the software should
be operated in a secure environment whether such software is operated across a network, on a single system and/or on
a plurality of systems. It is up to you to configure and maintain your networks and/or system(s) in a secure manner. If
you have further questions as to recommendations regarding recommended specifications or security, please feel free to
contact your local Schlumberger representative.

Petrel Play and Prospect Assessment 2016 – Connect with GeoX database 2
Contents
Petrel – GeoX integration ............................................................................................................................................. 4
Scenario 1. Full installation ......................................................................................................................................... 6
Install the database and GeoX 2016............................................................................................................................. 6
Install Petrel 2016.......................................................................................................................................................... 6
Connect with the GeoX database ................................................................................................................................. 6
Scenario 2. Upgrade to GeoX 2016 ............................................................................................................................ 10
Upgrade the GeoX database ....................................................................................................................................... 10
Install Petrel 2016........................................................................................................................................................ 10

Schlumberger Private – Customer Use

Connect with the GeoX database ............................................................................................................................... 10
Scenario 3. Install GeoX personal edition .............................................................................................................. 11
Install GeoX personal edition ...................................................................................................................................... 11
Install Petrel 2016........................................................................................................................................................ 11
Connect with the GeoX database ............................................................................................................................... 12
How to verify which SQL server installation you have ....................................................................................... 14

Petrel Play and Prospect Assessment 2016 – Connect with GeoX database 3
Petrel – GeoX integration
Play and prospect assessment (PPA) complements existing Petrel Exploration Geology processes. It offers functionalities
for map-based play and prospect assessment, integrating workflows, from data to geologic analysis, to achieve
consistent and auditable assessment of exploration opportunities.

The goal is to expand the current Exploration Decision Support software by offering integrated assessment and
comparison of prospects in plays and part-plays, respective geological risk elements (chance of adequacy) and volumes
in Petrel. In 2016.1, PPA introduces conventional assessment, a key workflow to previous versions. The segment analysis
capability implemented in PPA replicates the non-depth dependent GeoX volume methods. The GeoX tools (risk models)
are integrated through the common GeoX database.

PPA has a one-way communication from Petrel to GeoX, therefore it can write assessment unit (AU) inputs and results
(geopolygon attributes) in the GeoX database. Through this communication, you can access PPA workflow limited data,
such as customer risk models and enabled distributions from the GeoX database.

The GeoX database connection provides the following features:

Schlumberger Private – Customer Use

• Corporate store for decision support systems
• Corporate database for managing exploration portfolio opportunities
• Best practices implementation
• Secure maintenance of sensitive data
• Usability and traceability
• Link to other decision support tools within GeoX, such as FullCycle, Portfolio, Play and Reserve Tracker.

Access to PPA assessments stored in the GeoX 2016 database is controlled by GeoX user rights, so the system provides
full security of exploration data and full traceability of exploration assessment workflows.

PPA offers two main data storage options:

1. Standalone mode: for PPA users without a GeoX 2016 installation. Assessments are saved in Petrel.
2. GeoX mode: for PPA users with a GeoX 2016 installation. Assessments can be saved in the GeoX database and
also in Petrel.

Note: You can also choose standalone mode even if you have a GeoX 2016 installation. If you decide not to connect to
GeoX and use a PPA default risk model, the assessment can only be saved in Petrel.

To establish communication with the database, you must have:

• A database installed for GeoX 2016

• Petrel 2016 installation
• GeoX 2016 installation

Note: Connection with the database only works with GeoX 2016. Make sure you are connecting with the correct
database and not with another database, such as GeoX 2015 or previous versions.

Petrel Play and Prospect Assessment 2016 – Connect with GeoX database 4
The following sections describe three possible scenarios of installing and setting up the connection:

Scenario 1. Full installation – database, Petrel 2016 and GeoX 2016.

Scenario 2. Upgrade to GeoX 2016 – upgrade previous GeoX version.

Scenario 3. Install GeoX personal edition – only applicable for Schlumberger.

Schlumberger Private – Customer Use

Petrel Play and Prospect Assessment 2016 – Connect with GeoX database 5
Scenario 1. Full installation
You must install the GeoX database, Petrel 2016 and GeoX 2016 if you do not have Petrel or GeoX installed on your
computer.

Install the database and GeoX 2016

To install the database (SQL Server or Oracle) and GeoX 2016, refer to the instructions of the GeoX 2016 Installation
guide. Log in to Support to access the documentation.

Note: You must have an account to have full access to information about the products and to perform software
downloads.

Navigate to Products > GeoX > News (on the right hand side) > GeoX 2016 now available > Software Download
Information > documentation.

Install Petrel 2016

Schlumberger Private – Customer Use

To install Petrel 2016, refer to the instructions located in the Petrel 2016 Installation Guide. Log in to Support to access
the documentation.

Note: You must have an account to have full access to information about the products and to perform software
downloads.

Navigate to Products > Petrel > News (on the right hand side) > Petrel 2016 now available > Software Download
Information > documentation.

Connect with the GeoX database

PPA has a one-way communication from Petrel to GeoX, so it can write assessment unit (AU) inputs and results
(geopolygon attributes) in the GeoX database. Through this communication, you can access PPA workflow limited data,
such as customer risk models and enabled distributions from the GeoX database. Access to PPA assessments stored in
the GeoX 2016 database is controlled by GeoX user rights, so the system provides full security of exploration data and
also full traceability of exploration assessment workflows.

Before you connect with the GeoX database in Petrel, you must define the risk model you want to use in GeoX 2016. Go
to Tools > Options (in the Menu bar), Administrator – Petrel tab and select the risk model you want to use.

Petrel Play and Prospect Assessment 2016 – Connect with GeoX database 6
 Schlumberger Private – Customer Use
You must have a valid profile to connect to the GeoX database. You can connect by giving your credentials or with single
sign-on. Your credentials will be in a cache and are deleted when you close Petrel. You must provide your credentials
each time you open a Petrel project so you can connect and save data to the database.

1. Click on the GeoX icon in the Decision Support domain tab in Petrel, and select Log in.

2. To add a new profile, click on Add new and fill the fields accordingly.

• Name: give the profile a name.

• Type: select the database type (Oracle or SQL Server).
• Host name: enter your host COMPUTER NAME.
• Service name: enter the name of the server instance, for example. SQLEXPRESS or ORACLE
Notes: - if you are using the SQLEXPRESS server the service name MUST be FILLED
- If you are using the FULL installation of SQL server the service name MUST be EMPTY
- If you are using the ORACLE server the service name MUST be FILLED
• Database name: enter the name of the database you want to connect to.
• Schema name: enter the schema name for the corresponding database.
• Authentication: select the type of authentication. For database authentication, you must type your user profile
name and password.

The examples below show how the profile should be setup according to your server.

Petrel Play and Prospect Assessment 2016 – Connect with GeoX database 7
Using the SQLEXPRESS server:

Using the FULL SQL SERVER installation:

Schlumberger Private – Customer Use

Using the ORACLE server:

After you create the profile, click OK to log in. To verify that you are logged in, open the Assessment setup process and
review the status of the connection and the company risk model used under Define risk elements.

Petrel Play and Prospect Assessment 2016 – Connect with GeoX database 8
 Schlumberger Private – Customer Use

Petrel Play and Prospect Assessment 2016 – Connect with GeoX database 9
Scenario 2. Upgrade to GeoX 2016
This scenario applies when you have an old version of GeoX installed on your computer (2015 or older), an upgrade is
required, and you must also install GeoX 2016 and Petrel 2016.

Upgrade the GeoX database

If you have an existing GeoX installation and a database running, follow the instructions in the GeoX 2016 Installation
Guide to perform the upgrade. Log in to Support to access the documentation.

Note: You must have an account to have full access to information about the products and to perform software
downloads.

Navigate to Products > GeoX > News (on the right hand side) > GeoX 2016 now available > Software Download
Information > documentation.

Install Petrel 2016

Schlumberger Private – Customer Use

To install Petrel 2016, refer to the instructions located in the Petrel 2016 Installation Guide. Log in to Support to access
the documentation.

Note: You must have an account to have full access to information about the products and to perform software
downloads.

Navigate to Products > Petrel > News (on the right hand side) > Petrel 2016 now available > Software Download
Information > documentation.

Connect with the GeoX database

Follow the steps described in Connect with the GeoX database to establish communication with the database from
Petrel.

Petrel Play and Prospect Assessment 2016 – Connect with GeoX database 10
Scenario 3. Install GeoX personal
edition
This scenario is only applicable for Schlumberger employees or client testing performed with a Schlumberger machine.

Install GeoX personal edition

This scenario applies when you have a GeoX personal installation on your computer. The GeoX software is packaged as a
single executable set-up-file available for download in the Software Download Center (under Foundation Products). The
file name is GeoX (version) Personal Edition Package.

Note: If you are a new user to the Software Download Center, you must register before you can download products.

Upgrade an existing GeoX personal edition

1. Download and install the GeoX 2016 Personal Edition Package.

Schlumberger Private – Customer Use

2. Start GeoX and select Setup from the logon window.
3. Choose the correct profile and click Connect to connect to the database. After connecting to the database, the
message ***Upgrade required*** appears under Database details.
4. Click Action>> Upgrade database.
5. Click Upgrade all.

Note: For more information on the database upgrade, read the GeoX 2016 Installation Guide. Log in to Support to access
the documentation. Navigate to: Products > GeoX > News (on the right hand side) > GeoX 2016 now available > Software
Download Information > documentation.

Note: You must have an account to have full access to information about the products and perform downloads.

Install GeoX personal edition

1. Download and install the GeoX 2016 Personal Edition Pre-Install package. This installer is only required to install
once and works for multiple versions of a personal edition.
2. Download and install the GeoX 2016 Personal Edition Setup.
3. Start Petrel and establish communication with the database (see Connect with the GeoX database.)

Install Petrel 2016

To install Petrel 2016, refer to the instructions located in the Petrel 2016 Installation Guide. Log in to Support to access
the documentation.

Note: You must have an account to have full access to information about the products and to perform software
downloads.

Petrel Play and Prospect Assessment 2016 – Connect with GeoX database 11
Navigate to Products > Petrel > News (on the right hand side) > Petrel 2016 now available > Software Download
Information > documentation.

Connect with the GeoX database

Before you connect with the GeoX database in Petrel, you must define the risk model you want to use in GeoX 2016. Go
to Tools > Options (in the Menu bar), Administrator – Petrel tab and select the risk model you want to use.

Schlumberger Private – Customer Use

You must have a valid profile to connect to the GeoX database. You can connect by giving your credentials or with single
sign-on. Your credentials will be in a cache and are deleted when you close Petrel. You must specify your credentials
each time you open a Petrel project so you can connect and save data to the database.

1. Click on the GeoX icon in the Decision Support domain tab in Petrel, and select Log in.

2. To add a new profile, click on Add new and fill the fields accordingly.

• Name: give the profile a name.

• Type: select the database type (Oracle or SQL Server).
• Host name: (localdb)\GeoX
• Service name: leave it EMPTY.
• Database name: enter the name of the database you want to connect to.
• Schema name: enter the schema name for the corresponding database.
• Authentication: select the type of authentication. For database authentication, you must type your user profile
name and password.

Petrel Play and Prospect Assessment 2016 – Connect with GeoX database 12
 Schlumberger Private – Customer Use
Once the profile is created, select it from the drop down list and press OK. To verify that you are logged in, open the
Assessment setup process. Under the section Define risk elements, you can see the status of the connection and the
company risk model that is being used.

Petrel Play and Prospect Assessment 2016 – Connect with GeoX database 13
Verify which SQL server installation
you have
To ensure that you create the correct profile in Petrel, you must verify which SQL server installation you have from the
following:

• SQLEXPRESS
• Standard SQL server installation (full installation)

1. Open Microsoft SQL Server Management Studio.

2. After connecting, right-click the first topic and go to Properties.

Schlumberger Private – Customer Use

3. Check the information in the Product row to verify the type of SQL server installation you have.

Petrel Play and Prospect Assessment 2016 – Connect with GeoX database 14
 Schlumberger Private – Customer Use

Petrel Play and Prospect Assessment 2016 – Connect with GeoX database 15