"Include Connection Credentials" behavior when exporting/importing workbooks/dataflows

Chad Williams

Hello. when exporting a workbook/dataflow/sequence from one instance of OAS (Test) and into another instance (Prod), we always leave the "Include Connection Credentials" option turned off. However, when we import the dva file into another location, it ends up overwriting/replacing the connection information in the target location anyway. I guess I'm not certain what the purpose is of this export feature if it ends up ignoring it anyway on an import and still replaces connection information. Does anyone have any insight into this?

It feels like our best option is to make our production databases accessible to our lower OAS environments, but that's just not very ideal, for reasons that I think are obvious (such ask mitigating security risks).

Regards,

Chad

Syamantak Saha

There is no feature for persistent connections when you use this option. Check if there is already an user connection in the target location to the data sources.