Repository Database Server Requirements
Go Up to Repository Installation
The following table lists the databases supported by the Repository. 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 Client Utility Software for 32-bit Repository |
Corresponding Client Utility Software for 64-bit Repository |
---|---|---|
IBM DB2 Universal 9.x, 10.x Server |
32-bit version of IBM DB2 UDB Client Utilities |
64-bit version of IBM DB2 UDB Client Utilities |
Microsoft SQL Server 2005 - 2014 |
32-bit client libraries are already installed on Windows machine. |
64-bit client libraries are already installed on Windows machine. |
Oracle 10g, 11g and 12c |
32-bit version of Oracle Client Utilities |
Both 32-bit and 64-bit version of Oracle Client Utilities are required. |
Oracle
- Configure your server in one of the Oracle configuration tools: Net Easy Config or Net Configuration Assistant.
- Create a connection alias.
Microsoft SQL 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.
IBM DB2
- Configure an ODBC data source entry for the IBM DB2 database that you want to access from ER/Studio Data Architect.
- Create a connection alias.
- 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 an 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.
Important Notes
- You must use ER/Studio Data Architect 9.x or later with ER/Studio Repository 6.x.
- The DBMS Client Utility software must be installed before installing the Repository server.
Note: 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.