SAP .Net Connector 3.0 - Get Data from BEx Queries

I now have to work on a new project extracting financial data from SAP R/3 into Excel and some other datamart. Our SAP guys says, the best way to get the financial data is from BW using BEx and they build couple queries in BEx and I was able to get the data from excel using OLEDB provider and Pivot table. Now for integration purpose, I need to get the same data from SSIS and/or other .Net application (I only know .Net C#). 开发者_StackOverflowI downloaded SAP .Net Connector (NCo) 3.0, samples and guides,and did a lot of Google'ng around to find if I can access the BEx queries, and the conclusion is yes. But could not find how.

Appreciate if someone provide pointers on how to access BEx queries data. If this is not a good way to approach this, please guide me on the write way to get the data into a .Net application.

thanks in advance

There is a web service you can enable in your BI system called QueryViewData that accepts a query name + filters in and outputs the results a la this StackOverflow post.

You might consider an automation package like automation anywhere. You can use it to pull data from many sources with a single tool, instead of using many tools to pull data from several sources. Just google it or let me know if you want more info. Tom