Database Schema in Birt Library

Monica D

Hii,
We are having two database servers with same table structures but different url and schema names.
Reports in Birt require schema to be mentioned in Queries.
Can we specify schema name (Like Database Url) in birt library so that by changing schema name only in Birt Library rest of our reports work properly?

Thanks & Regards,
Monica Dayaramani

johnw

You don't need the schema name in your query, but the query builder does put it in there by default. This is all going to depend on your database platform (SQL Server, Oracle) and the permissions that are set. Most of the time its not required to have the schema.

Otherwise, you can script this to replace the schema name at runtime using property binding on the query property.