Prev Next

Add Database Manager - ODBC

Pro Cloud Server connections to MySQL, Oracle and PostgreSQL databases require the use of ODBC DSNs, which are defined in the Windows 'ODBC Data Source Administrator (32-bit)' screen. If you are running the Configuration Client on the same machine as the server you can:

  1. Click on the Browse. button to open the 'Data Link Properties' dialog to build the connection string.
  2. Select the provider 'Microsoft OLE DB Provider for ODBC Drivers' and click on the Next >> button.
  3. Select the pre-defined System DSN from the 'Use data source name' field.
  4. Fill in the user name and password and select the 'Allow saving password' checkbox.

Defining a connection to a database under a DBMS

Notes:

  • All ODBC DSNs should be defined as SYSTEM DSNs, because the Pro Cloud Server runs as a Windows Service and User DSNs might not be available to the Pro Cloud Server
  • The step for filling in the user name and password might not be required if the user name and password have been saved with the ODBC DSN
  • The ODBC Data Sources button displays the Windows 'ODBC Data Source Administrator' dialog, which you can use to set up a new ODBC system data source to be listed on the 'Data Link Properties' dialog (if you are running the administration client on the same machine as the server); it is particularly helpful because it shows the 32-bit ODBC data sources
  • For MySQL  - make sure to adjust the MAX_PACKET_SIZE of your MySQL installation to be large enough to store the largest record in your database; this is needed in order for Enterprise Architect to retrieve and manipulate large records
    It is difficult for Sparx Systems to state a recommendation for this setting because it is dependant on the size of records in a user's repository; however, it is not unusual that a value of at least 200M is required
    Typically the largest records are stored in T_DOCUMENT and are the results of embedding a document or storing a baseline within the repository; the MAX_PACKET_SIZE setting is defined in MySQL's configuration file, 'my.ini' for Windows or  '~/.my.cnf' for Linux