You can provide the name of the production database schema in a data connection definition. Provide the name of the production database schema in the following cases:
The development database and the production database are identical except for the schema name.
You plan to use BIRT iHub administrator dashboard reports and the PostgreSQL database needs the schema name.
On the Data source connection properties page, in Schema (optional), type the schema name in the form MyCatalog, MySchema or browse for the schema. The schema name you provide overrides the schema name stored in the maps and is applied at run time to maps of database tables and views.
The schema name is not applied to maps of native SQL queries or to maps of stored procedure result sets. The schema name in these maps must be edited manually before you publish the project to the volume. Do not provide a schema name if the maps in your project use more than one database schema.
The development database and the production database are identical except for the schema name.