Install and configure Pro2 for LAN

You can install Pro2at the same time you install and configure OpenEdge, or you can install Pro2 as an add-on to complement your OpenEdge environment later on. Installing Pro2 as an add-on can be especially useful when you are upgrading OpenEdge versions, or need to migrate databases. For more information about database migration, see Migrate your OpenEdge database with Pro2.

Before you can install Pro2, you must first install and configure OpenEdge. This installation must be on a separate machine from your source OpenEdge database installation. It can be on its own machine, virtual or physical, or on the same system as your target database. Likewise, when you install Pro2, you can install and configure it on its own machine or on the same system as your source database. The installation of OpenEdge and Pro2 on its own machine, is sometimes referred to as the Pro2 server. The Pro2 server contains PAS for OpenEdge instance, the Repl and Pro2 databases, and the configuration information for the web based user interface.

System requirements

These are minimum recommendations. All parameters can be increased to accommodate more robust hardware.

For more information about OpenEdge system requirements, see the Progress Platform Compatibility Guide.

Before you begin

Ensure that you have OpenEdge installed and configured on the same machine that you are going to install Pro2 on. For more information about installing OpenEdge, see Install OpenEdge on Windows.

Main steps to install and configure Pro2

Install Pro2

1. Close all applications before beginning the installation.
2. Locate and execute the Pro2.exe file.

   There can be a numeric value in the file name that indicates the version of Pro2, for example, Pro2-6.5.0.exe.

   Note: Starting with Pro2 6.5.2, after locating the Pro2.exe file, run the following command from the command prompt:

   Pro2.exe LAX_VM "C:\<JAVA_HOME>\bin\java.exe"

   The supported Java version is Java 11 and Java 17.
3. In the Pro2 installation wizard, click Next to Choose the install folder.
4. Specify the path, or click Choose to browse and select where you want to install Pro2.

   The default installation directory is C:\Progress\Pro2.

5. In the Choose OpenEdge window, specify the path, or select Choose to browse and set the OpenEdge home directory.

   The OpenEdge home directory is where OpenEdge is installed on your machine.

   The default directory is C:\Progress\OpenEdge.

6. On the PAS Ports screen, enter the relevant PAS for OpenEdge information in the Port and Instance Name fields.

   The default instance name is Pro2Web. You can change this name to according to your needs. It is recommended to change the instance name for each Pro2 installation.

   Note: For each installation of Pro2, you must specify different port information. No two installations can use the same ports on the same machine.
7. Click Next and review the options you chose for this installation in the Pre-Installation Summary page.
8. Click Install.
   Note: The Pro2 installation wizard can take several minutes to complete and may appear to lag at times. Allow the installation wizard to complete. Do not prematurely cancel the process.
9. Click Done.
10. Check the installation logs at C:\Progress\Pro2\install\logs folder.

After the installation is complete, go to the Pro2 root folder to continue the configuration process. If you used the default settings during the installation, then this folder is C:\Progress\Pro2.

All files, scripts, and procedures for Pro2 are relative to the root folder. This allows Pro2 to be installed several times on the same drive without each installation interfering with each other. This functionality was designed to allow you to be able to create development and production environments to test implementations, as needed, without affecting your production environment.

For more information about the Pro2 root folder and file directory, see the Directory reference at the end of this guide.

Create a Repl and Pro2 database

In this part of the configuration process, you build a Repl and Pro2 database by using Proenv commands and the repl.df and pro2.df files.

Standard OpenEdge database utilities are used to create the Repl database. The structure file (.st) and schema definition file (.df) used to create the Repl database can be found in the db folder of the Pro2 root folder. If you are using replication triggers with a LAN configuration, all configuration files, parameter (.pf) files, and scripts need to be modified to include a connection to the Repl database wherever there is a connection made to the source database. Change data capture (CDC) is not affected by this requirement.

It is important to note that this procedure describes the high level steps to create the Repl and Pro2 databases. When creating these databases every consideration and precaution should be taken, as if you were creating a database for an enterprise application in a production environment, to ensure their availability. Without these databases, data is not replicated from your source database to your target database. This can cause loss of synchronization.

