nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Feature To change massively the datasources password in the RPD

Jose Luis Alvarez Elbal-Oracle

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.

Find more posts tagged with

Status: None

Comments

Alan Lee - Oracle-Oracle

@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.

Marcelo Finkielsztein

@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?

Jose Luis Alvarez Elbal-Oracle

@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

Jose Luis Alvarez Elbal-Oracle

@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.