Modifying the data sources

You can copy the ConnectionDefinitions.config file to the ProgramData\Infor\CPM directory on the new server or you can redefine the data sources.

If you copy the ConnectionDefinitions.config file, open the Manage Data Sources page and modify the connections for the application database and the views database.

Optionally, you can add a timeout parameter, in seconds, in the ConnectionDefinitions.config file for the navigation database category.

For example:
<add name=Navigation
category="NavigationDatabase" 
timeout=”60”
You can add the extendedConnectionString parameter to extend the connection properties for Microsoft Analysis Services and the BI OLAP connection type.
Note: The extendedConnectionString parameter name is case sensitive.
For example:
<add name=<data source name> id="fba94cf4-49b9-413e-ba96-b988fc4725bd"
ConnectionType= AS
extendedConnectionString="Disable Prefetch Facts=true"/>

See Server administration.