Exporting data from Axiom

Using an export utility, you can export data from an Axiom table to an external database or to a delimited file.

When you create an export, you specify a client-defined table in Axiom from which to export data. You can export all of the data in the table, or you can limit the data by selecting columns to export or by defining a data filter. Then, you define the destination properties, such as connection information for the target database and table, or the name and location of the destination file. For Axiom Cloud systems, a remote data connection is used to access the local target for the export.

When an export is executed, Axiom extracts the data from the source table in the Axiom database, and then creates or updates the destination table in the target database or creates the destination file.

NOTES:  

  • The ability to export data to a delimited file using an export utility is only supported for Axiom Cloud systems using a remote data connection. As an alternative, on-premise systems can use the File Processing feature instead.

  • Export utilities do not have any means of transforming data as part of the export; however this can be accomplished in conjunction with an import utility. For more information, see Transforming export data.

Export utility alternatives

The following features can be used as alternatives to export utilities:

  • File Processing: The File Processing feature supports the ability to create a delimited export file, using the Export to File processing option. Instead of extracting data directly from a table, the desired data is first populated into an Axiom report, and then extracted from that report. The data can be manipulated within the report as needed before it is extracted. For more information, see Setting up file processing: Export to file.

  • OData API: The Axiom OData API can be used in custom web solutions to access data from the Axiom database. Standard OData syntax is used to query data from specified tables, then the data is returned in JSON format. For more information, see OData API.