Generate BI Publisher report using SQL Query by passing Quote Id from Siebel when button is clicked

Hello - We've a complex requirement to generate Quote proposal from Siebel when a button is clicked. Use of Siebel integration object would be too compex so we decided to use SQL query as report data source.

SQL query would be based on Siebel base tables so its reading Siebel database only.

When user is done with Quote, he/she would click "generate Proposal" Button and the expectation is Siebel would generate report and store it as Quote attachment in Siebel file system.

We've to pass Quote Id and input parameter to generate the report.

What are the steps to achieve this requirement?