About data exports

A database may be configured to export one (or more) tables or an entire database from Amperity. Each data export must be assigned a unique name. A data export must be associated with a configured destination and must be added to an orchestration.

Policies required to run data exports from a sandbox

A data export must be configured within a sandbox by a user who is assigned to the DataGrid Administrator policy, after which users assigned to the DataGrid Operator and Amp360 User policies may add the data export to orchestrations.

This topic describes tasks related to managing data exports in Amperity:

  1. Add data export

  2. Add table export

  3. Add to orchestration

  4. Delete data export

  5. Discard data export

  6. Switch database

  7. Remove table

  8. View data exports

Add data export

Database tables and databases can be sent from Amperity as a data export. A data export is configured from the Customer 360 page, and then added to an orchestration from the Destinations page.

To add a data export

  1. From the Customer 360 page click Configure Exports. This opens the Database Exports page.

  2. Click Create New Export. This opens the Add Export dialog box.

  3. Add the name of the data export, and then click Add. This will add a draft data export to the Database Exports page.

  4. Open the menu for the draft data export, and then select Edit.

  5. From the Database drop-down, select a database.

  6. From the Entities list, select one (or more) database tables to add to the data export.

  7. Click Activate.

Add table export

Tables may be added to an existing data export.

To add tables to a data export

  1. From the Customer 360 page click Configure Exports. This opens the Database Exports page.

  2. Open the menu for a data export, and then select Edit.

  3. From the Entities list, select one (or more) database tables to add to the data export.

    For a single table, click the table. For multiple tables, use click + command for each table to be selected. For all tables click the first table, hold shift, and then click the last table.

  4. Click Activate.

Add to orchestration

An orchestration defines the relationship between query results and a destination, including the location to which those query results will be sent and the frequency at which the orchestration will be run.

To add a data export to an orchestration

  1. From the Destinations page click Add Orchestration. This opens the Add Orchestration dialog box.

  2. From the Object Type drop-down, select Database Export.

  3. Select a destination and complete the rest of the orchestration settings.

  4. Click Save.

Delete data export

Use the Delete option to remove a data export from Amperity. This should be done carefully. Verify that both upstream and downstream processes no longer depend on this orchestration prior to deleting it. This action will not delete the data template or destination associated with the orchestration.

To delete a data export

  1. From the Customer 360 page click Configure Exports. This opens the Database Exports page.

  2. Open the menu for a data export, and then select Delete.

  3. Click Delete to confirm.

Discard data export

A draft data export may be discarded.

To discard a draft data export

  1. From the Customer 360 page click Configure Exports. This opens the Database Exports page.

  2. Open the menu for a draft data export, and then select Discard.

Switch database

The database associated with a data export may be switched to any other database that is available from the Customer 360 page.

To switch databases

  1. From the Customer 360 page click Configure Exports. This opens the Database Exports page.

  2. Open the menu for a data export, and then select Edit.

  3. From the Databases drop-down menu, pick another database.

  4. From the Entities list, select one (or more) database tables to add to the data export.

    For a single table, click the table. For multiple tables, use click + command for each table to be selected. For all tables click the first table, hold shift, and then click the last table.

  5. Click Activate.

Remove table

A table may be removed from an existing data export.

To remove a table from a data export

  1. From the Customer 360 page click Configure Exports. This opens the Database Exports page.

  2. Open the menu for a data export, and then select Edit.

  3. From the Entities list, select one (or more) database tables to remove from the data export.

    For a single table, click the table. For multiple tables, use click + command for each table to be selected. For all tables click the first table, hold shift, and then click the last table.

  4. Click Activate.

View data exports

The Database Exports page shows the status of every data export. This page is accessible from the Configure Exports link on the Customer 360 page.