Skip to main content

Transfer Data to a Prepare Instance

This article describes how to select and copy data to a Prepare instance from an Ingest instance or from another Prepare instance. Table selection is the process of finding a table or view in a source instance and mapping it to the destination Prepare instance. Once a table has been mapped, deploying and executing it in the destination instance transfers the data from source to destination.

Select tables from an Ingest instance

  1. In the Solution Explorer, right-click the Ingest instance and select Select Tables.
  2. In the Select Tables tab, enter a schema and/or table name in the Schema and Tables fields to filter results.
  3. In the Data source list, select the sources to search and click Search. If a new data source has been added while the Table Selector was open, click Search again to refresh the results.

Select tables from another Prepare instance

Note:

Both Prepare instances must use Microsoft SQL storage.

To prevent circular references, data can only be copied in one direction — a Prepare instance cannot be both the source and the destination for another Prepare instance.

Due to object ID conflicts, copying data between identical Prepare instances is not supported — for example, the same instance in DEV and PROD environments created by migrating the DEV instance to PROD.

  1. In the Solution Explorer, right-click the source Prepare instance and select Open.
  2. Expand Data Areas, right-click the relevant data area, and select Open.
  3. Locate the tables to map in the open data area tab. Proceed to Map and copy tables below.

Map and copy tables

  1. In the Solution Explorer, right-click the destination Prepare instance and select Open.
  2. Expand Data Areas, right-click the destination data area, and select Open.
  3. Drag tables from the source instance into the open destination data area. The available drag-and-drop actions are:
    • Add New Table (default): Adds the table as a new table in the Prepare instance. This is the default when no table with the same name already exists in the destination.
    • Synchronize on Table Name (default): Synchronises the table with an existing table in the Prepare instance that has the same name — new fields are added and existing fields are mapped. This is the default when a table with the same name already exists.
    • Add New Table with Field Selection: Opens a field selection window before adding the table.
    • Synchronize with Other Table: Synchronises with an existing table in the Prepare instance of your choice.

    Use the primary mouse button to apply the default action. Use the secondary mouse button to drag for a shortcut menu showing all available actions.

    When dragging from an Ingest instance search result, hold Shift or Ctrl to select multiple tables. When multiple tables are dragged, Jet Analytics Data Integration first attempts to synchronise each table on table name; if no matching table exists in the destination, the table is added as new.

  4. Right-click the tables or data area and select Deploy to deploy the changes.
  5. Right-click the tables or data area and select Execute to transfer the data from the source instance to the data area.

Was this article helpful?

We're sorry to hear that.