Additional Components
This article defines all additional components of Spreadsheet Server.
Required Components
The following component is required:
Application Configurator
A single installation of Application Configurator for Spreadsheet Server must be completed by the administrator, and each user must be established and assigned a valid license key prior to using Spreadsheet Server. Contact the security administrator for the network location of the security and connections file.
Optional Components
Based on the database type to which Spreadsheet Server and/or Query Designer is connecting to, additional software components may be required prior to processing. Contact your IT department to determine what is required to be installed.
Data Source Name (DSN) Database
From the desktop, navigate to Start > Control Panel > Administrative Tools > Data Sources (ODBC) to create the DSN.
iSeries DB2 Database
Both the ODBC and the OLEDB provider components of the IBM iSeries Access for Windows (formerly named Client Access Express) must be installed on each user's machine. Run the setup program within IBM iSeries Access for Windows to determine that the ODBC and OLEDB provider components are installed.
Microsoft Access Database
No further software is required to provide connectivity to an Access database (MDB file).
Microsoft SQL Server Database
No further software is required to provide connectivity to a SQL Server database, as the ODBC driver used is already loaded with Windows.
Oracle Client
No further software is required to provide connectivity to an Oracle database, as insightsoftware provides a direct connection. However, if you desire to connect to the Oracle database via the Oracle Client ODBC provider, the Oracle Client software must be installed on each user's machine. Within Oracle Client, configure the local service name, and assign the appropriate host name and port number.
SAP Database
To access a SAP database in Spreadsheet Server, SAP Netweaver 7.0 or higher must be installed.
- Disk space requirements on the server are negligible (less than 10 MB).
- The SAP adapter is imported to the system via an SAP transport in the
/ZGLBSOFT/reserved namespace. This is an SAP approved mechanism for third-party software, which ensures no standard or custom code is overwritten on the customer system. - No additional servers or server hardware is required.
Optional Components When Using Distribution Manager
The following components are optional if using Distribution Manager:
Distributor Outlook Add-In
For Excel users utilizing Outlook, the Distributor Outlook Add-In is a prerequisite for Distribution Manager. If it is not installed, the Distribution Manager Settings function will force the installation of the Distributor Outlook Add-In, prior to allowing the user to select Microsoft Outlook Exchange as the Email Server option.
Microsoft Collaboration Data Objects
For Excel users utilizing Outlook, Microsoft Collaboration Data Objects (CDO) is a prerequisite for Distribution Manager. If it is not installed, the Distribution Manager Settings function will force the installation of CDO prior to allowing the user to select Microsoft Outlook Exchange as the Email Server option.
Optional Components When Using Profile Scheduler
The following component is optional if using Profile Scheduler:
Microsoft Command Line Utilities for SQL Server
Microsoft Command Line Utilities for SQL Server is an optional component. However, when it is loaded on the same machine as Profile Scheduler, the Profile Scheduler component takes advantage of the tools in an effort to increase processing speed and performance.