Use this window to enter the target database details. The target is where the source data will be replicated to. Because Pro2 replicates data to a database on your behalf, you must provide the information for the following fields.

Field name Description
Target Database Type

Use this field to designate what type of database your target database is. Choose either Microsoft SQL Server, Oracle database, or OpenEdge database.
Target Database Name This field indicates the logical name of the target database.
Schema Holder Database Path Use this field to enter the schema holder database.
Target Schema Image The target schema image contains the schema information, such as table and column definitions, from the target database schema. The target schema image is stored in the schema holder database.
Schema Holder Database The schema holder is a small standalone Progress OpenEdge database that does not hold actual data. It stores the schema image of the target database and is required to enable mapping between the source and target database for non-OpenEdge target databases. The schema image of the target database is pulled into the schema holder by the OpenEdge DataServer update function.
Target Open Database Connectivity The target ODBC connection is configured through the Windows ODBC setup tool. After it is defined in windows, parameters are added to a .pf file which enables a connection to the target database with the parameters that you define.
User Name The user name for the target database.
Password The password for the target database.

Note: The .pf files (replProc.pf and sports.pf) are automatically updated in the background. The name of the .pf file is based on the logical name of the source database.
Click Next to move to the Generate Target Schema window.