Vamsee Krishna Durbha (VKDURBHA)

VKDURBHA Member since 2012 5 posts
Posted: July 3, 2019
Last activity: July 9, 2019
Posted: 3 Jul 2019 13:15 EDT
Last activity: 9 Jul 2019 6:32 EDT

External database connectivity - Pega 8.1.3 & MS SQL Server 2017

We are building an application using PRPC version is 8.1.3 running on Pega cloud (Java:1.8)

Requirement: As part of the client requirement, our application needs to integrate with external database MS SQL Server 2017.

Approaches tried: We have tried installing the JDBC jar, created a DSS and restarted the app.

But still getting the same error:

Status Value: In order to connect to a specific external database, the Pega server must be restarted after the jdbc driver jar has been added to the classpath and the jdbc driver class name has been defined in prconfig.xml. e.g. database/drivers="oracle.jdbc.OracleDriver;com.sybase.jdbc4.jdbc.sybdriver" : code: 0 SQLState: 08001 Message: No suitable driver DatabaseException caused by prior exception: java.sql.SQLException: No suitable driver | SQL Code: 0 | SQL State: 08001

We have tried the above approach with the jar files below.



We are currently blocked, any inputs/solutions/suggestions for the above requirement would be appreciated. Has anyone tried the Pega 8.1.3 & MS SQL Server 2017? Please advice.

***Edited by Moderator Marissa to update SR Details***

Data Integration Cloud Services Support Case Exists
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.