Open Data Export Centre

The Open Data Export Centre (ODEC) allows you to export data from InfoAsset Manager in a variety of formats. These are:

• Comma and tab separated files
• MapInfo MIF files
• ESRI Shape files
• Access Database (.mdb) format
• Oracle Database (the minimum version of Oracle supported for export without spatial data is Oracle 8i. To export spatial data a minimum version of Oracle 9.2 is required) - see the Exporting Data to Oracle topic for more information.
• SQL Database (the Microsoft OLE DB Provider for SQL Server must be installed in order to export to SQL Server databases) - see the Exporting Data to SQL Server topic for more information.
• GeoDatabase (if you have the appropriate ESRI licence) - see the Exporting Data to GeoDatabase topic for more information.
• XML - see the Exporting Data to XML topic for further information.
• File Geodatabase (if you do not have an ESRI licence) - see the Exporting Data to GeoDatabase topic for more information.
  Note: This option is only available with 64 bit versions of InfoAsset Manager.

You can map the fields in the database onto specific fields in the output files. Data can be manipulated using SQL or a Ruby Script during the export process.

The Open Data Export Centre can be opened in several different ways:

• Right-click on the version controlled item and choose Exportusing Open Data Export Centre from the popup menu
• Choose Exportusing Open Data Export Centre from the Network menu when a network is open