Dear Team,
Is it possible to send extract of analysis (in excel) automatically to sftp or to some email on periodic basis?
Regards.
Roshan
Page 1 / 1
Hi Roshankumar,
My best suggestion is to dive into the ML Workbench and create a Python script. With the PyCelonis package, it is possbile to extract object from you analysis, such as OLAP tables and write them to CSV or Excel. After that, it should be possible to write it to SFTP, but this will require some effort to set the security settings well (but Google can help you with that). Using the scheduling functionality within ML Workbench, you can run the script frequently.
Hope this will help you.
Best regards,
Jan-peter
My best suggestion is to dive into the ML Workbench and create a Python script. With the PyCelonis package, it is possbile to extract object from you analysis, such as OLAP tables and write them to CSV or Excel. After that, it should be possible to write it to SFTP, but this will require some effort to set the security settings well (but Google can help you with that). Using the scheduling functionality within ML Workbench, you can run the script frequently.
Hope this will help you.
Best regards,
Jan-peter
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.