StatMap DataPump

Owned by Robert Sikorski
Last updated: 15 Aug 2024 by Wojciech Mozolewski

Please note

DataPump is a command-line application, therefore, it doesn't have graphic user interface. It means that it cannot be executed on its own, instead, a script file has to be created and executed by a batch file or from Windows Command Prompt console.


The bare minimum that DataPump requires to be able to run any of the simple scripts successfully is providing him with a source and a destination for the job whether it’s import, export or direct migration. Unless otherwise stated DataPump requires datasets to be uncompressed and complete. As far as the more complex scripts go (Collation and Union) the minimum requirements are described in their respective documentation.

Supported file formats:

  • ESRI Shapefile (shp)
  • MapInfo TAB (tab)
  • MapInfo Mid/Mif (mif)
  • OGC Geography Markup Language (gml)
  • Comma Separated Value textfile (csv)

Supported databases:

  • SQL Server 2005 and above
  • PostgreSQL with PostGIS module
  • Oracle 10g and above 

DataPump (aka ETL) Technical Architecture Diagram:


Specification of the server hosting StatMap ETL software:

Hardware requirements:

  •   CPU: 4-cores (more cores recommended)
  •   SuperPI 1M benchmark ~ 20sec
  •   RAM: 8GB+
  •   HDD: 50GB+

Software requirements:

  •   Windows Server 2012R2 or newer
  •   Microsoft .NET Framework 4.8