Enterprise Repositories

Unlike standard repositories, enterprise repositories require an established database server with Oracle or Microsoft SQL Server. This allows you to store more analysis information in the same repository and support access by many more simultaneous users. Synthesis applications are compatible with Microsoft SQL Server 2005 or later and Oracle 10g or later (including the free Express editions of all of these).

To establish a database server, you will need to purchase an appropriate license package from Oracle or Microsoft. The license, as well the IT maintenance and support needed to establish the database server, is separate from the ReliaSoft license agreement and must be negotiated directly with Oracle or Microsoft.

As an alternative, you may choose to use the free versions of Oracle or SQL Server if the expected load for the database fits within the limited capabilities of the Express edition (as specified by Oracle/Microsoft). With the free editions, you can establish a functioning enterprise database on your own without making a large investment of time and resources. If your organization's needs grow beyond the capabilities of the Express edition, you can then upgrade to a more robust version with the appropriate IT infrastructure and support.

Tip: Although ReliaSoft cannot provide full documentation and support for third-party database platforms, we do provide a limited number of resources as a convenience for users who wish to explore the possibilities of an enterprise database implementation. For resources on SQL Server (including instructions for configuring the Express edition), see http://Synthesis.ReliaSoft.com/sql_server.htm. For resources on Oracle, see http://Synthesis.ReliaSoft.com/oracle.htm.

The following topics will be of interest to database administrators:

Creating a new enterprise repository on an established database server.
Three ways that Synthesis user accounts may be recognized by SQL Server (individual logins, group logins or Windows impersonation).
Upgrading an enterprise repository from Version 8.

The following topics will be of interest to all enterprise repository users:

Creating and using an enterprise repository connection file (*.rserp) to connect to an existing repository.
Monitoring the enterprise repository connection speed.