Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 926
  • Last Modified:

Does it possible to use SSIS to retrieve data from a cube using MDX queries?

Does it possible to use SSIS to retrieve data from a cube using MDX queries?  Thanks.
0
thomaszhwang
Asked:
thomaszhwang
  • 4
  • 3
  • 2
1 Solution
 
ValentinoVBI ConsultantCommented:
SSIS allows data retrieval from any source for which you've got an OLE DB driver.  There is an OLE DB driver for SSAS, so yes, you can retrieve data from a cube.

On SSIS 2008, the driver is labelled "Microsoft OLE DB Provider for Analysis Services 10.0".
0
 
Jason Yousef, MSSr. BI DeveloperCommented:
hi, yes as Valentino said, it could get the data from SSAS but not using MDX, just a straight load connection.
0
 
ValentinoVBI ConsultantCommented:
Hey Jason,

Why not MDX?  I tried it out (using the regular OLE DB Source in the data flow) and it seems to work fine (if you ignore the warning)?

Regards,
V.
0
Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

 
Jason Yousef, MSSr. BI DeveloperCommented:
Hey Valentine,

Oh really! excuse my ignorance then, sorry...I should try it then

Thanks for letting me know that
Jason
0
 
ValentinoVBI ConsultantCommented:
Repeat after me (x100): "I will try it out before commenting" ;)
0
 
Jason Yousef, MSSr. BI DeveloperCommented:
don't have time.... I'll cheat and use:     Replicate ("I will try it out before commenting", 100)
0
 
ValentinoVBI ConsultantCommented:
Good one! :)

Thomas: sorry to get a little off topic here, just let us know if you need further info on this.
0
 
thomaszhwangAuthor Commented:
whatever...
0
 
thomaszhwangAuthor Commented:
Thanks.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 4
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now