Collect the required database information

Collect the database information that you are going to need during Case Analyzer installation and configuration. Add the information that you collect to the Installation and Upgrade Worksheet.

Case Analyzer supports publishing to the Microsoft SQL Server, Db2® for Linux®, UNIX and Windows, and Oracle databases.

Collect the following database information for your Case Analyzer installation and configuration:
  • The dedicated TCP/IP port number of the database instance used by Case Analyzer.
  • The name of the database server, if Case Analyzer is configured with a remote database.
  • If you use OLAP integration with Microsoft SQL Server:
    • The ca_db_administrator user ID and password for the Case Analyzer database instance. This ID is the user that is created in Creating a Case Analyzer database user for SQL Server.
    • The name of the Microsoft SQL Server Analysis Services server, if separate from the database server.
    • The name of the Microsoft SQL Server Analysis Services instance, if Analysis Services is configured as a named instance.