Option to select connection when importing DVA file — Oracle Analytics

Oracle Analytics Cloud and Server Idea Lab

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

Option to select connection when importing DVA file

Needs Votes
45
Views
2
Comments

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):


Description (Required): When exporting a workbook based on a SQL query, the options are to include or exclude connection details. If the details are excluded, when the workbook is imported and opened, username./password is required which cloud developers may not have. If the details are included, a new connection is created that points back to the original environment.

When importing a DVA, there should be an option to use an existing connection


Use Case and Business Need (Required): When migrating content between environments, there is no easy way to use an existing data connection in the new environment


Enhancement Request / Service Request:

8
8 votes

Needs Votes · Last Updated

Comments

  • Andrew Desalme-Oracle
    Andrew Desalme-Oracle Rank 4 - Community Specialist

    100% agree - this is a frustrating functional gap that has caused many problems when you have multiple environments using different connections. Importing projects should be able to use connections in the target environment without entering any passwords.

  • Michal Zima
    Michal Zima Rank 7 - Analytics Coach

    I am 100% agree and vote for this Idea. Deployment mechanism for transferring DV workbook (and related artefacts) from one environment to another (DEV2PROD) using DVA package, should be much more "smarter" than current status.

    Beside the option to choose existing connection when importing DVA packages, import should also allow to keep original namespace of imported data sets from "source" environment (instead of changing it to namespace of user logged in on target environment).