WITSML Adapter Samples

Contents

About the Samples
Samples Setup
Running the Log Sample
Running the Well Sample
Running the Wellbore Sample
Running the Trajectory Sample
Running the Web Server Sample
Running the Get Log Data Chunks Sample
Importing This Sample into StreamBase Studio
Sample Location

About the Samples

In these samples, the TIBCO StreamBase® Adapter for WITSML works to read, write, update, and delete data from a Wellsite Information Transfer Standard Markup Language (WITSML) store.

A running WITSML server must be available for these samples to run against.

In order to query for specific elements use the input schema and send in a tuple with any value to be queries as non null. For instance to query for a specific well in the Well.sbapp you can run the sample and add a tuple on the ReadWellIn input and then specify the uid value and leave all the other fields blank. This is equivalent to a SQL query of Select schema fields from well where uid = myuid.

Samples Setup

Before running the samples, open the supplied sbd.sbconf and edit your applicable parameters for your WITSML server.

  1. SERVICE_URI: This is the full URI to your WITSML store.

  2. ENABLE_AUTH: Set this value to true if authentication is required for your WITSML store. Otherwise, leave as false.

  3. USER: Set this value to the required user name for your WITSML store. Otherwise leave as blank.

  4. PASS: Set this value to true for the required password for your WITSML data store. Otherwise leave as blank.

  5. TIMESTAMP_FORMAT: The timestamp format used by the WITSML server. The date format supplied must be a valid pattern for SimpleDateFormat

  6. REST_TIMESTAMP_FORMAT: The timestamp format used when sending requests from the web page with a date time.

  7. DELETE_ENABLED: By default the samples filter out delete requests for data safety. If you want actually delete data set this value to true.

Running the Log Sample

  1. In the Package Explorer view, double-click to open Log.sbapp. Make sure the application is the currently active tab in the EventFlow Editor.

    This sample uses two sub modules that perform operations on log data received from the server:

    1. convert-log-data-to-key-value-pair.sbapp

      This module is an example of how to convert the returned log data into key-value pairs. The data includes the data value along with the mnemonic associated with it. This module can also be updated to include the entire logCurveInfo tuple with each piece of data by changing the AGGREGATE_DEFINITION in the Parameters tab to one of the supplied TUPLE_WITH_LOG_CURVE_KEY or TUPLE_WITH_MNEMONIC_KEY.

    2. MnemonicReplacements.sbapp

      This module is an example of how to replace any mnemonic in the logCurveInfo with predefined mnemonics. This can be useful to standardize mnemonics across multiple systems. A CSV file of key-value pairs, Mnemonics.csv, which contains the replacements to use, is read in at system startup.

  2. Click the Run button. This opens the SB Test/Debug perspective and starts the application.

  3. In the Manual Input window, select an input stream to perform its associated action. Each input stream is labeled with the action it performs. For example, DeleteLogIn performs a delete operation based on the supplied data.

  4. Enter some data if required for the input stream and click the Send Data button to send a tuple into the system.

  5. In the Application Output view, look for the status and data tuples for the selected operation.

  6. When done, press F9 or click the Stop Running Application button.

Running the Well Sample

  1. In the Package Explorer view, double-click to open Well.sbapp. Make sure the application is the currently active tab in the EventFlow Editor.

  2. Click the Run button. This opens the SB Test/Debug perspective and starts the application.

  3. In the Manual Input window select an input stream to perform its associated action. Each input stream is labeled with the action it performs. For example, DeleteWellIn performs a delete operation based on the supplied data.

  4. Enter some data if required for the selected input stream, and click Send Data to send a tuple into the system.

  5. In the Application Output view, look for the status and data tuples for the selected operation.

  6. When done, press F9 or click the Stop Running Application button.

Running the Wellbore Sample

  1. In the Package Explorer view, double-click to open Wellbore.sbapp. Make sure the application is the currently active tab in the EventFlow Editor.

  2. Click the Run button. This opens the SB Test/Debug perspective and starts the application.

  3. In the Manual Input window, select an input stream to perform its associated action. Each input stream is labeled with the action it performs. For example, DeleteWellboreIn performs a delete operation based on the supplied data.

  4. Enter some data if required for the selected input stream, and click Send Data to send a tuple into the system.

  5. In the Application Output view, see the status and data tuples for the selected operation.

  6. When done, press F9 or click the Stop Running Application button.

Running the Trajectory Sample

  1. In the Package Explorer view, double-click to open Trajectory.sbapp. Make sure the application is the currently active tab in the EventFlow Editor.

  2. Click the Run button. This opens the SB Test/Debug perspective and starts the application.

  3. In the Manual Input window, select an input stream to perform its associated action. Each input stream is labeled with the action it performs. For example, DeleteTrajectoryIn performs a delete operation based on the supplied data.

  4. Enter some data if required for the selected input stream, and click Send Data to send a tuple into the system.

  5. In the Application Output view, see the status and data tuples for the selected operation.

  6. When done, press F9 or click the Stop Running Application button.

Running the Web Server Sample

  1. In the Package Explorer view, double-click to open webserver.sbapp. Make sure the application is the currently active tab in the EventFlow Editor.

  2. Click the Run button. This opens the SB Test/Debug perspective and starts the application.

  3. Open a web browser and set the location to http://localhost:8080. From there you can query for wells, wellbores, and logs by specifying some criteria. The web server sample also uses port 8081 for all REST data requests.

  4. When done, press F9 or click the Stop Running Application button.

Running the Get Log Data Chunks Sample

This sample shows how you can create a query with multiple log requests in a single query call to the server. Each query made to the server requests a specific amount of data, depending on whether it is an index log or index time log. The query size can be adjusted by going to the Parameters tab and adjusting:

  • ReadIndexSize: The number of records to request for each log that is index based.

  • ReadTimeIndexSeconds: The number of seconds of data to request for each log that is time based.

  1. In the Package Explorer view, double-click to open GetLogDataChunks.sbapp. Make sure the application is the currently active tab in the EventFlow Editor.

  2. Click the Run button. This opens the SB Test/Debug perspective and starts the application.

  3. When the application starts, it sends a query to the server to fetch all the start indexes for all the logs available and stores them in a Query Table.

  4. In the Manual Input window, select the ReadCurrentLogs input stream.

  5. Click Send Data to send a tuple into the system.

  6. In the Application Output window, look for the status and data tuples for the selected operation.

  7. When done, press F9 or click the Stop Running Application button.

Importing This Sample into StreamBase Studio

In StreamBase Studio, import this sample with the following steps:

  • From the top menu, select File → Load StreamBase Sample.

  • In the search field, enter witsml to narrow the list of samples.

  • Select WITSML Read/Write/Delete adapters for well, wellbore, trajectory, and log from the Petroleum Industry Adapters category.

  • Click OK.

StreamBase Studio creates a single project containing the sample files.

Sample Location

When you load the sample into StreamBase Studio, Studio copies the sample project's files to your Studio workspace, which is normally part of your home directory, with full access rights.

Important

Load this sample in StreamBase Studio, and thereafter use the Studio workspace copy of the sample to run and test it, even when running from the command prompt.

Using the workspace copy of the sample avoids permission problems. The default workspace location for this sample is:

studio-workspace/sample_adapter_embedded_witsml

See Default Installation Directories for the default location of studio-workspace on your system.