\u201cSimplicity is prerequisite for reliability.\u201d\u00a0 Edsger W. Dijkstra<\/em><\/p>\n Transformation Manager\u2019s easy-to-follow Simple Mapping Language (SML) documents the mappings from PPDM to WITML, allowing the user to easily customise the PPDM-to-WITSML transform.\u00a0 This provides a simple and reliable method of data integration.<\/p>\n With Transformation Manager, the user can directly map between columns of the PPDM and XML properties of WITSML (fig 1).\u00a0 Thanks to Transformation Manager\u2019s modelling of WITSML, the transformed data will automatically be placed in a valid XML file.<\/p>\n Figure 1. Mapping with XML indexes<\/p>\n What if it\u2019s not possible to directly map between PPDM and WITSML?\u00a0 Don\u2019t worry; you just add the programming logic to your SML (fig 2).\u00a0 This allows you to customise the values used to populate the WITSML output.<\/p>\n Figure 2. Programming logic<\/p>\n Transformation Manager then effortlessly moves the data from the PPDM database to WITSML XML files.\u00a0 The movement is repeatable and reliable.<\/p>\n Transformation Manager is a mature application and integrates with standard JDBC drivers.\u00a0 When accessing PPDM, Oracle drivers are used, which provide exceptional reliability.<\/p>\n And, using\u00a0 SML, we can introduce ways of validating data.\u00a0 This allows validation issues to be highlighted during the data movement, halting it if required.<\/p>\n Figure 3. Error generation<\/p>\n In Figure 3, the SML will throw an error if PPDM is missing an important value when transforming the data.\u00a0 The error is captured and logged (fig 4).<\/p>\n Figure 4. Thrown error reported<\/p>\n Once you\u2019re happy with the transform mappings and validation rules, they can be reused.\u00a0 Transformation Manager\u2019s Migrator tool ensures that dynamic data movement statistics and analysis are provided.\u00a0 This means that statistics regarding the output, such as rows extracted, may be compared with previous extracts (fig 5).<\/p>\n Figure 5. Transform output log<\/p>\n With Transformation Manager\u2019s simple, yet powerful, SML, complex data movements are possible.\u00a0 This is complemented by the use of standard JDBC drivers and customisable data validation, making Transformation Manager the perquisite for any reliable PPDM to WITSML data movement.<\/p>\n <\/p> Simple mapping syntax<\/h4>\n
<\/p>\n
<\/p>\n
Reliable process<\/h4>\n
<\/p>\n
<\/p>\n
<\/p>\n
Further reading<\/h3>\n\n
<\/ul><\/div>\n