Loading Data Formats using FME
1Integrate can handle spatial data from a number of sources such as an Oracle database, Esri Shapefiles or MapInfo Tab files.
To access other formats such as DWG files or Esri Enterprise geodatabases, 1Integrate uses functionality from Safe Software's FME. To use this capability, you must have FME Desktop installed and available to 1Integrate, with an FME Desktop license available for use.
Note: In order to be editable, tables must have a primary key defined. You can read data from tables that do not have primary keys, but you will not be able to write data back to those tables.
Note: For PostGIS, only tables with at least one geometry column are supported.
To allow 1Integrate to access data that is only available via an FME license, use the following procedure, depending on your operating system:
Configure FME on Windows
Note: The following steps are only necessary if FME has not already been added to the system or user’s PATH environment variable in Windows. However, when using WildFly with AdoptOpenJDK ensure the plugins
path is defined, as detailed below.
Wildfly
On Windows, set the FME_HOME directory to the path in bin\standalone.conf.bat by adding the following lines to the top of the file:
Note: The .bat file is located in the 1Integrate directory e.g. \1Integrate[version]\wildfly[version]\bin
Using AdoptOpenJDK
Note: As of 1Integrate 2.7, 1Integrate only supports AdoptOpenJDK on WildFly installations. Please see the Release Notes for additional information.
@rem add FME to PATH
set PATH=[FME path];[FME path]/plugins;%PATH%
Where [FME path] is the location where FME is installed (e.g. C:\PROGRA~1\FME).
WebLogic
-
Stop the WebLogic server(s).
-
Create a new file called setUserOverrides.cmd within the bin directory of your domain, if it does not already exist (i.e.[domain name]/bin/setUserOverrides.cmd).
-
Edit the contents of the file to contain the following:
@rem add FME to PATH
set PATH=[FME path];%PATH%
Where [FME path] is the location where FME is installed (e.g. C:\PROGRA~1\FME).
-
Alter the permissions on setUserOverrides.cmd to allow the WebLogic user to access the file.
- Start the WebLogic server(s).
Configure FME on Linux
Wildfly
Set the FME_CORE directory to the LD_LIBRARY_PATH in bin/standalone.conf by adding the following lines to the top of the file:
# add FME to LD_LIBRARY_PATH
export LD_LIBRARY_PATH="[FME_CORE_PATH]:$LD_LIBRARY_PATH"
Where [FME_CORE_PATH] is the location of the fme/fmecore/ directory.
WebLogic
-
Stop the WebLogic server(s).
-
Create a new file called setUserOverrides.sh within the bin directory of your domain (i.e.[domain name]/bin/setUserOverrides.sh).
-
Edit the contents of the file to contain the following:
# add FME to LD_LIBRARY_PATH
export LD_LIBRARY_PATH="[FME_CORE_PATH]:$LD_LIBRARY_PATH"
Where [FME_CORE_PATH] is the location of the fme/fmecore/ directory.
-
Alter the permissions on setUserOverrides.sh to allow the WebLogic user to execute the file (e.g. chmod 750 setUserOverrides.sh).
- Start the WebLogic server(s).
Esri Enterprise Geodatabase (only required for WebLogic installations)
The following changes need to be made to the setUserOverrides.cmd (Windows) or setUserOverrides.sh (Linux):
- Add the SDEHOME path variable
- Add the database client path to the PATH
Note:
SDEHOME must not contain spaces in the path. Make sure that short paths are enabled on the operating system (e.g. PROGRA~2) or copy the following dll files (from C:\Program Files (x84)\ArcGIS\DesktopV\bin64) to a location without spaces :
- sde.dll
- sg.dll
- pe.dll
- xerces_c3_1.dll
Example (Windows)
@rem set FME path
set PATH=C:\PROGRA~1\FME\;C:\app\Administrator\product\12.1.0\client_1;%PATH%
set SDEHOME=C:\PROGRA~2\ArcGIS\Desktop10.4\bin64
SQL Server Spatial Data (only required for WebLogic installations)
An additional driver is required in order for FME to read Microsoft SQL Server data on WebLogic 12.1.3.
Configure SQL Server for spatial data support
-
Download the following driver from Microsoft, and place it in an accessible location: sqljdbc4-4.0.2206.100.jar
-
In the bin directory of the 1Integrate WebLogic domain, create a file called setUserOverrides.cmd
-
Edit the setUserOverrides.cmd file, adding the location of the sqljdbc driver as part of the PRE_CLASSPATH:
@rem include the sqljdbc driver as part of the pre class path
set PRE_CLASSPATH=%locationOfTheDriver%\sqljdbc4-4.0.2206.100.jar
@rem set FME path as part of the path
set PATH=C:\PROGRA~1\FME\;%PATH%
-
Restart all servers, including Admin Server and Node Manager for the pre-class path to be loaded.