How to access the CustomerData database?
I want to see the indexes of tables that are located in the CustomerData database. In schema tools this DB is not present (the only available ones are PegaRules and PegaData), preventing me from checking those tables.
How can I gain access to the DB in schema tools? I'm aware that it doesn't have a BLOB but it points to the PegaData database and yet, I cannot find the tables in there...
Can anybody enlighten me?
Faisal
Accepted Solution
Updated: 3 Mar 2022 8:09 EST
Pegasystems Inc.
US
@FaisalM7 Starting with Pega 8.7, clients are able to access CustomerData using Schema Tool on Pega Cloud.
Pegasystems Inc.
GB
@FaisalM7Did you already check this Discussion?
Also can you check the original installation guides, eg Pega Platform 8.6 Installation Guide for Oracle WebLogic Server and Oracle . I believe it's mentioned around page 19.
I believe the schema tools will only look at the default ones.
You could try using query runner ,but prefix the Table name with customerdata schema name.
for ex : select count(*) from customerdata.table_name;
You can check you are using the same account to run queries in all the environments.
Please run this query in Query Runner and check the Account / user name:
SELECT CURRENT_USER
Accepted Solution
Updated: 3 Mar 2022 8:09 EST
Pegasystems Inc.
US
@FaisalM7 Starting with Pega 8.7, clients are able to access CustomerData using Schema Tool on Pega Cloud.