Get LoadID

Tools

Description

Gets a load ID from Semarchy xDM and stores it in a variable. This ID is either generated, or retrieved from a Semarchy xDM continuous load. You need this load ID to load data into a Semarchy xDM data location.

Semarchy xDI stores the load ID in an XDM_LOAD_ID variable by default.

Parameters

Name

Mandatory

Description

Load ID Type

true

Type of load ID:

Standalone Load ID

Creates a new external load and returns its ID. You must explicitly submit this load after loading the data, and you can cancel this load.

Continuous Load ID

Retrieves the ID of an existing Semarchy xDM Continous Load. Data loaded in continuous loads is automatically processed on that load’s schedule, using its pre-defined integration job. You do not need to submit this load, and cannot cancel it.

When using a continuous load, load data using a database transaction where possible. By doing so, you make sure that all required data is loaded before the transaction commit, and that you can roll back this transaction in case of data integration errors.

Continuous Load Name

true

Name of the continuous load as configured in the Semarchy xDM Management view.

This setting only applies if the Load ID Type is set to Continuous Load ID.

Load Id Session Variable Path

false

Path and name of the variable storing the Load ID. The default is ~/XDM_LOAD_ID.

User Name

true

Name of the user initializing the action. The username must be the same across different actions used in the same process.

Repository Schema

true

Name of the database schema hosting the Semarchy xDM repository.

Data Location Name

false

Name of the data location as specified in the Semarchy xDM Management view. The default name comes from the metadata object.

Data Location Schema

true

Name of the database schema hosting the Semarchy xDM data location.

Session Id

false

Explicit Session Identifier used to retrieve the load ID when there are multiple parallel loads. The default is CORE_SESSION_ID.