Following installation steps describes how to install IFS Provided SQL Server Reporting Services Extensions in SQL Server Reporting Services instance. This installation enables
This is an optional installation that should run in Reporting Services instance locally. Currently supported versions of SQL Server are
IFS provides four SQL Server Reporting Services extensions.
This extension is responsible for authenticating the IFS Application users via the Extended Server. This extension is used together with Authorization extension when the IFS Application is configured to use Database or Simple LDAP authentication.
This extension is responsible for authorizing resource access for Reporting Services users. It is used together with Authentication extension when the IFS Application is configured to use Database or Simple LDAP authentication.
This extension is required to use IFS Applications as a custom data source in Reporting Services. This is supported by the following authentication mechanisms used by IFS Applications.
This extension is present only when IFS provided SQL Server Reporting Services Operational Reporting (SSRSOR) is available and it is required in using SQL Server Reporting Services Operational Reports. This is supported by the following authentication mechanisms used by IFS Applications.
These extensions can be installed using the IFS – MS SQL Server Extensions Installer. The installer can be accessed from
<Build_Home>/Win32Server/SQL
Server Extensions/Install/IFSBISSExtInstaller.exe
Note: The installer will install/configure the required extensions based on the IFS Applications authentication method. Selection of individual extensions is not supported. The installer should run by the same user as Logon User of the SQL Server Reporting Services service and it should run on the server machine which has reporting services installed.
If SQL Server Reporting Services Operational Reporting (SSRSOR) module is
available then the Start Page will look as follows
Select the instance which needs to be modified.
Based on the selection some of the install steps will be disabled
Note: In order to go ahead with the rest of the steps, it is required that the servers (E.g., Extended Server, Reporting Server etc.,) to be up and running. Else the validations will fail and will not proceed further.
Configuration Name | Description |
---|---|
Extended Server URL | The URL of the IFS Applications - Extended Server access point |
SSRS Host | The host URL of SQL Server Reporting Services |
SSRS Report Server | The URL SQL Server Reporting Services Report Server. This will be automatically suggested when SSRS Host is specified. |
Web Service Descriptor | The URL of SQL Server Reporting Services web service (2010) access point. This will be automatically suggested when SSRS Host is specified. |
Use SSL to transfer credentials to Report Server from login page | When this check box is selected, Secure Socket Layer (https) will be used while transferring credentials |
SSRS Administrator | The new administrator of SQL Server Reporting Services
instance. This user will have all the rights in Report Server,
should be a valid IFS Applications User. Note: Remember that the existing SSRS administrator will be removed by this installer. |
Username | Username for fetching DB, Domain User mappings for DB
Authentication. (Should be an IFS Applications user with minimum rights
to access the activity BrowseIfsbiSsrsUserMappings).
(The system defined user, "SSRSINTUSER " is
recommended to be use for this purpose.) |
Password | Password for fetching DB, Domain User mappings for DB Authentication |
Note: Proper mappings should be done in Oracle and Domain User mappings for Reporting Services window in IEE.
It is required to configure following parameters.
Configuration Name | Description | ||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Extended Server URL | The URL of the IFS Applications - Extended Server access point | ||||||||||||||||||||||||||||||||||
SSRS Host | The host URL of SQL Server Reporting Services | ||||||||||||||||||||||||||||||||||
SSRS Report Server | The URL SQL Server Reporting Services Report Server. Will be automatically suggested when SSRS Host is specified. | ||||||||||||||||||||||||||||||||||
Web Service Descriptor | The URL of SQL Server Reporting Services web service (2010) access point. Will be automatically suggested when SSRS Host is specified. | ||||||||||||||||||||||||||||||||||
Use SSL to transfer credentials to Report Server from login page | When this check box is selected, Secure Socket Layer (https) will be used while transferring credentials | ||||||||||||||||||||||||||||||||||
SSRS Administrator | A valid IFS Applications user that will act as the new administrator of
the SQL Server Reporting Services instance. This
user will have all rights in Report Server. Provide the Identity of the
appointed IFS Application user.
Internally in SQL Server Reporting Services, the username will be set according to the "User name format".
Note: Remember that the existing SSRS administrator will be removed by this installer. If the mapped identity is changed, installer should be re-executed. |
||||||||||||||||||||||||||||||||||
Username | The Identity of an IFS Applications user
with minimum rights to access the activity BrowseIfsbiSsrsUserMappings.
This user is used for fetching Domain User mappings, FndUser
information from IFS Applications. (The system defined user, "SSRSINTUSER " is
recommended to be use for this purpose.) |
||||||||||||||||||||||||||||||||||
Password | Password related to Username | ||||||||||||||||||||||||||||||||||
Use the default user identities configured in IFS Applications for LDAP authentication | DIRECTORY_IDENTITY of the FndUser
will be set as internal SQL Server Reporting Services username |
||||||||||||||||||||||||||||||||||
Username format | Template to be used to format usernames/user identities
configured in IFS Applications. Valid template values are {USER_IDENTITY}, {DIRECTORY_IDENTITY}
E.g.
|
There are no parameters to configure when using Windows Integrated Authentication.
After reviewing the installation settings, select Extension Installer and click Next. This will start the actual installation/configuration
Note: It is important to make sure the settings are valid before starting the actual configuration/ installations because it is not possible to rollback the modifications automatically, once it is done. You have to either do it manually or by uninstalling the Report Server instance.
During the installation, status messages will be displayed in this window.
Now the installation/ configuration is over. During this step it is possible to open the installation log.
Note: Restart the SQL Server Reporting Services service after the installation.