Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Analysis Server access

by Shareef (Initiate)
on Oct 15, 2020 at 01:58 UTC ( #11122850=perlquestion: print w/replies, xml ) Need Help??

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.

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"

        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?

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://11122850]
Approved by GrandFather
Front-paged by Corion
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (4)
As of 2020-10-31 10:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My favourite web site is:












    Results (287 votes). Check out past polls.

    Notices?