Custom Integrations with JDBC
Connect Agiloft to external systems and database with the generic JDBC driver. This acts as a wrapper for the REST - Search operation.
Prerequisites
An Enterprise license is required to use REST and the JDBC driver.
JDBC Driver
This driver can be used in any application. It supports SELECT operations.
You can access the current version of the driver here: https://www.agiloft.com/utils/agiloft-jdbc-driver.jar
Settings and Parameters
The driver has these settings:
- Driver class name: com.agiloft.jdbc.adapter.AgiloftDriver
- URL for connection: jdbc:agiloft:schema.https={is_https};schema.loginDomain={server_url};schema.kb={KB_name};schema.user={user_name};schema.password={password}
Where the parameters are:
- is_https: true if the connection is through HTTPS, false otherwise
- server_url: address of the server (if HTTPS is used, there is no need to add 443 port)
- KB_name: name of the Agiloft KB
- user_name: username of Agiloft account
- password: password for Agiloft account
For example, you might use: jdbc:agiloft:schema.https=false;schema.loginDomain=localhost:8080;schema.kb=CLM Template;schema.user=admin;schema.password=qwerty
This example driver is used in the following Java sample program:
Java Example
public class DriverUsecase {
public static void main(String[] args) throws SQLException {
String url = "jdbc:agiloft:schema.https=true;schema.loginDomain=sandbox2.agiloft.com;schema.kb=CLM Template;schema.user=admin;schema.password=qwerty";
Connection connection = DriverManager.getConnection(url);
String sql = "select count(*) from company";
PreparedStatement statement = connection.prepareStatement(sql);
ResultSet rs = statement.executeQuery();
while (rs.next()) {
int value = rs.getInt(1);
System.out.println("count(*) of company = " + value);
}
}
}
Here's an example using Python instead:
Python Example
import os
import jaydebeapi
def run_sql(sql):
'''Sample function to run SQL query'''
driver_class = 'com.agiloft.jdbc.adapter.AgiloftDriver'
jar_file = 'C:\\agiloft-jdbc-driver.jar'
jdbc_url = ("jdbc:agiloft:schema.https=false;schema.loginDomain=localhost:8080;"
"schema.kb=Demo;schema.user=admin;schema.password=qwerty")
conn = jaydebeapi.connect(jclassname=driver_class, url=jdbc_url, jars=jar_file)
cursor = conn.cursor()
cursor.execute(sql)
return cursor.fetchall()
company_count = run_sql("select count(*) from company")[0][0]
print("Total companies = %s" % (company_count,))