Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Excel driver that can read Alteryx databases (yxdb files)

This would be much better than having to output the data to an Excel tab or csv file in order to link to Excel pivot tables.  The pivot tables could link directly to the yxdb files.

6 Comments
Alteryx
Alteryx

Having Excel read a new data format is a Microsoft issue that Alteryx can't control.

5 - Atom

Does this article provide any help in what you trying to do (or at least get you started in the right direction)? https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Excel-to-Alteryx-API/ta-p/85766

 

5 - Atom

Actually what I"m needing is an OLE DB Provider for Alteryx that Excel can use.  Dell built a DLL for Statistica for the ability to make a connection in Excel to link in data for pivot tables.  Be great to have one for Alteryx.
Here is the connection properties for Excel linking to a Statistica file:

Provider=STATISTICA.StaOLEDB.1;Data Source=\\PATH TO YOUR ALTERYX yxdb file;Integrated Security="";User ID="";Extended Properties="";Strip Formatting=TRUE;Auto calculate spreadsheet=FALSE;Connection String="";Station Name="";Excel Style Julian Dates=TRUE

8 - Asteroid

I like the idea of non-alteryx license holders having read access using excel to data in an alteryx database.  Is there a way to do this?

Thanks

Status changed to: Inactive
 

The status of this idea has been changed to 'Inactive'. This status indicates that:

 

1. The idea has not had activity in the form of likes or comments in over a year.

2. The idea has not reached ten likes.

3. The idea is still in the 'New Idea' status. 

 

However, this doesn't mean your idea won't be implemented! The Community can still like and comment on this idea. With enough renewed interest, this idea can be brought back into the 'New Idea' status. 

 

Thank you for contributing to the Alteryx Community and the Alteryx Product Idea Boards!