AX1050

Transforming export data

Export utilities do not provide any method for manipulating or transforming the data to be exported—data is exported as is. If you need to transform data before exporting, you can do the following:

• Set up an import utility that imports data from an Axiom table to another Axiom table (the source table for the export). This import can transform the data as needed.
• Set up an export utility that exports data from the second table (the destination table for the import) to the target external database or delimited export file.
• Set up a Scheduler job that performs the import first, followed by the export. You can then either schedule this job for recurring execution, or you can run the job as needed.

For example, imagine that you want to export data from the BGT2023 table to another system in your organization, and that this data needs to be transformed in some way before it can be exported to the target database. You would first create an import utility that imports data from BGT2023 to another table named something like BGT2023_Export. This import utility would perform all the necessary data transformations. You would then create an export utility that exports data from BGT2023_Export to the target database or export file.

To ensure that dependent utilities are run in sequence, you can create a Scheduler job that runs the import utility before running the export utility. When setting up the import task in the job, make sure that the following setting is disabled: If this task fails, continue executing subsequent tasks. This way if the import task fails, the export task will not be performed.