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

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Correct Answer
December 27, 2017 - 9:38am

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). 

Comments

Keep up to date on this post and subscribe to comments

November 13, 2017 - 1:46am

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

November 13, 2017 - 2:05am
Response to UjjwalShukla_GCS

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

November 13, 2017 - 3:00am
Response to BH.SURESH

December 27, 2017 - 9:38am

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).