Use of Environment variables in Data Connectors

[trenicar]

Hi
I have a series of jobs that I want to use the same parameters for.

I have created Environment variables for the DSN, User and password for my database connection. When I use those environment variables as parameters in the job, and assign the parameters to the connection variables in the Oracle Enterprise connector, they work fine picking up everything from the Env Vars.

However, I would like to define a Data Connector and select that, so that when defining the Oracle Enterprise connector all the settings are standard. But when doing this (with the connector defined to use the parameters and Env variables) the password seems to be wrong, possibly double encrypted!

Has anyone any information or thoughts on how to resolve this issue?

Thanks
Tim

[narayana_382]

If you would like to use user id /password and datasources across for one specific environment, create a parameter set and pass the env value to the jobs which you want to across the board.