The ProjectWise Connector for Oracle enables seamless information integration between Bentley engineering and mapping applications and Oracle’s 9i and later databases. It allows organization-defined spatial information to be extracted for use in Bentley applications and provides for subsequent posting to Oracle of modifications and changes to the information, The workflow maintains full data integrity and is managed by Bentley Geospatial Management, an extension of ProjectWise or the Bentley Geospatial Server.
The connector is a high-performance server product ideal for organizations that use MicroStation applications with Oracle as their main data repository in integrated engineering and mapping workflows. Information is extracted to the XML-enabled (XFM) environment supported by Bentley Map, Bentley PowerMap and applications built upon them.
The connector is semantically rich; the database schema, domain constraints, and other information needed to maintain the data integrity according to the enterprise definition is extracted along with the spatial and attribution information. If desired, editing can occur in a disconnected mode using target XFM DGNs that contain the attribution and metadata as XML fragments.
Modifications are tracked so that only changes are sent back to Oracle upon completion. All the updates are managed through Oracle versioning via Oracle Workspace Manager, allowing multi-user editing in long-transaction workflows. Reconciliation tools are provided that allow inspection of versions, version reconciliation, conflict visualization, and conflict resolution for both geometric and attribute information.
The ProjectWise Connector for Oracle offers an unbeatable combination of open corporate database integration, powerful content and workflow management via ProjectWise, and Bentley’s robust geospatial applications.
The V8 XM Edition of the Bentley Geospatial products is yet another step forward in offering Oracle related functionality:
• Data is stored as Oracle Spatial standard data with support for both Oracle’s geometry and topology data types.
• Bentley products use Oracle Spatial metadata and coordinate system support to dynamically configure its data management, editing and analysis environments without the need for proprietary schemas, tables, or columns.
• Short and long transactions for safe editing of Oracle data is supported through Oracle standard versioning (using Oracle Workspace Manager).

What’s New: Learn about the new features in ProjectWise Connector for Oracle.
Detailed Feature List: Learn more about ProjectWise Connector for Oracle from Enterprise Workflows with Oracle Spatial to Web Services Based.
Downloads, Specifications, and Support: All the Technical Requirements you need to run ProjectWise Connector for Oracle.
ProjectWise Connector for Oracle Architecture: Discover how Bentley GIS solutions allow a substantial degree of choice and flexibility in configuration and in the data sources that can be used.