How to install and start SQL Power Architect Enterprise

 

 

Quick Start Method
(recommended for evaluating the product, or for use with small workgroups of 1-3 people and 1-2 workspaces)

Once you have downloaded the architect-enterprise_X.X.X.zip file, it will unzip to a folder called architect-enterprise_X.X.X. Move this folder somewhere safe (that is, to somewhere that you can keep it in the same place while you're using it).

Inside the architect-enterprise_X.X.X folder you will find the server start scripts. On Windows, you should execute the script file named startup-server.bat. On Linux machines, this would be startup-server.sh. Within a few moments, the following dialog should appear:

Simply press the Start button, and wait until the "Server is ready" message appears. This message should provide the URL you can use in order to connect to the server and obtain the client software.

If you want to change the location of extracted files and settings of the server, update the Server Home Directory field to a valid directory.

Important note: if you are running the server on Linux, you may need to increase the maximum number of file handles allowed to the server process. See our troubleshooting guide for detailed instructions.

 

Production Deployment Method
(recommended for use in a production environment, with 4 or more users, or when there are more than a small handful of workspaces)

For proper production deployment, you will need a Java web server such as Apache Tomcat, JBoss, or Glassfish. You will also need a JDBC-accessible database server such as MySQL, where the server will store its workspace data.

See our Production Deployment Guide for detailed instructions.

Important Note: If you are deploying on Apache Tomcat 6, there is a bug that prevents the server's welcome page from displaying. The following workaround fixes this issue:

1. Ensure Tomcat is not running.
2. Open /path/to/tomcat/conf/context.xml in a text editor.
3. Add <Loader delegate="true"/> after the <Context> tag.

 

How to Connect to the Server

Now that you have a server up and running, the next step is to launch the SQL Power Architect Enterprise Edition Client application, and open a server workspace.

1. In a web browser on any computer, go to the server's welcome page by typing in the URL displayed with the "Server is ready" message above. You should see the following:
   
2. Click the SQL Power Architect icon to launch the Enterprise Edition Client. Within a few moments, the familiar Play Pen window should appear on your screen.
3. To connect to the server, use the Enterprise -> Configure Server Connections... menu item. It will bring up the Server Connections dialog:
   
4. Press the Add... button. It will bring up the Server Connection Properties dialog:
   
5. Enter the information given on the server welcome screen, then press the Test Server button. The test should succeed.
6. Press OK to dismiss the Server Connection Properties dialog.
7. Ensure your new server connection is selected in the Available Server Connections list, then press the Login button.
8. After a few seconds, the list of workspaces on your server will appear. Either select an existing project, or create a new one (If this is a new installation, the list will be empty so you will have to create a new project).
9. At this point, you are done with the setup and you're ready to use all the features of SQL Power Architect Enterprise Edition!