HI ,

There is no feature for SQl to be in the list when Source= "Connector" .

Regards

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

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

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

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

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