Repository Database Server Requirements
Go Up to Repository Installation
The following table lists the databases the Repository supports. In order for the Repository to communicate with the database, the machine running the Repository must also have the corresponding RDMS client utility installed. The RDMS client utilities must also be installed on the machine running ER/Studio Data Architect if you want to use ER/Studio Data Architect to reverse engineer databases originating at any of these platforms.
|
ER/Studio Repository Database Server Requirements | |
|---|---|
|
Supported Repository DBMS |
Corresponding RDBMS Client Utility Software |
|
IBM DB2 Universal 9.x, 10.x Server |
Corresponding version of IBM DB2 UDB Client Utilities |
|
Microsoft SQL Server 2005 - 2014 |
Corresponding version of SQL Server Client Access |
|
Oracle 10g, 11g and 12c |
Corresponding version of Oracle Client Utilities |
Important Notes
- ER/Studio Repository has been certified to work with the above database platforms using 32-bit versions of the database client software. The 64-bit clients are not supported.
- If you install the ER/Studio Repository Server and the ER/Studio Repository database on the same machine, consider surpassing the hardware requirements described previously.
- You must use ER/Studio Data Architect 9.x or later with ER/Studio Repository 6.x.
- If you are upgrading ER/Studio Repository and are also using ER/Studio Portal, upgrade ER/Studio Portal to the latest version.
- The RDBMS Client Utility software must be installed before installing the Repository server.
- If you are using Microsoft SQL Server and use case-sensitive nomenclature, you may get connection error messages from the Repository. To avoid this, create an empty database with a non-case-sensitive character set (such as Latin_General_CI_AS), then initialize the database with the Repository Database Maintenance utility.
- For an IBM DB2 UDB 7.x server, the machine where your DB2 instance resides must have the C++ compiler for the Stored Procedures to work correctly.
- For all versions of an IBM DB2 UDB server, to ensure optimal Repository performance, you must have a user temporary tablespace and the database must be tuned so it does not run out of memory or log space. For more information, see Preparing to Install ER/Studio Repository.
- For all versions of IBM DB2 UDB server, the client connection to the Repository database must be registered as a system ODBC Data Source. The data source name must match the Database Alias specified in the client connection.