DG
Hey Guys,
I am creating Oracle URLs for Database Connections in my Mashzone environment but I need to enter the Oracle details every time I try to connect to a DB. It looks like this is built into the app as a security feature. I figured I'd post anyway and see if there is a way to pass the Oracle credentials so we don't have to auth every time. I know on the Database Connections config page there is a place to set Optional parameters but I haven't found anything on a parameter to pass credentials. Looking I found that it is possible to structure the Oracle url like jdbc:oracle:<driver>:<username>/<password>@<server>:<port>:<SID> but it still asks for a user name and password.
Thanks,
Dave
If by "every time" you mean that you have to enter credentials for each Database Source operator, you actually could go for the URL approach, in connection with the "no authentication" option for a source operator.
.png)
But please note that user and password are stored without encryption here and everybody can see them.
In MashZone 9, you have the possibility of specifying user and password for a database connection already in its alias definition, which will be used for all source operators later on using this connection.
