The services provided by the add-on allow you to export data from your EBX® repository. The location you initiate the export from determines the source for the export. For instance, running the export service from a table's Actions menu, sets the table as the source. Running the service from a dataset's Actions menu sets its tables as sources. Overall, steps to complete these procedures are the same, except some details such as mapping differ. As outlined below, the export process includes:
Specifying the source file name and any format-specific options for CSV and Excel export, or selecting the desired target location when exporting SQL. See Exporting a table for instructions. Exporting to SQL is supported at the table level only and requires administrative configuration.
Defining any required mappings or transformations. The add-on automatically generates a map of all source fields to target fields. If your circumstances require it, use the add-on's drag-n-drop functionality to update the mappings. If you want to apply transformations to your data, you can use built-in functions to modify data during export. For more information on the topics of mapping and transformations, see Map and transform overview.
Saving settings as a template. When export operations require the use of transformations or custom mappings, you can use templates to store these settings. This alleviates you from having to redo the same tasks each time you perform a specific export.