Database Connections
|
Database formats include a Database Connection parameter that defines and stores authentication information. For general information about sharing database connections, please see Using Database Connections. Note that Database Connection parameters may differ slightly, depending on context and/or database format. |
Connection
Select an existing connection, or Add Database Connection to define a new connection.
The new connection can be made visible only to the current user, or can be shared among multiple users.
| Adding a Database Connection for Intergraph GeoMedia Access Warehouse and GeoMedia SQL Server Warehouse |
|---|
|
Note that parameter selection may vary, depending on the format and Authentication method. Name
Entering a descriptive name allows you to easily find the connection in future workspaces. The following characters are not allowed in connection names: ^ \ / : * ? " < > | & = ' + % # Server
Specifies the name of the server hosting the Microsoft SQL Server that stores the GeoMedia warehouse. Database
The name of the database to connect to. Authentication
When connecting through a Windows user account, select Windows Authentication. The database can validate the account name and password using the Windows principal token in the operating system. The user account is retrieved by Windows, so if you choose Windows Authentication, the Username and Password parameters are ignored. Select SQL Server Authentication to proceed with specifying login credentials through the Username and Password parameters. Username and Password
When Authentication is set to SQL Server Authentication, enter the username and password to access the database. |
Warehouse Parameters
Overwrite Existing Database
- If this option is unchecked (default) and a database already exists, then tables and features are written to the existing database.
- If this option is checked, any existing database is deleted before writing begins.
If no database exists when writing begins, a new database is created.
Note: After a database is deleted, it cannot be recovered – all data is lost.
GeoMedia Warehouse Version
GeoMedia Warehouse Version
Allows the option to specify the GeoMedia Access warehouse version when creating a new warehouse or when overwriting an existing warehouse.
Microsoft Access Version
MS Access Version
Select the software version of Microsoft Access.
Modification Parameters
Log Warehouse Changes
Select this option to create a log of Warehouse changes.
Spatial Parameters
Spatial Parameters
When creating a new warehouse or overwriting an existing warehouse, native GeoMedia spatial index creation is performed automatically by the writer as long as the input data comes from a known coordinate system that has a corresponding datum mapping in the autodt.ini file under the GeoMedia install folder.
If a spatial index is not desired for the new warehouse, select No.
Text Options
Plain Text
Specifies that features of FME type fme_text are written in plain text.
If this parameter is not selected, the writer formats text objects in rich text format (RTF) to insert the text size as part of the object, since text size cannot be set any other way during translation.
Font Size
Specify the font size in points.