Discussion
Last activity: 18 Nov 2015 6:30 EST
SQL Connector as Source for Data Page
PRPC PersonalEdition 7.1.9
When I create the new data page with a Source = Connector, I don't see the SQL in the Type list.
Is it a bug or is it a feature? ( SQL is present at version 7.1.7 )
TIA


Department of Planning and Environment
AU
Hi Alex,
you should be able to see "SQL" when Connector is used as a Source. The property pyConnectorList holds the selected connector. Can you trace the activity pzGetDataSource / pzGetValidSourceTypes and check if you are seeing this list actually flowing?
I dont this this feature is removed in 7.1.9
Regards,
Krish


Pegasystems Inc.
IN
connect-sql and connect-ejb have been deprecated from ML8 (7.1.8).


Department of Planning and Environment
AU
Thanks Shashi for letting us know! Is this information available in any documentation?
i was referring https://pdn.pega.com/sites/pdn.pega.com/files/help_v719/procomhelpmain.htm#basics/basics2/preface/deprecated.htm
and cant find it there.
Regards,
Krish
Thanks.
But , I need to populate Data Page by external stored procedure.
How can I do it ?
TIA
Alex


Pegasystems Inc.
US
Hi Alex,
You will need to build and use a custom SQL Connector Rule Instance to use a Stored Procedure for a Data Page and then use the new SQL Connector Rule as the Data Source for the Data Page.
Regards,
Henry
Pega Academy
Hi Henry,
I did it exactly as you wrote in version 7.1.7, but in 7.1.9 - subj
Regards,
Alex


Incessant Technologies
IN
Hi Alex,
You can refer an activity in which you can call your Stored procedure or connect sql rule.
Hi, Bende.
Of course, I'll use Activity.
To stop using Best Practice, Pega deprecated SQL-Connector for Data Page Source :-)
Best Regards,
Alex
HI ,
There is no feature for SQl to be in the list when Source= "Connector" .
Regards