g_ETLActivitySteps_ETLPipeline

ETLPipeline

Pipelines gather and group cursors and commands together into related units, becoming the defining blocks of your ETL activities.

Description Use the pipeline element to collect your steps together into these cohesive groups. Properties

description : string

Description of this pipeline.

layout : string

GUI layout data.

name : string

The pipeline name. This name is displayed on the ETL diagram.

Content

• Choice of:

  • g_ETLPipelineSteps_ReadCursor [1..1] - Use the Object cursor to read and batch data from the model class instances.

  • g_ETLPipelineSteps_AggregateCursor [1..1] - Use the Aggregate cursor to read and batch data from the model class instances.

  • g_ETLPipelineSteps_CreateCommand [1..1] - Use the Create Object command to create a new object from the data that you are processing.

  • g_ETLPipelineSteps_DeleteCommand [1..1] - Use the Delete Object command to delete an object from the data that you are processing.

  • g_ETLPipelineSteps_LogCursor [1..1] - An ETL logging cursor.

  • g_ETLPipelineSteps_ScriptCursor [1..1] - An ETL script cursor.

  • g_ETLPipelineSteps_RollupCursor [1..1] - An ETL rollup cursor.

  • g_ETLPipelineSteps_TransformationCursor [1..1] - An ETL transformation cursor.

  • g_ETLPipelineSteps_MergeJoinCursor [1..1] - An ETL MergeJoin cursor.

  • g_ETLPipelineSteps_UnionAllCursor [1..1] - An ETL UnionAll cursor.

  • g_ETLPipelineSteps_ConditionalSplitCursor [1..1] - An ETL ConditionalSplit cursor.

  • g_ETLPipelineSteps_ChannelOutputCommand [1..1] - An ETL ChannelOutput command.

  • g_ETLPipelineSteps_MulticastCursor [1..1] - An ETL Multicast cursor.

  • g_ETLPipelineSteps_FileOutputCommand [1..1] - An ETL FileOutput command.

  • g_ETLPipelineSteps_MessageCursor [1..1] - An ETL Message cursor.

  • g_ETLPipelineSteps_DiscardCommand [1..1] - Use the Discard command to pull rows and discard them with no further processing.

  • g_ETLPipelineSteps_UpsertCommand [1..1] - Use the Upsert command to update an existing object or create a new one from the data that you are processing.

Parents

• ETLActivity - An ETL activity.

• g_ETLActivitySteps_TryCatch_Try

• g_ETLActivitySteps_Join_Sequence - Step within a Join of a Service. e.g. Script, Transform, Try, Branch...

• g_ETLActivitySteps_TryCatch_Catch

• g_ETLPipelineSteps_ReadCursor
  Use the Object cursor to read and batch data from the model class instances.

• g_ETLPipelineSteps_AggregateCursor
  Use the Aggregate cursor to read and batch data from the model class instances.

• g_ETLPipelineSteps_CreateCommand
  Use the Create Object command to create a new object from the data that you are processing.

• g_ETLPipelineSteps_DeleteCommand
  Use the Delete Object command to delete an object from the data that you are processing.

• g_ETLPipelineSteps_LogCursor
  An ETL logging cursor.

• g_ETLPipelineSteps_ScriptCursor
  An ETL script cursor.

• g_ETLPipelineSteps_RollupCursor
  An ETL rollup cursor.

• g_ETLPipelineSteps_TransformationCursor
  An ETL transformation cursor.

• g_ETLPipelineSteps_MergeJoinCursor
  An ETL MergeJoin cursor.

• g_ETLPipelineSteps_UnionAllCursor
  An ETL UnionAll cursor.

• g_ETLPipelineSteps_ConditionalSplitCursor
  An ETL ConditionalSplit cursor.

• g_ETLPipelineSteps_ChannelOutputCommand
  An ETL ChannelOutput command.

• g_ETLPipelineSteps_MulticastCursor
  An ETL Multicast cursor.

• g_ETLPipelineSteps_FileOutputCommand
  An ETL FileOutput command.

• g_ETLPipelineSteps_MessageCursor
  An ETL Message cursor.

• g_ETLPipelineSteps_DiscardCommand
  Use the Discard command to pull rows and discard them with no further processing.

• g_ETLPipelineSteps_UpsertCommand
  Use the Upsert command to update an existing object or create a new one from the data that you are processing.

Parent topic: ETLActivity

Parent topic: g_ETLActivitySteps_TryCatch_Try

Parent topic: g_ETLActivitySteps_TryCatch_Catch

Parent topic: g_ETLActivitySteps_Join_Sequence

Parent topic: reuseable-references