Confer with your database administrator and other key stakeholders to when creating the Repl and Pro2 database for your production environment. For more information about database administration, see OpenEdge database essentials.

To create a Repl and Pro2 database:

1. Open a Proenv instance.
2. Set your working directory to the db folder in the Pro2 root directory.
   Note: Check the directory of the db folder to view the database instances. Type dir after navigating to the database folder.
3. Create an empty repl database instance by typing the following command prodb repl empty.
4. Create an empty Pro2 database instance by typing the following command prodb pro2 empty.
   Note: Ensure that the you set the code page of the Repl and Pro2 databases to match the code page of your source and target databases.
5. Load the table definitions file in the Repl database by typing prowin repl -1.

   The Procedure Editor window appears.

6. Navigate to Tools > Data Administration.
7. In the Data Administration window, navigate to Admin > Load Data and Definitions > Data Definitions (.df file)….
8. In the Load Data Definitions window, load the repl.df file and click OK.
   Note: The repl.df file is located in the db folder of the Pro2 root folder.
9. Load table definitions in the Pro2 database by entering prowin pro2 -1.

   The Procedure Editor window appears.

10. Navigate to Tools > Data Administration.
11. In the Data Administration window, navigate to Admin > Load Data and Definitions > Data Definitions (.df file).
12. In the Load Data Definitions window, load the pro2.df file and click OK.
    Note: The pro2.df file is located in Pro2 folder/db.
13. Start the repl and pro2 databases by typing:
    • Proserve repl
    • Proserve pro2
14. Add the Pro2 database connection details to the replProc.pf file in the Pro2 root folder under \bprepl\Scripts\replProc.pf to connect the replication threads and PAS for OpenEdge instance to the Pro2 database. Navigate to the bprepl\scripts folder and open the replProc.pf file. Add the complete path of the database in the file and click Save.
15. To check both Repl and Pro2 database instances are connected successfully, open the Procedure Editor from the bprepl\Scripts folder and navigate to Tools > Data Dictionary. If the connection is successful, the Tables section displays the tables.

Start the PAS for OpenEdge instance and log in to the Pro2 web application

Now that the database instances are set up successfully, start the PAS OpenEdge instance and log in to the Pro2 web application.

1. Start a Proenv instance.
2. Navigate to the Pro2 folder by entering cd followed by name of the folder where you installed Pro2, for example, cd Pro2v62.
3. Enter instance name\bin\tcman.bat env.
   Note: The default instance name is Pro2Web.
4. Enter instance name\bin\tcman.bat start.
5. To verify that the instance started successfully, type instance name\bin\tcman.bat env. The server running section shows a number if the instance started.
6. Open any browser and log in at localhost:port number/pro2/static/ using the default credentials, where the default username and password are both set to admin.
   Note: It is strongly recommended to change the default credentials immediately after the initial login. Update the password to a strong, unique value to prevent unauthorized access and ensure security.

Load the configuration file

To load the configuration file:

1. In the Pro2 web interface, navigate to Actions > Tools > Load Configuration.
2. Click Select Files and load the .ini configuration file, for example replbasev610.ini, from the Pro2 folder.
3. Click Submit. A success or failure notification is displayed after the upload is complete.

You can view the default properties and records on the Properties tab after the configuration file is successfully loaded.

Start the job runner

1. Navigate to the Pro2 Scripts folder, for example C:\Pro2\bprepl\Scripts.
2. Select and execute the jobrunner.bat file.
3. Navigate back to the web interface and confirm that the jobrunner.bat file is running by checking the status in the Pending Jobs watch-box.

Connect to a source and target database

The Pro2 source database is an OpenEdge database where the data modifications are made, and the target database is the database where the modifications are replicated. The source database must be an OpenEdge database, the target database can be an OpenEdge database, Microsoft SQL Server, or an Oracle database.

Add the source database details

You can set up either trigger-based replication or CDC-based replication. In a trigger-based-replication, the replication queue records (also known as ReplQueue records) are generated by deploying Pro2 triggers on a source database. In a CDC-based replication the ReplQueue records are generated from change tracking table. However, for CDC-based replication, the source database must be CDC enabled.

