Question
Nordea
SE
Last activity: 18 Jan 2017 1:56 EST
How to Access DB of Marketing VM
Hi,
I was tryning to access Database of Pega Marketing VM via SQL developer and it showed be below error:-
Unable to Recognized 'prpc' database. I have also imported third party JDBC driver for Postgre in SQL developer. Please find the attached screenshot for databse details.
Accepted Solution
Pegasystems Inc.
US
Hi Anand,
As per your screen shot the details are entered in the Oracle tab configuration not the Postgres, kindly try to provide the details in postgres tab.
Provide the database name in Hostname Proprietary information hidden/pega?
Regards,
Mahesh
Pegasystems Inc.
US
Hi Anand,
As per the screen shot the database name is "pega" and the user is "prpc". I think your sql connector is available in your system and the url your trying in the sql connector connection is through the IP of the VM not Proprietary information hidden.
Could you share the screenshots of the SQL developer configuration along with the IP of the VM machine so that it will be more clear about the issue.
Note: I hope you had imported the right driver jar based on the VM postgres installation version.
Regards,
Mahesh
Nordea
SE
Hi Mahesh,
Thanks for your quick response. I have attached 2 screenshots that will confirm my local IP and SQL developer configuration details. Please let me know if there is anything else you need.
As per the screenshot you can see the list of database is not getting loaded.
Pegasystems Inc.
US
Hi Anand,
As per the JDBC URL used in your resource configuration "prpc/password" is your user credentials and "pega" is your database name -> reference "Pega Marketing DB.jpg"
But in your SQL Developer configuration you are not providing database name i.e."pega", so kindly provide the database name in the hostname field as " Proprietary information hidden/pega?" to resolve your issue.
Note: Question mark is mandatory to identify the postgres database name in sql developer.
Reference : http://stackoverflow.com/questions/7592519/oracle-sql-developer-and-postgresql
http://stackoverflow.com/questions/21191687/postgresql-with-sql-developer-issue
Regards,
Mahesh
Accepted Solution
Pegasystems Inc.
US
Hi Anand,
As per your screen shot the details are entered in the Oracle tab configuration not the Postgres, kindly try to provide the details in postgres tab.
Provide the database name in Hostname Proprietary information hidden/pega?
Regards,
Mahesh
Nordea
SE
Thanks a lot Mahesh! it works now. I was providing the details in Postgre tab earlier but i was not aware that i have to use "pega" database name with "?" sign.
Host name should be exactly in the format you have mentioned - Proprietary information hidden/pega?
I have also contacted [email protected], however they have simply denied for any support. Rather they have asked me to download Personal Edition...:-). That was funny.
Thanks again for your help!
Pegasystems Inc.
IN
Hello Anand,
I think you want to connect to the database of pegamarketing VM which is provided as part of pega academy .
You can write down your queries to [email protected] so we have separate team who will help you with the details .
Thanks,
Arun