JDBC Drivers can be installed in Ambience by the following steps (example used: SQL JDBC Driver)
Note that:
- Step 1 to 5 is for driver installation
- Step 6 to 10 is for creating a new connection pool using the installed driver
==============================================================================
1/ Place the JDBC driver in /ElixirAmbience/lib folder.
2/ Restart Ambience server to load the jar file .
3/ Log in as admin to enable the driver
4/ Click on Admin → Drivers tab
5/ Find the driver name and tick the box to enable it accordingly. e.g: SQL Server (Microsoft 2005+)
6/ Start Ambience Designer
7/ Go to a folder in the folder tree on the left hand side, right click → Add → Connection Pool
8/ Input the name of the connection pool
9/ Choose the driver. e.g: SQL Server (Microsoft 2005+)
10/ Lastly, input the URL, User and Password before testing and saving the connection.