Connection Settings

For the Self-Service Reporting application, the connections to Aras Innovator and databases is defined in the SelfServiceReportConfig.xml file, typically found at the root of the Aras Innovator code tree installation. Just as it possible to connect multiple databases to an Aras Innovator instance, it is possible to connect multiple databases to the Aras Self-Service Reporting application.

The SelfServiceReportConfig.xml file consists of the following settings:

<configuration>

 <appSettings>

 <add key="inn_server_url” value="<Innovator_URL>/Server/InnovatorServer.aspx"/>

 </appSettings>

 <connectionStrings>

 <add connectionString="Data Source=<SQLServerName>;Initial Catalog=<DatabaseName>;Persist Security Info=True;Pooling=False;User ID=<DatabaseUserName>;Password=<DatabaseUserPassword>;" 

 name="<InnovatorSolutions>" />

 </connectionStrings>

</configuration>

Example:

<?xml version="1.0" encoding="utf-8"?>

<configuration>

 <appSettings>

 <add key="inn_server_url” value="http://localhost/InnovatorServer/Server/InnovatorServer.aspx"/>

 </appSettings>

 <connectionStrings>

 <add connectionString="Data Source=(local);Initial Catalog=InnovatorSolutions;Persist Security Info=True;Pooling=False;User ID=innovator_regular;Password=innovator_regular;" 

 name="InnovatorSolutions” />

 </connectionStrings>

</configuration>

In order to connect to additional databases, new add tags should be added inside the connectionStrings structure. Each connectionString should match the DB-Connection tag in the InnovatorServerConfig.xml file as mapped in Table 2.

Document Conventions