Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to connect to cube databases in alteryx

deepika_durvasula
7 - Meteor

Hi 

 

I have to extract data from cube databases using Alteryx. I have searched some info and understood that Alteryx doesn't support the connectivity to cube databases directly. I tried few methods using MSOLAP Provider but no success. Is there any way to connect to cube kind of databases from Alteryx?

 

 

Thanks in advance,

Deepika

4 REPLIES 4
caltang
17 - Castor
17 - Castor

This thread may be of interest to you Deepika: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Connecting-to-Cubes/td-p/10956... 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
deepika_durvasula
7 - Meteor

Hey thanks for the reply.

 

I have tried using that method. But couldn't find any success. Any other approaches other than using macro?

 

Thanks, in advance,

Deepika.

caltang
17 - Castor
17 - Castor

What abou this? With a macro: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/SSAS-Cube-Connection-and-MS-Po... 

 

@deepika_durvasula 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
deepika_durvasula
7 - Meteor

Hi,

 

I have tried this method, but I am facing 2 errors:

1. Error: MDX (5): Tool #23: The entry point is invalid.

2. Error: MDX (5): Tool #11: The external program "%temp%\mdxQuery.bat" returned an error code: 1

 

 

Could anyone please help me in solving this issue.

 

Thanks in advance.

Deepika

Labels
Top Solution Authors