Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Feature To change massively the datasources password in the RPD
I would like to request a feature to massively change the passwords of the rpd data sources in the cloud.
Many users have different database passwords depending on the environment (development, pre-production, production). When our environments were "on premise" we used the functionality of a jar called "BIServerT2Provisioner.jar", when we moved the RPD from one environment to another.
Now in the cloud we find that we have to do it again in a tedious manual way.
Comments
-
@Jose Luis Alvarez Elbal-Oracle Have you considered using externalized connections in the RPD? In this scenario, you can have the same self-service (DV) connection in the RPD with different connection details based on environment.
0 -
@Jose Luis Alvarez Elbal-Oracle ,
have you considered using the Repository Merge utility?
1) Have one RPD where all the connection pools point at dev servers with dev credentials.
2) Prepare one RPD that contains only connection pools. these pools will point at prod servers with prod credentials.
3) Merge the repos, giving priority to the RPD with prod servers and pwds.
Result should be a merged RPD containing cnn pools from prod and the rest of the objects taken from the original RPD.
makes sense?
0 -
@Alan Lee - Oracle-Oracle I am not sure what do you mean with "externalized connections in the RPD" But I will investigate, But I am not sure If we can use because all the development are in the classic analytics. But I will check, because may be could be used for DV develoments ,Thank you for your help @Alan Lee - Oracle-Oracle
0 -
@Marcelo Finkielsztein yes, your comment make sense, I had not thought about using merge rpd utility for passwords, I will check. we can automate the procedure. Thanks for the idea.
0
