Database Connection
Connections store authentication information. For general information about sharing database connections, please see Using Database Connections.
Note that different subsets of the Database Connection parameters below are made available in different contexts.
Connection
This parameter specifies a database connection for the reader through a drop-down menu. The Add Database Connection option in the menu allows you to create a new connection. The connection requires a name that describes the connection.
Note: The following characters are not allowed in connection names: ^ \ / : * ? " < > | & = ' + % #
The new connection can be made visible only to the current user, or can be shared among multiple users.
Connection Parameters
Host
This specifies the machine running Ingres database as either an IP address or host name.
Port
When connecting remotely, this specifies the TCP/IP port on which to connect to the Ingres database service. The default port is II7, which maps to a port number dynamically chosen by the Ingres service when it was installed.
Database
This specifies the name of the Ingres database.
Username and Password
Enter the username and password to access the database, user account, or wherever authentication is required.
Advanced Settings
Batch Inserts
If this option is selected, the writer inserts data into the database in bulk inserts of 1000 records. Batch inserts may facilitate data loading when communicating with FME Workbench via FME Server.
Table Creation
Spatial Column Name
When creating a new table, the name of the column to be created that will hold the spatial data.
Create
Generic Spatial Columns
This setting applies at generation time, not at translation time.
By default, this option is not selected, so it will create geometrically constrained geometry columns on the destination tables. For example, a POINT geometry table is restricted only to points.
By selecting this option, you can create generic or non-constrained geometry column types. This means you can insert multiple geometry types into one table. Specifically, the geometry column is created to have the generic type GEOMETRY and there are no constraints placed on the geometry types allowed.