Report builder with SAS as datasource (not SSAS)

Question

Hi,
    I am going to create  models/reports in  SQL server 2005 Reportbuilder by using SAS as a datasource.I am very new to these Reportbuilder,SAS (not SSAS, this is SAS).

1.Could any of you guys suggest me some links where I can get good materials (webcasts/ppts/ppts/docs) for Reportbuilder?
2.Could you please tell me from step1 how to connect SAS with BIDS Reportbuilder to final step deployment and how to access by the user also?


Thanks in advance.

Answer 1

Hi Archana - To conenct to SAS you'll most likely need to use either their OLEDB or ODBC data providers. A quick search on them found this link from the SAS site:

http://support.sas.com/kb/31/285.html

Regarding your other question, a good starting point for using report builder is the following. Take a look at the "Connecting to your data" section:

http://msdn.microsoft.com/en-us/library/dd220530.aspx

-JonHP

---

Microsoft SQL Server Reporting Services

Answer 2

Hi JonHP,
  thanks for your reply...  

From SAS website, I can download the "sasoledb.exe".     After downloading and installing, how can I proceed further to use 'SAS dataset' as datasource for creating Models?