You must have a Data Engineer role to set input details.
To enter the connection information for the data source:
Open the Data Stores page.
In the Input Details tab, select the data store type from the Data Store Type list.
In the Source Files
field, enter the location of your file(s) or click Upload
to navigate to the file(s)
on your network. All file-based formats that will be read via FME
accept a .zip file containing one or more files to read. The
Bentley MicroStation DGN format also accepts a single unzipped .dgn
file. The Comma Separated Values format accepts a single CSV
file; however, a .zip archive is required if there is more than one
file to read.
Do not close the browser or navigate to another page while the upload
is in progress.
For SQL data stores, enter the location of the data store in the Source Database field.
If the data store will be used in a session that will write
data to Oracle, enter a value in the Coordinate
Reference System field. This value is the Spatial Reference
Identifier (SRID) in the form SRID=[NNNN],
where [NNNN]
is the Oracle SRID.
When
data is read from FME and written to Oracle, if no Oracle-specific
SRID is defined, the Oracle data store will attempt to find one corresponding
to the EPSG code. EPSG codes are a standard way to describe geospatial
coordinate system and are maintained by the European Petroleum Survey
Group.
Click Import to FME Log File if you want to import log information from FME.
To enable automatic validation, select Allow invalid geometries. For more information about this option, see Performing automatic validation.
Select Fix
ring direction and inclusion errors to
enable this option. Selecting this option will, where possible, correct
polygons that do not correctly identify which rings form the outer
boundary and which are holes or that have rings that do not conform
to the OGC standard for clockwise/anti-clockwise direction. This option
is recommended for ESRI Shape format and may be required for some
data in other formats.
For SQL data stores, enter values in the Import
host name, Import username,
and Import password
parameters.
Note: Additional options are available on this page that are specific to FME. For more information about these options, refer to the Safe Software documentation at: http://www.safe.com/fme/format-search/
Click Test Connection to verify the data can be accessed.
To enter the connection information for Oracle data stores:
In the Input Details tab, select Oracle from the Data Store Type list.
Set Username to the schema containing the data.
Set Password to the password for that user.
If required, set the Net Service Name to the identifier with which Oracle or JBoss identifies this database.
If you do not require the Net Service Name, leave the field blank and enter the Host, Port and Service Name. Host is the name of the machine in which the metadata store is created. Port is the port number of the host. Service Name is the Oracle system ID (SID).
To allow invalid geometries, select Allow Invalid Geometries.
Click Test Connection to verify the data can be accessed.