Question

1
Replies
240
Views
hksoneji Member since 2009 3 posts
Prime Therapeutics
Posted: 3 years ago
Last activity: 3 years ago
Closed
Solved

Connecting Pega to SAS 9.4

JDBC/RDB interface for some reason does not return column names to Pega causing errors in creating resultset.

1. Install and configure SAS JDBC drivers

2. Create database rule using jdbc url

jdbc:sasiom://sashost:7591

3. Create a class and map the class to database table

4. Create a Browse SQL query to retrieve a result set

5. Observe that the column names are not returned. The query results will load successfully on the clipboard, except there is no way to map these for application use.

Data Integration
Moderation Team has archived post
Share this page LinkedIn