Refreshing Oracle Data

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 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

Saving Passwords:

I believe that you can accomplish what you desire by setting up the DB connection within the GSA, and launching your Bentley Map session from said XFM schema's workspace. This may or may not also require creation of spatial features within the schema.

Creating the features in the GSA allows me to store the connection information and will refresh the data (but not store the password).  But I was trying to avoid doing it with the GSA if I can.