Question
JDBC connection to Terradata from Pega 8.1.5
when trying to connect to Terradata from Pega 8.1.5, we are getting below error message.
ERROR - Section 'TestConnectionResults' execution error on page 'ClassConnectionStatus' of class 'Code-Pega-ConnectionReport'. com.pega.pegarules.pub.database.DatabaseException: Database-General Problem retrieving schema information for database XXXXX , table AAAAA.BBBBB 3523 42000 [Teradata Database] [TeraJDBC 15.10.00.14] [Error 3523] [SQLState 42000] The user does not have SELECT access to DBC.UDTInfo. DatabaseException caused by prior exception: java.sql.SQLException: [Teradata Database] [TeraJDBC 15.10.00.14] [Error 3523] [SQLState 42000] The user does not have SELECT access to DBC.UDTInfo. | SQL Code: 3523 | SQL State: 42000
***Edited by Moderator Marissa to update Content Type from Discussion to Question***
Pega does have any support for Teradata - nor have we tested against it. That said, hopefully someone who has got this to work can weigh in here.
What does you data source look like? I think your url should look like this -> url="jdbc:teradata: ..." and driverClassName s/b com.teradata.jdbc.TeraDriver