Microsoft SQL Server Connector > Introduction to Microsoft SQL Server Connector > Microsoft SQL Server supported objects and task operations
  

Microsoft SQL Server supported objects and task operations

The following table lists the tasks and object types that Microsoft SQL Server Connector supports:
Task Type
Source
Target
Lookup
Synchronization
Yes
Yes
Yes
Mapping
Yes
Yes
Yes
Replication
Yes
Yes
Yes
Dynamic mapping
Yes
Yes
Yes
Data transfer
Yes
Yes
No
PowerCenter
Yes
Yes
Yes
For more information about configuring PowerCenter, dynamic mapping, and data transfer tasks, see Tasks.