The FME Knowledge Site

Databases

Welcome to our Database home page. FME supports just about every well known database format used within the GIS industry. Here you will find information on licensing, connecting, compatibility and generally working with FME to read, write, update, delete and display your non-spatial and spatial database data.

Check out the links to various webinars which talk about interacting with

  • Micorsoft SQL Server
  • Oracle
  • GE Smallworld
  • Intergraph's G/Technology and Geomedia databases.

Take a look in the Transformer Quick Reference Guide for the transformers specifically designed to work with databases - SQLExecutor, FeatureReader, etc. Also look for articles on using the format attributes for updating and deleting pre-existing data.

databases

  • Comparison of FME readers and writers for SDE and Geodatabase
    FME supports a number of readers/writers for SDE and Geodatabase. Which to use depends on the platform you are running on, and what your needs are.
  • Using FME to read or write Comma Separated Value (CSV) data
    FME can be used to read or write non-spatial formats such as CSV files and translate them into other non-spatial formats
  • How to setup an Oracle Instant Client for use with FME
    Explanation of how to setup an Oracle instant client to work with FME and shows various connection options.
  • Using Feature Based Attributes for Database updates
    One of the ways to update features in a database is by using the Feature Based Attribute fme_db_operation. These example workspaces show how to set this up.
  • Using FME to translate Microsoft Excel Files
    FME can be used to read & write MS Excel (XLS) files. The article describes some of the known issues with handling XLS data.
  • Oracle clients for FME running on a 64 bit OS
    Explains the various options available when working with Oracle on a 64 bit OS.
  • How do I connect to my ArcSDE Geodatabase using Direct Connect?
    Instructions for connecting to an ArcSDE Geodatabase using the Direct Connect method in the ESRI ArcSDE reader or writer
  • FME & Smallworld configuration options
    This article summarizes the configuration options for FME when working with different versions of Smallworld
  • Working with Geodatabase Subtypes and Domains
    Here is a brief overview of how to read and write geodatabase subtypes and domains with FME.
  • ESRI Geodatabase reserved words
    Writing to ESRI Geodatabase will generate strange error messages if reserved words are in the writer feature type definition, i.e.: FDO_E_TABLE_DUPLICATE_COLUMN -2147220649 Cannot ...


    • Browse More Articles
  • Working with Geodatabase Subtypes and Domains
    Here is a brief overview of how to read and write geodatabase subtypes and domains with FME.
  • Reading ArcFM Geodatabase data using FME
    Reading ArcFM Geodatabases using FME is possible but requires the ArcFM Object Reader to be installed.
  • Smallworld incremental updates
    The Smallworld FME Translator 4.2.2 (released December 2010) now supports incremental updates to the Smallworld VMDS. It utilizes the fme_db_operation attribute to specify the type of upda...
  • FME & Smallworld configuration options
    This article summarizes the configuration options for FME when working with different versions of Smallworld
  • Teradata Format and FME
    FME can read and write Teradata versions 12 and 13. Teradata client tools must be installed to enable this format.
  • B$ tables don't show up in the Oracle table list pickers
    The B$ tables used by the G/Technology data model don't show up in the Oracle reader table list pickers
  • Working with Top10NL and Oracle Spatial
    Though Oracle Spatial can accomodate multiple geometry columns in a single table, many clients may find it easier to work with the TOP10NL data in a normalized form, that is, one geometry ...
  • Working with Oracle spatial tables from within the Esri ArcGIS products
    It is possible to use Oracle spatial tables from with ArcCatalog, ArcMap and via the Data Interoperability extension if the tables have been setup with the correct spatial index and an ind...
  • Adding metadata entries for Oracle spatial tables or views
    For FME to make a spatial query against Oracle spatial tables or spatial views there needs to be metadata entries in the MDSYS.SDO_GEOM_METADATA table.
  • My Oracle tables are not showing up in the table list
    My Oracle tables are not showing up in the table list picker of my oracle reader


    • Browse More Articles


    Helpful Resources

    Readers and Writers Manual
    Explore this technical details of the database readers and writers within FME

    Transformer Quick Reference Guide
    Check out the Transformers quick reference guide for the transformers that you can use with the database formats.

    Spatial Database Tutorial
    Work through the Spatial Database Tutorial to start your way down the Database training pathway.