Yes, this way a reporting application (for example, WebFOCUS) can have access to that ODS and will not require access to the Omni-Gen repository.
Your favorite Relational Database Management System (RDBMS), such as SQL Server, MySQL, or PostgreSQL.
It is stored in the database you specify as the consumption data source in the OmniGen console.
For the current release, the Consumption View database is updated on demand.
Any database supported by Omni-Gen can be used.
Yes, as long as Omni-Gen has the credentials to the desired target.