Refreshing Oracle Data

Ian:

Is there a method to automatically cause a DGN to refresh the Oracle data when it is opened with PowerMap (or Bentley Map)?

What do you mean by 'refresh the Oracle data'?

Ian:

Also how can you save the Oracle connection user name and password in a DGN?

That would, potentially, breach security. If your security can tolerate local storage, then write a VBA macro that preserve the Oracle login settings.

Regards, Jon Summers
LA Solutions

Jon Summers:

Ian:

Is there a method to automatically cause a DGN to refresh the Oracle data when it is opened with PowerMap (or Bentley Map)?

What do you mean by 'refresh the Oracle data'?

I mean that when you open a DGN the data may not be in sync with the Oracle database (someone may have changed the Oracle database and these changes may not be reflected in the DGN), and the data may need requerying.  I want to do the requery process automatically.

Jon Summers:

Ian:

Also how can you save the Oracle connection user name and password in a DGN?

That would, potentially, breach security. If your security can tolerate local storage, then write a VBA macro that preserve the Oracle login settings.

Can the user name and password be stored in the connection XML file (I can secure the file using other methods)?

Hi Ian,

 You can save  your Oracle connection settings as a .ORAX file in the interoperability windows. With this file, you don't need to key-in any user name and password each time. It stills save into the file. You can also define an Oracle database connection through schema in GSA.

This is extract from Bentley Map V8i Help file :

Working with a Defined Spatial Project
A spatial project is defined in the Bentley Geospatial Administrator by the administrator who registers features found in an Oracle database. If the Oracle source is open in the Administrator, you can open the source in Bentley Map through the Interoperability dialog box.

To import with a spatial project

1. Open your project in Bentley Map .
2. Select File > Open Oracle Spatial.
   The Interoperability dialog box opens.
3. Right-click on the Oracle module and select Open Graphical Source.
   The features registered in the database display.
4. You can adjust the feature settings just like Importing GIS data types, except for symbology. Project features are read-only so symbology cannot be changed.
5. Right-click on the database import and select save to save your Oracle connection settings as a .orax file.

  HTH,

Sebastien

Hi Sebastian,

I have saved the .orax file from Bentley Map, but it is not saving the connection password.  Can you tell me the XML property that should be set.

Cheers Ian

Sorry Ian, it's my mistake, we cannot save the password of an Oracle connection. As said Jon Summer: "That would, potentially, breach security" and Oracle do not permit that.... 

 I'm so sorry, I didn't mean to lead you on.

No offence.

Sebastien