Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

What is the workaround to save a Workbook or a DataFlow to directly save to Google Drive?

Received Response
51
Views
4
Comments
User_G0M4L
User_G0M4L Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

The OAS Google Drive connection allows only reading from a Google Sheet. What are the available workarounds to extend this functionality to also be able to write to a Google Drive?

Answers

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @User_G0M4L - You can save output data from data flows to these database types:

    • Oracle Autonomous Data Warehouse
    • Oracle Autonomous Transaction Processing
    • Oracle Database
    • Apache Hive
    • Hortonworks Hive
    • MapR Hive
    • Spark

    Reference : https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/data-flows.html

    Kindly log an Idea in the Ideas Lab for your requirement with business justification, so that our Product Mangement team can review and consider it in future releases. Thanks!

  • User_G0M4L
    User_G0M4L Rank 1 - Community Starter

    Write-access to Google Drive from a Data-Flow or WorkBook will be an invaluable feature for those user communities that use Google for official communication. I only wish the Google-Drive connection could be extended with read/write feature. Can there be an alternate solution leveraging the extensions and Python code to achieve this functionality?

  • Bret Grinslade - Oracle Analytics-Oracle
    Bret Grinslade - Oracle Analytics-Oracle Mod
    edited Nov 26, 2024 4:56PM

    For a new idea, search here to see if it is already been submitted. If it has, please vote for it and add a comment if you have other input.

    If not, please create a new one:
    https://community.oracle.com/products/oracleanalytics/categories/idealab-oracle-analytics-cloud-server

  • Gianni Ceresa
    Gianni Ceresa Mod
    edited Nov 26, 2024 6:59PM

    Can there be an alternate solution leveraging the extensions and Python code to achieve this functionality?

    Well, one of the steps of a data flow in OAS is "Apply Custom Script", therefore you can do whatever you want inside a custom script.

    It isn't designed for that I would say, but it will be able to do the job as it has access to all the data at that step of the data flow. The thing is that you have to write everything yourself: there isn't any piece of code or helper provided for the task you ask. (The custom scripts are mostly there for ML and similar tasks, but it doesn't prevent you from doing other things.)