Question

71
Views
Cloe Walker (CloeW938)
IT Solution Service

IT Solution Service
SG
CloeW938 Member since 2018 158 posts
IT Solution Service
Posted: August 26, 2020
Last activity: August 26, 2020
Posted: 26 Aug 2020 0:11 EDT
Last activity: 26 Aug 2020 8:10 EDT

What is package name of Connect SQL rule?

I used to use Oracle for database a lot and always typed "oracle" for package name in Connect SQL rule without thinking much. Now I use PostgreSQL a lot and want to create one. I tried to find one in the system but do not see any OOTB Connect SQL rule instances for PostgreSQL.

Should I enter "PostgreSQL"?

Package name

I understand Connect SQL can have its DBMS specific syntax but what if my SQL statement is generic and works on any DBMS (ie. DELETE)? In that case should I write "All", or "PostgreSQL"? Does this package name string actually matter? Or is this just informational and it doesn't affect anything? ("PostgreSQL" and "postgres" makes any difference?)

Thanks,

***Moderator: Pallavi to update platform capability tags***

Pega Platform 8.4 Data Integration