To add source database details:

1. From the Pro2 web interface, navigate to the Manage Replication tab.
2. Click New.

   The Create Replication window appears.

3. Set up the settings for the replication instance, for example, Source DB Mode is set to Triggers, and the Source DB Connection is set to LAN.
4. Click Next.

   The Select Source tab appears.

5. Enter the name of the source database.
6. Enter the host name.
7. Enter the port number in the Host Port/Service field (for example, 2233).
8. (Optional) Enter your user name and password.
   Note: Enter your user name and password only if it is required by your source database.
9. Click Test Connection.

   If the test is successful, move on to set the target database. Review your source database details to ensure that they are correct.

10. Click Next.

    The Set Target tab appears.

Add the target database details

The target database can be either a Microsoft SQL Server, Oracle database, or OpenEdge database. If your target database is an OpenEdge database, the you can forgo some of the configuration processes like generating the schema holder. However, there for a Microsoft SQL Server or Oracle database there are several configuration considerations to take into account. For more information about configuring Microsoft SQL Server or Oracle as a target database, see Configure Pro2 to target SQL database connectivity.

To add target database details:

1. Select Target Database Type. Choose Microsoft SQL Server, Oracle database, or OpenEdge database.
2. Following fields are automatically filled, but they can be changed if necessary
   • Target Database Name
   • Target Schema Image
   • Schema Holder DB
   • Target ODBC Connection
3. Enter the source database path. By entering the full path or relative path then there is no need to enter the host and port details.
4. (Optional) Enter your user name and password.
   Note: Enter user name and password only if it is required by your target database.
5. Click Next.

   The Generate Target Schema tab appears.

Here is an example of a .pf file that was created using the sports database and Microsoft SQL Server:

Generate the target schema file

By generating the target schema file, you load the target database with files necessary to build out the target database. Pro2 reads the source database schema, and generates scripts that are then executed on the target database server to create the target schema. By default, all tables and fields are created in the target. The rest of the files (drop.sql, index.sql, trunc.sql, errors.log, and warnings.log) are created separately. You can execute these files as necessary. Typically, tables that are not replicated remain unmapped.

To generate target schema file:

1. Select one or more of the following checkboxes:
   Note: These options are available only when the target database is an OpenEdge database. If the target database is Microsoft SQL Server or Oracle database, these options are not available.
   • Preserve Area: Preserves the source database data definition, and copies them to the target database.
   • Generate Pro2 Target Fields: Generates Pro2-specific target fields in your target database. Doing so avoids unnecessary replications of the source schemas.
   • Generate Index as Inactive: Deactivates the existing active index.
2. Click Generate Target Schema. A table that contains a replication job appears.
   Note: Do not execute this job until you run the job runner file. A job runner batch file continuously processes replication jobs from the job queue. This file is in the Scripts folder.
3. Click Download under the Download Schema files column, to download the target schema files.

Create a target database

If you have not done so already, create a target database for you replicated data. The Target database can be either a Microsoft SQL server, Oracle, or OpenEdge database. Creating a target database will depend largely on they type of database you want to use and your development tooling. The following procedure lists the general steps to creating your target database.

Create a schema holder for your target database

In this step, you create an empty database as a schema holder for your target database. Your target database can be either Microsoft SQL Server or Oracle. The schema holder is a layer that allows ABL to interact with the Microsoft SQL Server or Oracle database.

To create a schema holder:

1. Open a Proenv window, and type prodb database name empty to create an empty schema holder database.
2. Start a single user session by typing prowin database name -1.

   The Procedure Editor window appears.

3. From the Procedure Editor, select Tools > Data Administration.
4. Select DataServer > database type Utilities > Create DataServer Schema .

   The Create/Modify Record for Schema window appears.

