Analysis Server access

Shareef has asked for the wisdom of the Perl Monks concerning the following question:

Is there a way (a module) for a perl script running on Linux to access microsoft analysis server OLAP data base running on windows? I dont want a work around to aggregate the data using regular tables in sequal server.

Comment on Analysis Server access

Replies are listed 'Best First'.
Re: Analysis Server access by NetWallah (Canon) on Oct 15, 2020 at 04:08 UTC
If the OLAP Db supports ODBC, you could use: DBI and DBD::ODBC . "Imaginary friends are a sign of a mental disorder if they cause distress, including antisocial behavior. Religion frequently meets that description"	[reply]
Re^2: Analysis Server access by perlfan (Parson) on Oct 15, 2020 at 14:48 UTC
I quickly got lost in alphabet soup, but here's the docs on connecting; https://docs.microsoft.com/en-us/analysis-services/client-libraries?view=asallproducts-allversions. Looks like it's letters of choice are MSOLAP. Looked for "ODBC" and found nothing obvious on the webs. You'd think that'd work, though.	[reply]
Re^3: Analysis Server access by Shareef (Initiate) on Oct 15, 2020 at 22:46 UTC
The problem with using ODBC is not the connectivity. I need a perl object to hold the resulting data set from a MDX query. I need to connect and submit an MDX statement to execute against the server and have a result set returned. Is there a perl object that will allow me to do that?	[reply]
Re^4: Analysis Server access by NetWallah (Canon) on Oct 16, 2020 at 18:50 UTC