Analytics (with PAI 3.1.2.0) > Installation and Configuration > Intellicus: Installing, Configuring, and Upgrading > Configuring Intellicus for Servigistics > {Required} Configuring the Database
{Required} Configuring the Database
Use these instructions to configure the reporting and repository databases.
1. For Linux: Navigate to <INSTALL_INTELLICUS_DIR>/reportengine/config and create a backup of the Encr_ReportEngine.dat file. You can use the backup to perform a restore if necessary.
For Windows: Navigate to <INSTALL_INTELLICUS_DIR>\ReportEngine\config and create a backup of the Encr_ReportEngine.dat file. You can use the backup to perform a restore if necessary.
2. Use an already existing Servigistics database connection as the Reportdb connection and do the following to configure the Reportdb connection:
a. Enter the following into a browser to open the Intellicus portal and sign in as the administrative user:
http://<machine_name>:<port>/intellicus/
For example, http://localhost:90/intellicus/
User Name — Admin, Password — Admin
b. Select Navigate > Administration > Configure and click + Add Connection to make a new connection.
c. Enter the following values for the connection:
Field
Value
Connection Name
This is already populated and cannot be changed
Provider
This value depends on what was used to create the database. Valid options are:
• MSSQL
• ORACLE
Driver Version
Select one of the following depending on the Provider:
Provider
What to Select
MSSQL
The version of the database
ORACLE
12.2.0.1
Instance
The database instance name
* 
The Instance is only appears if you selected a Provider of MSSQL.
Authentication Mode
Enter SQL Server
* 
The Authentication Mode only appears if you selected a Provider of MSSQL.
Driver Type
Enter one of the following Driver Types, depending on the Provider:
Provider
Driver Type
MSSQL
Microsoft
ORACLE
THIN
Server
Enter the IP address or the name of the machine where the database is installed
Port
Enter the port number where the database server listens. The default ports for each Provider are:
Provider
Port Number
MSSLQ
1433
ORACLE
1521
SID
Enter the SID name
* 
The SID only appears if you selected a Provider of ORACLE.
Database
Enter the name of the Servigistics database
* 
The SID only appears if you selected a Provider of MSSQL.
Username
Enter the user name of the database
Password
Enter the password associated with the user name
Blank
Select the check box
Charset Encoding
EnterUTF-8
Is Default
Select the check box
Read Only
Select the check box
Pool Settings
Enter the following:
Pool Setting
Value
Initial Connection
5
Resubmit Time
30
Incremental Size
5
Max Connections
30
Encrypted
Select this option
Cache
Enter the following:
Cache
Action
Enable MetaData Caching
Select this check box
MetaData Cache Purge Frequency
Select Boot Up
d. Click Test. A message stating that the connection test succeeded should appear.
e. Save the connection.
3. Create a new MSSQL or ORACLE schema, named IntellicusRepository, to be used as the Repositorydb database connection and do the following to configure the Repositorydb connection:
a. Provide privileges to the ORACLE schema for the Repositorydb connection as follows:
GRANT CREATE SESSION TO <IntellicusRepository>;
GRANT CREATE TABLE TO <IntellicusRepository>;
b. Provide privileges to the MSSQL database for the Repositorydb connection as follows:
▪ The user must have Processadmin for both public and sysadmin
▪ The user must have the db owner role in the Repositorydb
▪ The user must have the default schema dbo in the Repositorydb
c. Click Add to make a new connection.
d. Enter the following values for the connection:
Field
Value
Connection Name
This is prepopulated and cannot be changed
Provider
This is either MSSQL or ORACLE depending on what was used to create the database
Driver Version
The version of the database
Authentication Mode
Enter SQL Server
* 
The Authentication Mode only appears if you selected a Provider of MSSQL.
Driver Type
Enter one of the following Driver Types, depending on the Provider:
Provider
Driver Type
MSSQL
Microsoft
ORACLE
THIN
Server
Enter the IP address or the name of the machine where the database is installed
Port
Enter the port number where the database server listens. The default ports for each Provider are:
Provider
Port Number
MSSLQ
1433
ORACLE
1521
SID
Enter the SID name
* 
The SID only appears if you selected a Provider of ORACLE.
Database
This is the name of the Repositorydb where the Intellicus data is stored. For example, IntellicusRepository
Username
Enter the user name of the database
Password
Enter the password associated with the user name
Blank
Select the check box
Charset Encoding
EnterUTF-8
Is Default
Clear the check box
Is Repository
Select the check box
Read Only
Select the check box
Pool Settings
Enter the following:
Pool Setting
Value
Initial Connection
5
Resubmit Time
30
Incremental Size
5
Max Connections
30
Encrypted
Select this option
Cache
Enter the following:
Cache
Action
Enable MetaData Caching
Select this check box
MetaData Cache Purge Frequency
Select Boot Up
e. Click Test. A message stating that the connection test succeeded should appear.
f. Save the connection.
4. Click OK when the dialog box appears requesting you to restart the Intellicus Report Server.
5. Do the following to restart the Intellicus Report Server:
a. Stop the Intellicus Report Server [view Linux instructions] [view Windows instructions]
b. Start the Intellicus Report Server [view Linux instructions] [view Windows instructions]
6. After the installation is complete, open a browser and enter the Intellicus URL. For example:
http://<MACHINE_NAME>:<port>/intellicus/
* 
For Linux, the port is set to 8080 by default. If port 8080 is already used then you can change the port number.
For Windows, the port is set to 90 by default. If port 90 is already used then you can change the port number.
7. Confirm that the Intellicus Report Server is running, [view instructions]
8. Perform the following optional steps:
9. Proceed with the PAI Foundation step.
Was this helpful?