Establish a dynamic connection between a dataset in Dataiku and Excel

Options
ptavares
ptavares Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 3

I would like to be able to create a dynamic connection between a dataset in Dataiku and Excel, so that any changes in Dataiku would be automatically refreshed in an Excel file.

There is a plugin available that connects Dataiku and Power BI dynamically. Please see the link below:

Plugin: Microsoft Power BI | Dataiku

My question is if there is a similar way of connecting dynamically Dataiku and Excel.

Thanks in advance,

Paulo


Operating system used: Windows

Best Answers

  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,726 Neuron
    Answer ✓
    Options

    Not as a plugin but you don't need much to do this. Add a Python recipe to your last flow output dataset and write the output as a Excel file in a Dataiku Managed Folder. For an even more seamless integration you could mount your network share in Dataiku, create a new File System Connection and place the Dataiku folder there so that users could see the Excel file in their network share without you have to send it to them.

  • me2
    me2 Registered Posts: 48 ✭✭✭✭✭
    Answer ✓
    Options

    There are two additional options available if you use Microsoft 365 and2 excel file options as well.

    1) Dataiku is able to connect to Sharepoint and Dataiku can export to a Sharepoint folder.

    2) Dataiku is able to connect to OneDrive and Dataiku can export to a OneDrive folder.

    There are differences on the Excel side on how one is able to interface/link to that file and worth exploring before deciding.

    Dataiku is able to write as an Excel file as @Turribeach
    mentioned. Also if there is multi-sheet option but that saves the file in a compressed folder.

    Happy Dataiku'n!

Setup Info
    Tags
      Help me…