To enable users to utilize P6 Integration API functionality within P6 Professional when using a non-default Microsoft SQL Server port, add an ADMINISTRATOR_SETTINGS row to the SETTINGS table for each Microsoft SQL Server database you use with P6 Professional. The table below summarizes the settings.
ADMINISTRATOR_SETTINGS Settings | |
|---|---|
Setting Description: Points to the JDBC connection URL for a P6 Professional Microsoft SQL Server database. | |
Namespace | Administrator_Settings |
Setting Name | JdbcConnectionURL |
Setting Value | <jdbc connection url> |
When entering a value for jdbc connection url for Microsoft SQL Server, use the standard connection string. For example:
jdbc:sqlserver://<servername>:<portnumber>;database=<databasename>;