Skip to end of metadata
Go to start of metadata

In most companies, there are many different databases that can be used for reporting. We refer to these databases as the Reporting databases.

To report off of these databases, you need to ensure that you have the connection information and a user account to that database that has at least reading rights to the data you want to use. This information is usually obtained from your Database Administrator.

In the Linux pattern described here, we use a Sybase ASE 15.7 Reporting database. This resides on a different server than our CMS and Auditing databases, and must be configured and tested separately.

We generally recommend that you not host the CMS and Auditing databases on the same database server as your Reporting databases. This avoids competition for resources since the CMS and Auditing databases are critical to the health of your system.

Details on the Reporting database used in our Linux pattern

Reporting Database Overview for our Linux pattern

Version

Sybase ASE 15.7

Database Name

TPCU0067

Character Encoding

UTF-8

Page Size

8KB

Server Name

SybaseClient

Machine

Pgrepdb03

Username

Guest

For more information on tuning your reporting database server, refer to the vendor's documentation. Sybase ASE 15.7 Documentation includes the documentation we used when setting up this pattern.

  • No labels