You can use Dynamic Data Masking Transparent Archive to seamlessly access the Data Vault and a production database.
Dynamic Data Masking handles the request and acts as a database link between the production database and the Data Vault. Dynamic Data Masking redirects the SQL statement to the Data Vault and receives the result set from the Data Vault. Dynamic Data Masking then constructs the correct production database protocol response from the result set and returns the production database protocol response to the client.