How to change the schema name from public to custom schema in Pega BIX Data base output config
Hi All,
we were trying to configure the BIX using the data base as output source. While we generated the DDL we can see the tables are getting created in Public schema rather than in custom schema .
is there any way to configure the schema names for BIX DDL ?
External data base is connected via JDBC URL.
***Edited by Moderator Rupashree S. to add Capability tags***
To see attachments, please log in.
Posted: 3 weeks ago
Empower Retirement
Empower Retirement
IN
This issue got resolved by changing the default schema to custom schema using the below script and done a test connectivity in the data base instance.
ALTER DATABASE db_name SET search_path TO schema_name;