Skip to main content

Fields

When you add a table to an extraction, all its source fields are included by default. You can refine your configuration by selecting only the fields you need. Removing fields can improve synchronization speed and reduce storage requirements in the destination.

By default, every added table includes all fields from the source. To refresh the field list, select Refresh in the upper-right corner of the page.

tip

To preview and filter data for a specific field, enable Data Preview when viewing a table. Select a field in the list and choose the magnifier icon in the upper-right corner.

Column overview​

ColumnDescrciption
Field SourceDisplays the source field name from the connected data source.
Field DestinationDisplays the destination field name. To change it, select the cell and enter a new name. The name cannot match an existing field in the destination table or one not created by the DataSync module. Fields used by an index cannot be renamed.
Type SourceShows the data type of the field in the source table.
Type DestinationShows the destination field data type. To change it, select a new value from the drop‑down list.
SyncIndicates fields synced between the source and destination. Clear the checkbox to remove a field from synchronization. Removing a field also removes it from any index; if no fields remain, the index is deleted.
Unique KeyIdentifies fields used as unique keys. DataSync selects these automatically if provided by the source. Indexes must include all unique keys or Validate and Build fails.
Track KeyDisplays the tracking key field used in incremental loads. The tracking key depends on the tracking type chosen when creating the source connection. See Connections for more details.
IndexesShows indexes linked to the field. Select the link to view or edit them.
TransformIndicates if a transformation is applied to the field. Select the pencil icon to choose an existing transformation or the magic wand icon to create one. See Transformations for more details.

Edit a field​

  1. From the welcome screen or left navigation pane, select Extractions.
  2. Select an extraction from the list.
  3. Click the link under the Tables column.
  4. Select a table, then click the link under the Fields column.
  5. Edit any field columns as needed.
  6. Click Save.

Add a calculated field​

  1. In the Fields page of a table, click Add.
  2. Enter a destination field name and a description.
  3. In Destination Field Type, choose the output data type from the dropdown list.
  4. In Calculation Expression, enter your SQL statement. You can use variables.
  5. Click Save.

note

Do a mouse over on the tooltip to see the whole calculation, Click on the Calcul hyperlink in the Field Source column to change the calculation any time.

Example​

To calculate the total amount from five fields, choose Decimal as the output type with a precision of 25 and a scale of 5.

TAMOUNT1 + TAMOUNT2 + TAMOUNT3 + TAMOUNT4 + TAMOUNT5