SAS Dataset with Different Reporting Tools

Anshuman11 · Posted 06-10-2013 03:14 AM

Hi,

As we all know the limitations in SAS WRS.

So we are opting for other Reporting tools available in the market.

So my question being can we have SAS Dataset/database as the source for Reporting Tools such as Business Objects/Cognos/Microstrategy.

A detailed answer will be very helpful

Thanks in Advance

LinusH · Posted 06-10-2013 05:55 AM

Yes, through ODBC or OELDB.

For ODBC at least, you need to set up a SAS/SHARE server, and have a SAS license that contains SHARE and SHARE*NET.

If you happen to have SPD Server, I think it's included within that product (for data stored within SPD Server).

Data never sleeps

Anshuman11 · Posted 06-10-2013 06:06 AM

Thanks for the input.

Yes we have SPD Server.

LinusH · Posted 06-10-2013 06:16 AM

So, you could share the SPD Server stored tables via the spdssnet process, see online doc/papers how set this up.

Data never sleeps

AhmedAl_Attar · Posted 06-10-2013 07:43 AM

SPD Server supports ODBC & JDBC access.

part of the SPDS Admin Guide, there instruction on how to set that up.

Good luck,

Ahmed

Re: SAS Dataset with Different Reporting Tools