Unable to establish connectivity to Postgresql data source from ServiceNow - Support and Troubleshooting

Unable to establish connectivity to Postgresql data source from ServiceNow Issue Unable to establish connectivity to Postgresql data source from ServiceNow.

This article explains how to set up the Data Source and troubleshoot any connectivity issues.

Resolution Follow the documentation for 'JDBC drivers for unsupported database formats'.

Extend the available JDBC driver options by creating a new choice list entry to specify the JDBC driver Java package name.

Navigate to System Import Sets > Administration > Data Sources. Click New. In the Data Sources form, right-click the Format field label, and select Show Choice List from the pop-up menu Click New in the list of choices. Provide the following values to create the new database choice. Look at the existing drivers for examples. Table : sys_data_source Label : Database name that appears as an option in the Format choice list, for example: Teradata . Value : Package name and class of the driver. For example, the value for TeraData is com.ncr.teradata.TeraDriver . Click Submit.(check screenshot below) The new data source now appears in the list of available JDBC formats.

Install a driver on a MID Server You can install a new JDBC driver JAR file to a MID server to access database formats that are not supported by default.

Navigate to MID Server > JAR Files. Click New. Complete the following fields: Name : A unique and descriptive name for identifying the file in the instance. Version : A version number for the file, if one is available. Source : Location of the JAR file for reference purposes. Source information is not used by the system. Description : Short description of the JAR file and its purpose in the instance. Click the paper clip icon in the banner and attach the JAR file to the record. Click Submit. Restart the MID Server service. The platform makes the JAR file available to any MID Server configured to communicate with the instance.

Now configure the data source with the right connection parameters .

If there are any issue such as below:

MID Server reported error: java.sql.SQLException: com.snc.automation_common.integration.exceptions.InvalidConnectionParameterException: Unable to load JDBC driver: Postgresql

Verify that the connection can be made successfully outside servicenow by running the below java program .This could be run from Eclipse IDE

import java.sql.Connection;

import java.sql.DriverManager; import java.sql.SQLException;

public class doIt { public static void main(String a[]){ try{ Class.forName("org.mariadb.jdbc.Driver"); //For customer: Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); ( try{ Connection con = DriverManager.getConnection( "jdbc:mysql:// : / "," "," "); //For customer: "jdbc:sqlserver:// :1500;selectMethod=cursor;databaseName=CM", " ", " ") System.out.println("Connected Successfully"); } catch (SQLException ex) { System.out.println(ex); } } catch (ClassNotFoundException ex) { System.out.println("Driver not found."); } } } //end