Edge Documentation

This section describes the tasks that you must perform to use SQL Anywhere with enPortal:

Downloading the Sybase JDBC Driver

After you have installed enPortal, you must download a JDBC driver that will enable enPortal to establish a connection to your Sybase database.

To install the JDBC driver:

1. Access the Sybase JDBC driver files at the following location: http://www.sybase.com/products/informationmanagement/softwaredeveloperkit/jconnect
2. Download the jConnect zip file to your local filesystem.
3. Locate the file jconn3.jar within the jConnect zip file.
4. Extract the file jconn3.jar and place it in the folder PORTAL_HOME/classes-custom/

Installing Sybase SQL Anywhere on Windows

To install Sybase SQL Anywhere on Windows systems:

1. Copy or unzip the Sybase installation files to a temporary folder.
2. Go the temporary folder where the installation files were unzipped and run setup.exe. The Welcome window opens. Click Next.
3. After reading the license agreement terms, click Yes to proceed with the installation.
4. On the Select Components window, select only the following components:
   1. Under the Databases node, select Adaptive Server Anywhere for Windows.
   2. Under the Synchronization node, select SQL Remote for Adaptive Server Anywhere.
5. Click Next. The Choose SQL Anywhere 8 Location window opens.
6. Specify the directory where SQLAnywhere 8 should be installed and click Next. The Choose Shared Components Location window opens.
7. Specify the directory where shared components should be installed and click Next. The Select Program Folder window opens.
8. Click Next unless you want to change the name of the program folder.
9. On the Server License window, enter the appropriate details.
10. The Start Copying Files window opens. Review your prior selections. Click Next if all items are correct or Back to change any information.
11. Click Finish on the next window that opens. The installation process begins. You will need to reboot your computer after the installation process is complete and before you proceed to the next stage.
12. Create a Sybase data archive file as outlined in the next section, Creating a Database.
13. Place the data archive file in a directory under the main Sybase directory, for example: sybase home directory/SYBSsa8/