Data Movement Diagram Objects

PowerDesigner supports all the objects necessary to build data movement diagrams.

Object

Tool

Symbol

Description

Replication process

replication process symbol

Instance of a data replication engine that replicates data from one or more source databases to one or more remote databases. See Replication Processes (DMM).

Replication Server

replication server symbol

Instance of a Replication Server replication engine that replicates data from one or more primary databases to one or more remote databases. This tool only displays when a Replication Server XEM is attached to the DMM. See Working with SAP® Sybase® Replication Server®.

Transformation process

transformation process symbol

Instance of a data movement process that models and document data transformations using Data Transformation Diagrams and Transformation Control Flow Diagrams. See Transformation Processes (DMM).

Database

database symbol

Data store modeled in one or more physical data models. See Databases (DMM).

XML Document

xml document symbol

Data store modeled in an XML model. See XML Documents (DMM).

Business process

business process symbol

Data store modeled in a business process model. See Business Processes (DMM).

Flat file

flat file symbol

Text file which contains records. See Flat Files (DMM).

Server

server symbol

Network device to which other objects are deployed. See Servers (DMM).

Publication

[none]

[none]

Set of tables, views and stored procedures to replicate via articles. See Publications (DMM).

Article

[none]

[none]

Table or view to replicate. See Articles (DMM).

Column

[none]

[none]

Table or view column to replicate. See Columns (DMM).

Procedure

[none]

[none]

Precompiled collection of SQL statements stored under a name in the database and processed as a unit. See Procedures (DMM).

Subscription

[none]

[none]

Request for a replication engine to maintain a replicated copy of database objects (such as tables, views or stored procedures) in a remote database at a specified location. See Subscriptions (DMM).

User

[none]

[none]

Person or group who is allowed to log onto the replication process. See Users (DMM).

Event script

[none]

[none]

Stored procedure to execute on a replication process or an article. See Event Scripts (DMM).

Data connection

Link between a database or other data store and a replication process or transformation process that specifies the way data is moved. See Data Connections (DMM).

Connection group

[none]

[none]

Set of data connections that provides a backup in case the primary database goes down. See Data Connection Groups (DMM).

Process connection

process connection symbol

Link between two replication processes that specifies the way data is moved. See Process Connections (DMM).