Loading Data Formats

1Integrate can handle spatial data from a number of sources such as an Oracle database, Esri Shapefiles or MapInfo Tab files.

Using FME

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.

To allow 1Integrate to access data that is only available via an FME license, use the following procedure, depending on your operating system:

ClosedConfigure FME on Windows

The following steps are only necessary if FME has not already been added to the system or user’s PATH environment variable in Windows.

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: 1Integrate also requires FME's plugins directory to also be on the PATH.

     Note: The .bat file is located in the 1Integrate directory e.g. \1Integrate[version]\wildfly[version]\bin

@rem add FME to PATHset PATH=[FME path];[FMEpath]/plugins;%PATH%

Where [FME path] is the location where FME is installed (e.g. C:\PROGRA~1\FME).

WebLogic

  1. Stop the WebLogic server(s).

  2. 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).

  3. Edit the contents of the file to contain the following:

    @rem add FME to PATHset PATH=[FME path];%PATH%

    Where [FME path] is the location where FME is installed (e.g. C:\PROGRA~1\FME).

  4. Alter the permissions on setUserOverrides.cmd to allow the WebLogic user to access the file.

  5. Start the WebLogic server(s).

ClosedConfigure 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_PATHexport LD_LIBRARY_PATH="[FME_CORE_PATH]:$LD_LIBRARY_PATH"

Where [FME_CORE_PATH] is the location of the fme/fmecore/ directory.

WebLogic

  1. Stop the WebLogic server(s).

  2. Create a new file called setUserOverrides.sh within the bin directory of your domain (i.e.[domain name]/bin/setUserOverrides.sh).

  3. Edit the contents of the file to contain the following:

    # add FME to LD_LIBRARY_PATHexport LD_LIBRARY_PATH="[FME_CORE_PATH]:$LD_LIBRARY_PATH"

    Where [FME_CORE_PATH] is the location of the fme/fmecore/ directory.

  4. Alter the permissions on setUserOverrides.sh to allow the WebLogic user to execute the file (e.g. chmod 750 setUserOverrides.sh).

  5. 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

ClosedExample (Windows)