Oracle Non-Spatial Writer Parameters

Add Named Database Connection: Named Connections store (in a central location) authentication information associated with a user.

For information about setting up and using named connections, please see:

Using Named Database Connections

Specifies the Oracle database to connect to. This may be a Net Service Name defined in tnsnames.ora or an Easy Connection Identifier. Either form of connection identifier may be prefixed with username and password information.

[<username>[/<password>]@][//]<hostname>[:<port>]/<service_name>.

[<username>[/<password>]@]<net_service_name>

Enter the username and password to access the service.

The name of the Oracle Workspace Manager workspace that will be used by the writer. All tables will be written using the same workspace. If this parameter is omitted, or left blank, the default LIVE workspace will be used.

If this checkbox is selected (default), the Oracle database connection remains open for other requestors. A persistent connection is useful for workspaces that are long-running, or published using FME Server.

If this checkbox is not selected, the connection to the Oracle database is closed as soon as possible after data processing is complete.