Connect SQL to DB Other than PegaRules Or PegaData
Hi Team,
We have a requirement to connect to external database (not PegaRules and PegaData). Created a database instance and connected to DB successfully.But when i am trying to execute the stored procedure using connect SQL. it is trying to connect to pegaData not the new database. Could you please help how to write a query to connect or suggest any changes need to be done for connecting to new database. We are using External SQL DB.
regards,
Suresh
Accepted Solution
Ness Technologies Inc.
IN
Pegasystems Inc.
IN
Hi There,
Please use Connector and Metadata Wizard to generate SQL related connector rules. There we will have option to configure external DB.
When the Wizard completed there will be generate activity.
Use one of those activity with RDB method.
We would be able to connect to external DB now.
Thanks,
Ujjwal
Ness Technologies Inc.
IN
Hi Ujwal,
Thanks for your response.
But in wizard it is asking for table name. But i need to query data base using stored procedure which has been written in DB. I dont have access to tables to give in wizard.
Could you please suggest approach
Regards,
Suresh
Pegasystems Inc.
IN
Accepted Solution
Ness Technologies Inc.
IN
Create a class and map that class with the table. If no table is there then, Create database table instance and mention database name and dummy table name(which is not required to be in the DB).
Create a class and map that class with the table. If no table is there then, Create database table instance and mention database name and dummy table name(which is not required to be in the DB).