How to change the schema name from public to custom schema in Pega BIX Data base output config

General
, , ,
1

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.

2

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;