Question
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
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
Accepted Solution
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).
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