5. Specify Logical Database Name.
6. If the source database is a SQL server, specify the ODBC Data Source Name. Click OK.
7. Enter the login ID and password if required in the next dialog box and click OK.
8. Enter criteria for Object Name, Object Owner (typically, dbo), and Qualifier.
9. Select the Default to OpenEdge DATETIME option.
10. If you are using LOB fields in replication, ensure that the Default to OpenEdge LOB for BLOBs option is selected along with the CLOBs option. This forces the data server to automatically consider certain target side data types to be treated as LOBs.

    By selecting CLOBs, varchar(max)/nvarchar(max) data types are automatically converted to CLOBs. By selecting BLOBs the data server is forced to consider all varbinary(max) as BLOBs. On source fields that are character types, Pro2 may convert some types to varchar(max) when the source width is wider than the MAX_CHAR_WIDTH property setting. This conversion has the added benefit of avoiding row size limits for SQL Servers. However, varchar(max)/nvarchar(max) are not necessarily treated as CLOBs.

    
    
    
11. Click OK to finish.

Load the target database table definitions

After the target schema file is downloaded, load the target database with the appropriate tables required for replication.

For OpenEdge target databases:

1. Cut and paste the target schema file into the db folder of Pro2.
2. Open a Proenv window, type prowin -db target and press Enter.
3. In the Procedure Editor, select Tools > Data Administration.
4. Select Admin > Load Data and Definitions > Data Definitions (.df file)
5. Add the target schema file as the Input File and click OK.
6. Navigate to the Pro2 web interface and click Next.

   The Mapping Source to Target Tables tab appears.

Map tables and fields

You must map data fields between your source and target database so that data in the source can be replicated to the target. You can do this from the Mapping dashboard in the web interface. The Repl database contains all the mapping information for the replication of the databases, tables, and fields between the source and target. This information is stored in the ReplDBXref, ReplTableXref, and ReplFieldXref tables. Mapping information can be saved to and loaded from a text file.

Depending on the number of schemas, primary keys, and foreign keys of the databases, the data sources and the database mapping information has varying degrees of complexity.

Map source tables to target tables and generate code

To map source tables to target tables and generate code:

1. On the Mapping Source to Target Tables tab, select the tables from the source database that you want to map with the target database. You can map the tables in the following ways:
   • Map—Choose the Map option if you want to map a single source table with a single target table.
   • Automap—Choose the Automap option if you want to map one or more source tables to the corresponding target tables.
   Note: You can also unmap the tables based on your needs using the Unmap option.
2. Select the tables to map, and click Automap click Next.
3. In the Advanced Configuration tab, change thread assignments and other optional control flags if required.
   Note: The Advanced Configuration tab is an optional settings tab.
4. Click Next.

   The Generate Code tab appears.

5. Click Generate Code. You are directed to the Pro2 web interface dashboard. Click the Pending Jobs watch-box to see which replication jobs are running.
6. Run the replication file to execute the replication jobs. In Windows Explorer, navigate to \bprepl\Scripts.
7. Double-click the Replbatch1.bat file.

   The corresponding replication thread starts running on the dashboard.

   Note: In a CDC-based replication, double-click the CDCbatch.bat file.
8. Refresh the Pro2 user interface to complete the replication configuration process.

Manually test a replication

Testing is an important part of any enterprise applications configuration process. Consider an testing example where a city is assigned to a customer. This change is made in the source database, and needs to be replicated to the target database. To perform the test scenario:

1. In a Proenv window, navigate to your Pro2 root folder. For example, C:\Pro2v62\db.
2. Enter the command prowin -db database name -db repl.

   The Procedure Editor window appears.

3. Assign city to the first customer in source database.

   FIND FIRST customer.
   ASSIGN city = “NY”
   

4. Open the Pro2 web interface and click the Total Threads watch-box. Notice the event type in the Replication thread window. This event will show the recent change made to the source database.
   
   
   
5. Run the replication file by navigating to \bprepl\Scripts .
6. Double-click the Replbatch1.bat file to run the replication thread. This action removes the event type in the thread which simulates that the replication record was processed by the thread and sent to the target database.
   
   
   

Directory reference

The following is a description of the folders under the Pro2 root folder.

ReplProperties and ReplQueue

Deploy replication triggers in the source database

You can deploy replication triggers in the source database by using the Pro2/utils/ReplTrigInsert.p procedure. This procedure is executed from the Procedure Editor window connected to both, the source database and the repl database.