Organization Name
Oracle
Description
Idea: RDG based connections are displayed while saving data options in the database. Expecting to perform insert/update data into an on-prime Database.
Current feature:
Created a Data Flow --> choose source data --> Click on Save Data --> Save data to --> Database Connection --> RDC DB Connections details are not visible.
Reviewed product documentation and understood save – database connection option writes data flow metadata to a database table
However in Database connection using Data gateway currently SELECT & Alter session, while insert/update is not supported as of now
Product Document:
Please refer the section Configure and Register Data Gateway for Data Visualization from below URL
URL: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/connect-premise-data-sources.html#GUID-50AC9767-2B31-46FA-835F-52A287560D17
Hence, currently, non-rdg based connections are displayed while saving data options in the database.
Exceptions: RDG based connections are displayed while saving data options in the database.
Use Case and Business Need
RDG based connections should display while saving data options in the database.
Created a Data Flow --> choose source data --> Click on Save Data --> Save data to --> Database Connection --> Need to display RDC DB Connections visible.
More details
RDG based connections should display while saving data options in the database.
Created a Data Flow --> choose source data --> Click on Save Data --> Save data to --> Database Connection --> Need to display RDC DB Connections visible.
Original Idea Number: 3110b39a6c