Allow Script in Python in Data Flow
Original Idea Number: a052ce91c3
The scripting architecture allows for custom R or Python scripts to be wrapped as XML files describing the inputs and outputs. These scripts can be loaded into / registered with Oracle Analytics and are then callable like any other standard analytic function through a generic EVALUATE_SCRIPT ("Scriptname", "parameter name and parameter value list") function.
Oracle Analytics Desktop allows you to format custom Python and R Scripts for use.
To use Python in Oracle Analytics Desktop, you need the script to be embedded in a simple pre-defined XML format.
Once formatted in XML, upload the custom script into Oracle Analytics Desktop by clicking Create --> Script
Invoke the script from a Data Flow. Add the "Apply Custom Script" node to the dataflow and select your script.
Uploaded custom scripts can be found in the Machine Learning tab and can be invoked via Data Flows or using calculations within the project.
The following option is not available anymore in OAC. This is the current request. ---> how to enable Loading of Custom Scripts on your OAC environment.
We need a way for non-admin users to view the backend/physical SQL queries executed by reports (via Session and Query Logs) without granting them full administrator access. OAC's custom Application Role model (Console > Roles and Permissions) allows selecting fine-grained permissions instead of assigning predefined roles.…
Customer would like to request that IBM DB2 12.x be added as a supported data source for Oracle Analytics Server. They hope that it will be included as a certified and supported data source in the next(Year 2027 ) OAS release. Background: The customer is currently operating a reporting and analysis platform using Oracle…
We would like to restrict the MCP to certain OAC application roles instead of all the users. Please help us to achieve this functionality.
One of our Customer would want to establish connection to the MySQL database using Private key, similar to how the connection to snowflake database is established with private key. Appreciate your help and attention to this requirement.
As Oracle Analytics environments grow, Data Flows become increasingly difficult to understand, maintain, and support. While the visual canvas shows transformation steps, there is no simple way to generate human-readable documentation currently in OAS or OAC DV that explains the logic and lineage of a Data Flow.…
