Related Topics:

Creating a New Enterprise Database

Opening an Existing Standard Database

Connecting to an Existing Enterprise Database

If your organization already has created an enterprise database on Oracle or Microsoft SQL Server and you have an active user account for the database, you can connect to the database as explained in this topic. When you are connected to an enterprise database, a connection speed indicator will be displayed in the MDI status bar.

< 30 ms: Good (acceptable performance)

30 - 70 ms: OK (may exhibit some delays in operations, opening/closing windows, etc.)

70 - 110 ms: Slow (will exhibit some delays in operations, opening/closing windows, etc.)

110 - 150 ms: Very slow (will exhibit significant delays in operations, opening/closing windows, etc.)

> 150 ms: Extremely slow (will result in unacceptable performance and usability)

Connecting for the First Time

Choose File > New > Create a new enterprise repository connection file.

This command creates a Synthesis repository connection file (*.rserp) that is stored locally on your computer; the file contains all of the necessary information for connecting to the enterprise repository. Once this file is created, it can be used to connect to the database and to import from or export to the database.

Specify the name for the connection file, then choose the database type and version (i.e., Microsoft SQL Server 2005 or 2008, or Oracle 10 or 11).

Select the Always start by connecting with the last repository check box if you want to connect to the last database you used the next time you launch the application. The database will open automatically if the connection information is valid and your user account is active. If you are using an Oracle database and the current Windows login credentials cannot be validated, the software will display a window that allows you to type a different domain, username and password, if appropriate. You may need to use this option, for example, if you are logged in to your personal home computer but you are trying to access a database on your company’s network via VPN.

Once you have connected to the database, you can manage user accounts by choosing File > Manage Repository > Authorized Users.

Reconnecting

To connect to an enterprise repository that you have already connected to, choose File > Recent and in the Recent Repositories list, choose the *.rserp file. You can also choose File > Open Repository and then browse for the *.rserp file.

Tip: It is important to note that the domain is part of your database login information. For this reason, if you anticipate that you will need to connect to an enterprise database from a computer that is not on the same domain, you should make arrangements in advance to set up an alternative login that you can use to access the database from other domains.

Connection Issues

If you are unable to connect with an existing enterprise database, you may be encountering any of the following issues:

 

© 1992-2013. ReliaSoft Corporation. ALL RIGHTS RESERVED.