Hi Avinash,

If you know know database details then you can go to SMA>Node>Advanced>Database Management – displays the list of databases registered with PRPC

Now you can select the corresponding database and click on “Database Details” button to retrieve the Database details as shown below,

Note: If you are looking for the schema names then look into the context.xml file if your server is tomcat and in Data sources configuration if your server is WAS.

Kindly let me know if this is your requirement.

Regards,

Mahesh

Hi Avinash,

You can also check it from designer studio from Resources --> About Pega 7 --> System Information

Can you please elaborate on the requirement for us?

Hi Avinash,

You can use this piece of java code to get database specific details in your activity.

try {

ClassDefinition cd = tools.getDatabase().getClassDef("Rule-Obj-Class");

String dbName = cd.getDatabase();

DatabaseInformation dbInfo = tools.getDatabase().getDBInfo(dbName);

oLog.infoForced(dbInfo.getProductName());  //prints Microsoft SQL Server in my case.

}

catch(Exception e){

e.printStackTrace();

}

DatabaseInformation is a public interface and there are couple of methods in this interface to get additional details.

BR//

Harish

fyi - knowing the database at runtime using activity via java method.

ClipboardPage primaryPage = tools.getPrimaryPage();
String strClassName = "@baseclass";
String strDBProductName = "";
try {
  
  if ( ! tools.getParamValue("ClassName").equals("") ) {
     strClassName = tools.getParamValue("ClassName");
  } else if (primaryPage != null) {
    strClassName = primaryPage.getClassName();
  }

  strDBProductName = tools.getDatabase().getClassDef(strClassName).getDBProductName(tools);

  // default to Microsoft SQL Server
  String DBType = "MSSQL";

  if (strDBProductName.startsWith("Oracle")) {
    DBType = "oracle";
  }
  else if (strDBProductName.startsWith("DB2")) {
    DBType = "DB2";
  }
  //DB Product Name for 'PostgreSQL' 
  else if (strDBProductName.startsWith("Postgre")) {
    DBType = "postgres";
  }

 tools.putParamValue("DBType", DBType);
}
catch (DatabaseException de) {
 oLog.error("Unable to get database type for class: " + strClassName);
}

Can i make use of the OOTB function @(Pega-RulesEngine:DBSchemaUtils).pzIsPostgreSQLDB(tools) to check if the DB is postgres or not..

Just found an OOTB function pzGetDBTypeForClass (Re: Executing Connect SQL specific to a database) which tells us the Database we are running.