Preparing the Orchestration Framework Database

ProjectWise Orchestration Framework Service is used to manage various document processing jobs, and gets installed automatically when you select to install:

ProjectWise Design Integration Server with the Automated File Processing features turned on
Bentley i-model Composition Server for PDF

ProjectWise Orchestration Framework Service requires SQL Server to store the Orchestration Framework database, which is where information about each document processing job is kept. A copy of SQL Server Express is delivered for those organizations who may not be using SQL Server. During the ProjectWise Orchestration Framework Service portion of your server installation you will be prompted to connect to SQL Server and either create a new Orchestration Framework database (for new installations), or select an existing Orchestration Framework database (for upgrades).

If you plan to connect to the Orchestration Framework database using an ODBC connection, then you must first create an empty database in SQL Server to be used as the Orchestration Framework database, and then create a 64-bit ODBC data source on this computer that connects to the empty database in SQL Server. If you plan to use a direct database connection, you can either create an empty database in SQL Server to be used as the Orchestration Framework database, or you can let the Orchestration Framework Database Setup dialog (opens during the ProjectWise Server installation) create the Orchestration Framework database in SQL Server for you.

Warning: Never select an existing ProjectWise database to use for your Orchestration Framework database!

ProjectWise Design Integration Server, Bentley i-model Composition Server for PDF, and Bentley Automation Service (which also uses ProjectWise Orchestration Framework Service) should each be installed on their own computer, which means that you will have an installation of ProjectWise Orchestration Framework Service on each of those computers. If you have multiple installations of a particular server that is using ProjectWise Orchestration Framework Service (for example, if you have Bentley i-model Composition Server for PDF installed on multiple computers in order to work together), it is recommended that you use the same Orchestration Framework database for all of them. In this situation you would create a new Orchestration Framework database for the first installation, and then select the same Orchestration Framework database for each additional installation.