Documentation for Intellect Web Report System 3.5. Documentation for other versions of Intellect Web Report System is available too.

Previous page General description of Intellect Web Report System distribution kit  Updating Next page

Intellect Web Report System is installed as a part of Intellect. Information about compatibility of Intellect versions and Intellect Web Report System is presented at Obsolete. General information about product releases and versions compatibility.

Attention!

Intellect Web Report System should be installed only on Server/Remote Administrator's workstation (for details, see Intellect software. Administrator's Guide).

To install Intellect Web Report System, do the following:

  1. Run the setup.exe executable file in the distribution root directory. 
  2. To continue the installation process, click Next.
  3. Read the terms of the license agreement carefully. Then set the switch to I accept the terms of the License agreement position and click Next.

  4. Select MS SQL Server DB server and set the connection parameters (for details, see Installation of Intellect as a Server/Remote Administrator's workstation). To continue the installation process, click Next.

    Note

    The Intellect Web Report System database will be created on the selected SQL server.

    Later it's possible to move the database of Intellect Web Report System to another SQL server. After that, it is necessary to make changes to the <Intellect installation directory>\Modules\Wt2\Web.config file by correcting the ReportSystemConnectionString connection string:

    • <add name="ReportSystemConnectionString" connectionString="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ReportSystem;Data Source=(local)\SQLEXPRESS2014;" providerName="System.Data.SqlClient"/>


  5. Specify the connection strings to the main Intellect database and the POS Intellect receipts database. The connected databases will serve as a data source when creating reports.


  6. To set connection string to the main Intellect database, do the following:

    1. Click Connection to the main Intellect DB.

    2. As a result the Data link properties dialog box is displayed.

    3. In the Data provider tab select Microsoft OLE DB Provider for SQL Server. Click Next.

    4. As a result there will be an automatic switch to Connection.

    5. In 1. Select or enter a server name line select from the list or enter manually the name of SQL server where the main Intellect database is stored.

    6. To log on SQL server it is necessary to set authentication parameters. For this set switch into Use a specific user name and password position. In the User name and Password fields enter username (login) and password in order to connect to SQL server. Set the Allow saving password checkbox.

    7. To check connection to SQL server, click Test connection.
      In case of successful connection, the window with the Test connection succeeded message will be displayed.

      It's necessary to click       ОК in the window of message and as a result the window will be shut down automatically.
      If the name of SQL server and/or authentication parameters that are used in order to connect to it were set wrong then the corresponding message is displayed.

      To shut down the window with the message, click       ОК. Then correct the data and check connection to SQL server once again.

    8. If check of connection to SQL server is successful, select from the Select database on server list the name of connected database.

    9. Click ОК in the Data connection properties dialog box. As a result of this operation the dialog box will shut down.
      Setting connection string to the main Intellect database is completed.

  7. In the same way, set the connection string to the POS Intellect database of receipts (the default database name is pos).
  8. Click the Next button to proceed to setting up the connection to the Auto Intellect databases.
  9. In the same way, set the connection string to the Traffic Detection database (the default database name is traffic_db).

  10. In the same way, set the connection string to the License Plate Recognizer database (the default database name is lprex).

  11. Click Next to proceed to configuring the connection to the DetectorPack databases.

  12. In the same way, set the connection string to the DetectorPack database (the default database name is detectorpack).

    Note

    If you install POS Intellect, Auto Intellect and DetectorPack after the Intellect Web Report System, it is necessary to connect the Intellect Web Report System database to the corresponding modules. To do this, start the repairing mode of the reporting subsystem and specify the appropriate connection strings (see Repairing).

    You can also set the connection strings to all databases through the <Intellect installation directory>\Modules\Wt2\Web.config file. Examples of connection strings are given below:

    • <add name="IntellectDB" connectionString="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=intellect;Data Source=(local)\SQLEXPRESS2014" />
    • <add name="PosDB" connectionString="Data Source=(local)\SQLEXPRESS2014;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=pos;Provider=SQLOLEDB.1" providerName="System.Data.SqlClient" />
    • <add name="TrafficDB" connectionString="Provider=SQLOLEDB.1;Data Source=(local)\SQLEXPRESS2014;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=traffic_db" />
    • <add name="DtDB" connectionString="Provider=SQLOLEDB.1;Data Source=(local)\SQLEXPRESS2014;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=dt" />
    • <add name="ReportSystemConnectionString" connectionString="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ReportSystem;Data Source=(local)\SQLEXPRESS2014;" providerName="System.Data.SqlClient" />
    • <add name="Analytics" connectionString="Server=localhost;Port=15432;User id=postgres;Password=Analytics_default_DB_4;Database=analytics;CommandTimeout=600;" providerName="Npgsql" />
    • <add name="lprex" connectionString="Provider=SQLOLEDB.1;Data Source=(local)\SQLEXPRESS2014;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=lprex" />
    • <add name="detectorpack" connectionString="Provider=SQLOLEDB.1;Data Source=(local)\SQLEXPRESS2014;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=detectorpack;"/>


  13. To continue the installation process, click Next. As a result, the copying of the necessary Intellect Web Report System files to the hard disk will start.
  14. After successful copying of the Intellect Web Report System components, a message about the completion of the installation process will be displayed. Then click Finish..

The installation of Intellect Web Report System is completed.

  • No labels