Separate PX Framework and SDE for Gas and Electric

Regarding the Process Framework (PX) configuration and SDE instances, you can either use the same parameters and connection properties for both gas and electric, or you can configure different parameters and connection properties.

In the EdgeService.Settings.config file, there are four variables that inform the Process Framework configurations:

• PXDatabaseType

• PXConnectionString

• PxDataSource

• PxUser

And, there are four variables that inform the SDE instances:

• SDEDatabaseType

• SDEConnectionString

• SDEUser

• VersionName

Use the Same Configuration for Both Gas and Electric

In the config file, if you leave these variables as shown, then they apply to both electric and gas.

Create Electric-Specific Configurations

In the config file, append “electric:” to the front of the variable that you want to use for electric designs only. For example:

• electric:PXConnectionString

• electric:PxDataSource

• electric:PXUser

• electric:SDEUser

• etc.

You do not need to make all four variables electric-only. For example, you could leave PXDatabaseType alone (you most likely use SQL Server or Oracle, but not both). In that manner, you are saying that while the connection string, users, and data source are different for gas and electric, the database type is the same.

Create Gas-Specific Configurations

In the config file, append “gas:” to the front of the variable that you want to use for gas designs only. For example:

• gas:PXConnectionString

• gas:PxDataSource

• gas:PXUser

• gas:SDEUser

• etc.

You do not need to make all four variables electric-only. For example, you could leave PXDatabaseType alone (you most likely use SQL Server or Oracle, but not both). In that manner, you are saying that while the connection string, users, and data source are different for gas and electric, the database type is the same.