Working with Event Policies and Actions › Create an Event Policy with an Enrichment Action › Create a Database Enrichment Action › JDBC Connection Examples

JDBC Connection Examples

The following list provides the common values that you can use as templates for establishing connections with the database types supported for enrichments. You can also leverage the information in the Templates drop-down list to populate the connection fields with the template text.

Microsoft SQL Server

• Class Name: net.sourceforge.jtds.jdbc.Driver
• Connection: jdbc:jtds:sqlserver://server01:1433/SAMStore

OR

• Class Name: com.microsoft.sqlserver.jdbc.SQLServerDriver
• Connection: jdbc:sqlserver://server01:1433;databaseName=MyDB

Oracle

• Class Name: oracle.jdbc.driver.OracleDriver
• Connection: jdbc:oracle:thin:@server01:1521:MyDB

  Note: Oracle 10.x uses port 1521, while Oracle 11.2 uses port 1045.

MySQL

• Class Name: com.mysql.jdbc.Driver
• Connection: jdbc:mysql://server01:3306/MyDB