ProjectWise Connector for Oracle

Enterprise Workflows with Oracle Spatial

• Enables seamless enterprise grade integration between Bentley applications and Oracle Spatial
• Live enterprise connection for editing or work disconnected in an extract, modify, post workflow
• A simple wizard can order extractions from Oracle into managed DGN and facilitate posting back to Oracle
• Supports workflows with any MicroStation applications
• Ensures fidelity of the information during MicroStation editing by bringing over relations, validation rules, projections, and other information from Oracle Spatial
• Batch Data loading tools for large conversion projects
• Fully secured server roles based on end users' actions
• Workflow and collaboration managed by Bentley Geospatial Management, an extension of ProjectWise
• Multi-user editing, long transaction, short transaction, locking, and versioning
• Valid time and history management support
• Server infrastructure allows reliable management of large-scale jobs (scale out using a server farm environment)
• Customization through the Geospatial Administrator, as well as Web Services, XML, and .NET languages
  

Native Oracle Support

• Supports native Oracle Spatial geometry data types
• Support of Oracle field types and database views
• Supports text and feature linked text
• Supports Oracle Spatial topology
• Supports Oracle Valid and Oracle History
• Discovers existing Oracle schema
• Transfers the Oracle schema, domain constraints, and other rules to MicroStation environment
• Ensures editing maintains integrity according to Oracle Spatial definition via XML Feature Modeling (XFM)
  

Object Oriented Modeling Tool

• XML Feature Modeling (XFM)
• Model features and their behaviors
• Symbology rules
• Property-driven symbology
• Placement rules
• Editing rules
• Placement library
• User interface
• Spatial and property information can be integrated in a self-contained DGN to support disconnected editing if desired
  

Multi-User Editing via Oracle Standard Versioning

• Works with Oracle Workspace Manager to enable multi-user editing workflows
• Supports long transaction workflows
• Study different scenarios with an optimistic approach, no information is locked from users at any time
• Includes reconciliation tools to resolve conflicts
• Identify, browse, and visualize conflicts
• Visualize all versions connected in the database
• Conflict Inspector assists user in finding and fixing conflicts
• Modifications tracked so only updates posted
• Conflict resolution tools for geometry and attribute conflicts
• Commit reconciled version
  

Short and Long Editing Sessions Using Database Standard Oracle Database Lock

• Works with Oracle session locking for enabling short editing sessions
• Works with Oracle Workspace Manager to enable long editing session where persistent locking is required
  

Time Component Support

• Track Edit History in the Database
• Query back in time—for example: “show me the census blocks as they were on the Census 2000”
• Act on a feature now and have it reflected in the future
• Query in the future—for example: “show me this planned section of highway as it will be in 2012”
• Produce historical maps and reports
• Supports Oracle Valid Time
• Supports Oracle History
  

Data Loading Tool

• Batch loading conversion tool allowing converting DGN, DGN/XFM, DGN/MsLink, and GeoGraphics project to SQL and SQL Loader scripts for batch-loading operation.

Easy-to-Use Connector Administration Tool

• Configure the parameters controlling the workflow
• Specify database connection information and metadata
• Register or un-register Oracle tables as features
• Add end-user connections to the configuration set
  

On-the-Fly Coordinate Systems Transformation

• Transform Oracle database features pertaining to one or more coordinate systems to the system of the target DGN
• Conversion back to original or desired Oracle Spatial coordinate system occurs “on the fly”
• Over 5,500 systems supported by the MicroStation Geospatial Extension are available and 1,000+ supported by Oracle
• User-defined coordinate systems
  

Web Services Based

• Service Oriented Architecture allows performing extraction and posting using standard SOAP Web services
• Creates simplified user interface and then simply call the Web services for performing operations