Data Mapping Tools XtrudeXhumeTM

1
Data Mapping ToolsXtrude/XhumeTM

• Sharing Your Data using WITSML

2
Why use WITSML?

• WITSML is emerging as an oil industry standard.
• Easily acquire data from and provide data to
  Customers, Operators, Drilling Contractors,
  Oilfield Service companies.
• Supported by all (3) of the Major Rigsite
  Services Providers.
• For example implementing real-time drilling
  performance information from a third party
  provider via the internet.

3
Implementing WITSML

• Two helper utilities have been created to
  graphically map information between a database
  and a WITSML document.
• XtrudeTM - XML export tool
• XhumeTM - XML import tool
• Using these tools a developer can add XML
  capability to an existing program with as little
  as 3 lines of code, without extensive XML or
  WITSML knowledge.

4
What is XtrudeTM?

• Tool for exporting data in an XML format composed
  of
• A GUI for creating a mapping.
• A script file of the map.
• An ActiveX DLL for executing the script.
• Using Xtrude the user can create a script that
  can export data from any source (OLE DB
  Compliant) to an XML document based on a selected
  WITSML (or any XML) Schema.
• By default, Xtrude installs with the WITSML
  Schemas loaded into its library of available
  export formats. However, any valid XML schema can
  be added to the programs library.

5
XtrudeTM provides

• Standard WITSML schemas.
• User defined parameters in scripts
• same script can be used to produce multiple
  outputs.
• A graphical database connection wizard.
• A graphical SQL Query Builder wizard to select
  the data to export.
• Macro functions for manipulating the data to
  export.
• A graphical macro editor wizard to aide the
  mapping of data from the database to the selected
  schema.
• Several options for creating the export XML file
• specific file and path
• prompt at runtime
• generated by macro

6
The XtrudeTM Program Interface
7
XtrudeTM process overview
WISTML Schema
Database
Xtrude GUI
XML Document
8
What is XhumeTM?

• Tool for importing data in an XML format composed
  of
• A GUI for creating a mapping.
• A script file of the map.
• An ActiveX DLL for executing the script.
• Using Xhume the user can create a script that can
  import data from any XML document based on a
  selected XML Schema to any destination database
  (OLE DB Compliant).
• By default, Xhume ships with the WITSML Schemas
  loaded into its library of available import
  formats. However, any valid XML schema can be
  added to the programs library.

9
Xhume provides

• A library of existing WITSML schemas
• User defined parameters in scripts
• same script can be used to produce multiple
  imports.
• A graphical database connection wizard to connect
  to the destination database (to import WITSML
  data to)
• A graphical SQL Query Builder wizard to validate
  incoming data
• A macro language for manipulating the data to be
  imported.
• A graphical macro editor wizard to ease the
  mapping of data from the database to the selected
  schema
• Several options for importing an XML file
• specific file and path
• prompt at runtime
• generated by macro

10
The XhumeTM Program Interface
11
XhumeTM process overview
WISTML Schema
XML Document
Xhume GUI
Database
12
Benefits of using XhumeTM/XtrudeTM

• Quickly add XML/WITSML import/export capability
  to existing legacy systems.
• Import/Export XML/WITSML data without extensive
  knowledge of XML/WITSML using a graphical
  interface.
• An embeddable import/export engine used in new or
  existing programs, and can be implemented in as
  little as three lines of code.
• A common interface for reading/writing XML/WITSML
  data.
• Rapid development of XML/WITSML compliance for
  existing database systems

13
Sample uses of XML Data Mapping

• The following slides will show a few sample uses
  of XML to transfer information between data
  systems. The usage of XML/WITSML via
  Xtrude/XhumeTM are not limited to these examples,
  but they demonstrate a few possibilities.

14
Usage Remote Data Acquisition
XML Document
Your Database
Remote Wellsite (data provider)
Xtrude Script
Xhume Script
xEngine DLL
xEngine DLL
Internet
Export Program
Import Program
15
XhumeTM/XtrudeTM Limitations

• Can map only one schema to one XML Document file
  at a time.
• Only one database can be populated with a single
  script.

16
Usage Data Island Transfers
XML Document
Your Master Database
Local (Laptop) Data Store
Xhume Script
Xtrude Script
xEngine DLL
xEngine DLL
LAN/WAN Network
Import Program
Export Program
17
Usage Web Distribution
Your Database
XSLT Style Sheet
Your Remote Users or Customer Access
Xtrude Script
xEngine DLL
Export Program
ASP Website
Internet
XML Document
18
Usage Export to Foreign System
Your Database
Client Database
Xtrude Script
xEngine DLL
XML Document
Removable Media
Export Program
19
Usage Import from Foreign System
Your Database
Client Database
Xhume Script
xEngine DLL
XML Document
Removable Media
Import Program
20
More Information on Xtrude/XhumeTM

• Contact Us at
• David Moran
• Director Applications Development
• Smith Bits
• Ph [phone]
• Ph [phone] (Direct)
• Fax [phone]
• dmoran_at_smith.com
• Yash Gidh
• Snr. Applications Developer
• Smith International, Inc.
• Ph [phone]
• Ph [phone] (Direct)
• Fax [phone]
• ygidh_at_smith.com