Question
4
Replies
1054
Views
Posted: November 11, 2017
Last activity: December 27, 2017
Closed
Solved
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 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