Can somebody tell me whether it is possible to run WRS on relational database?
I know it runs on informations maps. But we wanted to know whether it is possible to create reports from WRS without creating information maps?
We can run stored process in WRS...so can that stored process use SAS/Access to access data directly from relational database rather than Metadata server or Information maps??
Really would appreciate your inputs...kind of urgent as we are stuck at this point!
Message was edited by: Sid
I have no personal experience on this topic-point, however I believe you can use SAS Web Reporting Studio (WRS) indirectly with relational databases. You may find these links from the SAS support website http://support.sas.com/ useful - I found them using the SEARCH facility on the main webpage:
Sure: if you didn't want to create information maps, you can write a stored process that uses SAS/Access to connect to the DBMS table(s) you need. That stored process can then be surfaced in Web Report Studio. You can also surface that stored process directly in the Information Delivery Portal as well.
It's only using the WRS report objects like list, crosstab, bar chart, etc. that need you to have an information map as the underlying data source. The advantage of using the Bar Chart report object as opposed to creating a stored process which displays a bar chart is that the one with the Bar Chart report object is much more interactive. I can filter, sort, change data items on the fly when viewing a Bar Chart report object. The only interactivity in a stored process comes from the parameters you define ahead of time.
In order to run any report in Web Report Studio (using the report objects such as list, crosstab, line graph, etc), you must have an Information Map. However that Information Map could point to a Stored Process or any Defined Library/Table in SAS Management Console (which could consist of any number of DBMS, including Teradata, Oracle, Base SAS, SQL, SAP, EXCEL, etc).
I created a view in base SAS then registered the view in metadata for use in an information map. When I create the report in WRS the data is as live as the DBMS is. The only down side is the larger the table gets the slower the view returns data. That's the closest you can get that I know of without using a Stored Process.