Maximizing OASIS Performance Over Remote Connections

There are three processes that can help maximize performance when remote connecting or using OASIS Cloud Services. These include using the latest installers, connecting to the right driver, and enabling db caching.

Users can also optimize OASIS database connections by setting compression and optimizing buffering for low bandwidth connections. For more information, click here.

Using the Latest Installer

Use the latest installers (2.7.3) to take advantage of driver updates on the installer. If your OASIS shows anything other than 2.7.3 in the Program files folder, then it is worth uninstalling and reinstalling. The latest installers can be found at www.oasissalessoftware.com/OASIS/install

Connecting to the SAJDBC Driver

Please skip this process if you are hosted by Ingen Software, as your connection information will be unique. Otherwise connect to OASIS via the SAJDBC driver. It is the most stable to date. To change to this driver, complete the following steps:

1. Navigate to the Configuration page.

2. Select "Software" from the drop-down list.

3. Select "Database Connection."

4. The "Database Login" window will appear.

5. Enter the following information:

• Kind- SAJDBC
• Server- IP address of your DB server
• Port- oasis@2638
• User- oasis
• Password- oasis

6. Select "OK."

7. Close OASIS.

8. Go to "My Computer" or "This PC" and open the "C:" drive on your computer. For Windows Vista/7/8/10, the next folder will be "Users".

9. Open the folder of your login name.

10. Open the ".oasis" folder.

11. Locate and highlight the "lib" folder, and then select the "delete" key.

12. Restart OASIS.

Enable DB Caching

1. Navigate to the Configuration page.

2. Select "Software" from the drop-down list.

3. Select "Preferences."

4. The "Workstation Settings" window will appear.

5. Select the "Database" tab.

6. Check the "Cache database calls" box.

7. Select "OK."

8. Restart OASIS.