Categories
- All Categories
- 147 Oracle Analytics News
- 27 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Automate transfer/migration of file-based data set content (Excel/CSV) between OAS environments
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):
Czech National Bank
Description (Required):
We are fighting in ourExported BAR Files Don't Include Data Files OAS environments with quite strict restriction of BAR/snhot content (which does not pay for OAC) - Exported BAR Files Don't Include Data Files (see https://docs.oracle.com/en/middleware/bi/analytics-server/known-issues-oas/index.html#OASKB-GUID-147FF502-A8A2-4DFF-9DBF-B597720E1F19).
This represents really quite big pain for us, since we need to "handle" transfer of file-based data set content (Excel/CSV files) manually (from DV UI - upload) in following scenario:
- transfer "content" from environments (DEV to PROD or vice versa) using BAR archive/snapshot
I have already created following Idea: OAS - inclusion of "File-based Data" into snapshot: https://community.oracle.com/customerconnect/discussion/586916/, but without any attention from Oracle so far.
If it is not feasible to implement this within snapshot/BAR export functionality, would it be at least possible to think about making upload/download functionality available for file-based data sets in DV UI as part of planned API for DV ?
At least this would allow us to automate transfers of file-based data sets.
Use Case and Business Need (Required):
Streamline/automate deployment processes within DV part of OAS
Enhancement Request / Service Request:
Comments
-
We have the exact same issue. We have had Users develop several DV's in OAS 6.4 environment and we have to do an out of place upgrade to 2024 (Ver 7.6). The snapshot restore process is good for most catalog items but does not bring over datasets that were originally created using file based sources such as excel. If Oracle can update the snapshot to include datasets that were created using file based sources it would make it easier for out of place migration. Currently we are left with no choice other than to migrate each of the DV or dataset manually. We have 100+ DV projects. Thanks!
2 -
@Narayanan Ramachandran You exactly hit hit the nail on the head. Generally area of Dev2Prod processes (also incremental) , automation, governance has huge gap in product (and in OAS it is even more evident with comparison to OAC). I am trying to point/bring attention of responsible people in Oracle Analytics Dev/Mgmt - see links:
But so far without much success (nothing has changed - no signs of change in recent Product roadmap). The only chance is to collect more votes for corresponding Ideas (including this one).
Rgds
Michal
2 -
This has been a real challenge trying to keep the environments in sync during our upgrade. It is really surprising and has made maintaining our upgrade schedule difficult. I hope Oracle notes this and automates this.
1 -
Even we are facing the exact same issue. We need to reinstall and setup all our OAS 7.6 environments as part of a hardware upgrade. This whole datafiles issue is a real concern. We have over 1000+ datasets in file format and some of them are private (non visible to admin). This bar file limitation has put all our upgrade/migration plans in jeopardy.
1 -
Much needed feature which will add so much values. Upvoted.
1 -
This would be useful. Thanks Michal, upvoted.
1
