Reporter

Use this window to set parameters for KANA Reports and the Reports scheduler. To open this window, click the Reporter icon in System Administration.

Parameters

You can configure a DSN or another type of driver. Reports is executed against whatever database is configured here. The default is the Response partition-configured database.

Reports server

Enter the same URL that you use for the Web Server; for example, localhost:8080/jreport. In this example, jreport is the virtual directory of your Web Server and localhost:8080 is the name of the host server.

 For more information on this server, see "Configure the Reporter Component" in the KANA Response Installation and Configuration Guide.

Start of Week

This day is used as the starting day when using the predefined date ranges of  "This Week" and "Last Week."  The default day is Sunday.

For example, if the Start of Week is Sunday and you run the This Week report on Wednesday, the report gives data for Sunday – Wednesday.  If you run the report Last Week on Wednesday it will give Sunday – Saturday of the last week.

Use other Database for Reporter Component

Indicates if another database will be used for Reports. Select  this check box if you are using another database.

Database Type

Indicates the type of database you will use. Select the type of database from the drop-down menu.

Database Name

Indicates the name of the database you will use. Enter the database name.

Note: The tnsname given for the IQ database must be a tnsname in the Response Oracle server. In order for the Response database server and the IQ database server to communicate with each other, the Response database server must have a tnsname pointing to the IQ database server. The tnsname must be the same as the tnsname created for the Report server.

Database Host

Indicates the database host location. Enter the database host name.

Database Port

Indicates the database port you will be using for Reports. Enter the database port number.

The SQL port default is 1433.

Oracle port default is 1521.

DB2 port default is 50000.

Database User Name

Indicates the name of the database user

Database User Password

Indicates the password for the database user

Database DSN

Indicates the Data Source Name (DSN) setting for your database. This system DSN is configured on your Reports server.

Save

Saves your changes

Test

Checks the connection of the Report server and the database for Reports

Cancel

Discards your changes

IQ Report DB Details

Database Type

Indicates the type of database you will use. Select the database type from the drop-down menu.

Database Name

Indicates the name of the database you will use. Enter the database name.

Database Host

Indicates the database host location. Enter the database host name.

Database Port

Indicates the database port you will be using for Reports. Enter the database port number.

The SQL port default is 1433.

Oracle port default is 1521.

DB2 port default is 50000.

Database User Name

Indicates the name of the database user

Database User Password

Indicates the password for the database user

Database DSN

Indicates the Data Source Name (DSN) setting for your database. This system DSN is configured on your Reports server.

Save

Saves your changes

Test

Checks the connection of the Report server and the database for reports

Cancel

Discards your changes

 

RL Report DB Details

Database Type

Indicates the type of database you will use. Select the database type from the drop-down menu.

Database Name

Indicates the name of the database you will use. Enter the database name.

Database Host

Indicates the database host location. Enter the database host name.

Database Port

Indicates the database port you will be using for Reports. Enter the database port number.

The SQL port default is 1433.

Oracle port default is 1521.

DB2 port default is 50000.

Database User Name

Indicates the name of the database user

Database User Password

Indicates the password for the database user

Database DSN

Indicates the Data Source Name (DSN) setting for your database. This system DSN is configured on your Reports server.

Save

Saves your changes

Test

Checks the connection of the Report server and the database for reports

Cancel

Discards your changes

 


Learn about mail receivers.

Learn about reporters.

Learn about mail senders.

Learn about rule processors.