Question5Replies103Views×Close popoverchamila fernando (chamilaf) Virtusa Virtusa LK View Profile chamilaf Member since 2015 6 posts Virtusa Posted: January 24, 2017Last activity: February 3, 2017Posted: 24 Jan 2017 4:33 ESTLast activity: 3 Feb 2017 9:43 EST Closed Solved Want to connect to SMA to configure a DB but not successfulGuys, I wanted to connect to SMA to config a DB but never could get it done or could not find the SMA war file to deploy.However I could get DB driver installed with out SMA. See below if that is what you want to do.https://www.pegaxchange.com/tag/pega-7-external-database/(3rd point onwards) 3. Configuration of Connection to MySQL Server in Pega 7 PRPCregards***Moderator Edit: Vidyaranjan | Branched comment from thread to create a new one, also updated Categories*** Data Integration ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 4 years agoPosted: 24 Jan 2017 5:15 EST×Close popoverPankaj Rawal (rawap) PEGA Sr Architect, Case Management Pegasystems Inc. IN View Profilerawap PEGA replied to chamilafI am little confused on the role of SMA with the article. SMA war file should be ideally present in the distribution image itself. Could you be little clear in the exact issue that you are facing? Let me know if I am missing anything here. Posted: 4 years agoPosted: 24 Jan 2017 6:05 EST×Close popoverShanthini Charles (Shanthini_Charles) PEGA Principal Technical Solutions Engineer Pegasystems Inc. IN View ProfileShanthini_Charles PEGA replied to chamilafHi, As per https://pdn.pega.com/troubleshooting-sma-does-not-display-managed-connections do you want to check your Database connection in SMA? First you need to deploy the SMA war file and then open this in Internet Explorer. SMA is found under the archives folder as prsysmgmt.war/ear file. Please deploy it based on your application server. However the article describes in great detail how to use Connector and Metadata Accelerator Wizard. Regards, Shanthini Charles Posted: 4 years agoPosted: 24 Jan 2017 7:27 EST×Close popoverRajeev Ranjan (ranjr) PEGA Principal Technical Solutions Engineer PEG PL View Profileranjr PEGA replied to chamilafSMA war file will be in Archive folder of the media. You take that war or ear( depending on the server), then deploy it on that. After deploying, http://<hostname>:<port number>/prsysmgmt/getnodes.action Now here you will have add node option. You could configure sma to monitor any PRPC node. Posted: 4 years agoPosted: 24 Jan 2017 7:52 EST×Close popoverSaran Kolla (SaranKolla) PEGA Senior Technical Solutions Engineer Pegasystems Inc. IN View ProfileSaranKolla PEGA replied to chamilafHi, I didn't understand your question exactly. But there is no relation between SMA and DB installation. using SMA we can see the PRPC DB details with below navigation. Advanced--> Database Management you can also view the tables of the DB with Advanced--> Database Table Information tab Accepted Solution Posted: 3 years agoPosted: 31 Jan 2017 6:44 EST×Close popoverchamila fernando (chamilaf) Virtusa Virtusa LK View Profilechamilaf Virtusa replied to SaranKollaSorry for the confusion. I needed to access SMA to install MYSQL driver to make the connection. Personal edition did not have SMA bundled so I had to find other ways. I managed to install the driver as per the link given in my original post and re-shared for others. Hope this clears the doubt. This thread can be closed.