How to export a JDBC data source between two instances along with JDBC password

[Aditya Banka2]

Hello All,

We have a data source which is configured in dev instance which is working fine. But we are not aware of the existing JDBC password. I have exported it using XML into QA instance, which is giving a password error. I tried to capture the same with an import set and re-deploy it again in QA which is still giving the same password error.

Since we are not knowing the existing JDBC password, please let me know how can we move it from dev to QA and make it work in QA instance.

[jonsan09]

You'll want to verify the MID server configuration on the data source in your QA instance, generally when moving data sources between instances, they'll need to have the correct MID server re-selected.

[Aditya Banka2]

I have modified the MID Server configuration in QA instance and selected the correct MID server before I tested it. But still it is getting failed with password error.

[Hellfried]

Hi, you cannot copy credential entries to another instance as XML, they are encrypted with a key that is specific to the instance. 

The only way to define a connection or to get a copied entry working is to enter the right secret or password in this instance. 

I am sure this is by design, because else any non-authorized user who got hold of the XML could connect to your data source and download your data.