SQL Scripts OpenEdge

Before Enterprise Architect can be configured to use OpenEdge as a Repository the following Software Components need to be installed and configured:

• MDAC 2.6 or 2.7
• Install Progress OpenEdge 10.0B03.

Once these preconditions have been met the following process should be used to create the Enterprise Architect OpenEdge repository:

1. Using OpenEdge tools, create an empty database.
2. Run the OpenEdge_EASchema.sql script file to create all of the required tables/indexes etc.
3. Create an ODBC Data Source pointing to the new OpenEdge database.
4. With the empty database you can now use the data transfer tool to transfer an existing model to the server. Before doing so however, you should run the Project Integrity tool, to ensure the data is 'clean' before uploading. You can do this by opening the existing model in Enterprise Architect and selecting Tools | Data Management | Project Integrity Check.
5. To proceed with the transfer:
   • Open Enterprise Architect and then select Tools | Data Management | Project Transfer.
   • In the Dialog provide select .EAP to DBMS.
   • For the fields:
     • Source Model: Select the .EAP file that you want to transfer into the Adaptive Server Anywhere repository.
     • Target Model: Select the OpenEdge ODBC Data Source in the DBMS connection tool.Select the Microsoft OLE Provider for ODBC Drivers in the Data Link properties dialog, then press the Next button. On the Use data Source name dropdown menu on the connections tab, select the ODBC data source created earlier.
     • On the All tab of the Data Link Properties dialog, enter “DefaultSchema=PUB” for Extended Properties.
   • Press the OK button.
   • Press the Transfer Data button, this will begin the process.
   • Once this process completes, the contents of the .EAP model now exists on the OpenEdge repository and you may open the repository from Enterprise Architect, using the "Connect to Server" option.