Type
Aggregator
Active/
Connected
Application
Source
Qualifier
Active/
Connected
Custom
Active or Passive/
Connected
Data Masking
Passive/
Connected
Expression
Passive/
Connected
External
Procedure
Passive/
Connected or Unconnected
Filter
Active/
Connected
HTTP
Passive/
Connected
Input
Passive/
Connected
Java
Active or Passive/
Connected
Joiner
Active/
Connected
Lookup
Active or Passive/
Connected or Unconnected
Normalizer
Active/
Connected
Output
Passive/
Connected
Rank
Active/
Connected
Router
Active/
Connected
Sequence
Generator
Passive/
Connected
Sorter
Active/
Connected
Source
Qualifier
Active/
Connected
SQL
Active or Passive/
Connected
Stored
Procedure
Passive/
Connected or Unconnected
Transaction
Control
Active/
Transaction
Control
Connected
Union
Active/
Connected
Unstructured
Data
Active or Passive/
Connected
Update
Strategy
Active/
Connected
XML Generator Active/
Connected
XML Parser
Active/
Connected
XML Source
Qualifier
Active/
Connected
Description
Performs aggregate
calculations.
Represents the rows that the
Integration Service reads
from an application, such as
an ERP source, when it runs a
session.
Calls a procedure in a shared
library or DLL.
Replaces sensitive production
data with realistic test data
for non-production
environments.
Calculates a value.
Calls a procedure in a shared
library or in the COM layer of
Windows.
Filters data.
Connects to an HTTP server to
read or update data.
Defines mapplet input rows.
Available in the Mapplet
Designer.
Executes user logic coded in
Java. The byte code for the
user logic is stored in the
repository.
Joins data from different
databases or flat file systems.
Look up and return data from
a flat file, relational table,
view, or synonym.
Source qualifier for COBOL
sources. Can also use in the
pipeline to normalize data
from relational or flat file
sources.
Defines mapplet output rows.
Available in the Mapplet
Designer.
Limits records to a top or
bottom range.
Routes data into multiple
transformations based on
group conditions.
Generates primary keys.
Sorts data based on a sort
key.
Represents the rows that the
Integration Service reads
from a relational or flat file
source when it runs a session.
Executes SQL queries against
a database.
Calls a stored procedure.
Defines commit and rollback
transactions.
Defines commit and rollback
transactions.
Merges data from different
databases or flat file systems.
Transforms data in
unstructured and semistructured formats.
Determines whether to insert,
delete, update, or reject
rows.
Reads data from one or more
input ports and outputs XML
through a single output port.
Reads XML from one input
port and outputs data to one
or more output ports.
Represents the rows that the
Integration Service reads
from an XML source when it
runs a session.
Type
Aggregator
Application
Source
Qualifier
Custom
Active/
Connecte
d
Active/
Connecte
d
Active or
Passive/
Connecte
d
Data Masking
Passive/
Expression
Connecte
d
Passive/
External
Procedure
Connecte
d
Passive/
Filter
Connecte
d or
Unconnec
ted
Active/
HTTP
Connecte
d
Passive/
Connecte
d
Input
Java
Joiner
Lookup
Passive/
Connecte
d
Active or
Passive/
Connecte
d
Active/
Connecte
d
Active or
Passive/
Connecte
d or
Unconnec
ted
Normalizer
Active/
Output
Connecte
d
Passive/
Rank
Connecte
d
Active/
Router
Connecte
d
Active/
Connecte
d
Sequence
Generator
Sorter
Source
Qualifier
SQL
Stored
Procedure
Transaction
Control
Passive/
Connecte
d
Active/
Connecte
d
Active/
Connecte
d
Active or
Passive/
Connecte
d
Passive/
Connecte
d or
Unconnec
ted
Active/
Transaction
Control
Union
Connecte
d
Active/
Unstructured
Data
Connecte
d
Active or
Passive/
Update
Strategy
Connecte
d
Active/
Connecte
d
XML Generator Active/
XML Parser
XML Source
Qualifier
Connecte
d
Active/
Connecte
d
Active/
Connecte
d
Description
Performs aggregate
calculations.
Represents the rows that the
Integration Service reads
from an application, such as
an ERP source, when it runs a
session.
Calls a procedure in a shared
library or DLL.
Replaces sensitive production
data with realistic test data
for non-production
environments.
Calculates a value.
Calls a procedure in a shared
library or in the COM layer of
Windows.
Filters data.
Connects to an HTTP server to
read or update data.
Defines mapplet input rows.
Available in the Mapplet
Designer.
Executes user logic coded in
Java. The byte code for the
user logic is stored in the
repository.
Joins data from different
databases or flat file systems.
Look up and return data from
a flat file, relational table,
view, or synonym.
Source qualifier for COBOL
sources. Can also use in the
pipeline to normalize data
from relational or flat file
sources.
Defines mapplet output rows.
Available in the Mapplet
Designer.
Limits records to a top or
bottom range.
Routes data into multiple
transformations based on
group conditions.
Generates primary keys.
Sorts data based on a sort
key.
Represents the rows that the
Integration Service reads
from a relational or flat file
source when it runs a session.
Executes SQL queries against
a database.
Calls a stored procedure.
Defines commit and rollback
transactions.
Defines commit and rollback
transactions.
Merges data from different
databases or flat file systems.
Transforms data in
unstructured and semistructured formats.
Determines whether to insert,
delete, update, or reject
rows.
Reads data from one or more
input ports and outputs XML
through a single output port.
Reads XML from one input
port and outputs data to one
or more output ports.
Represents the rows that the
Integration Service reads
from an XML source when it
runs a session.
