The documentation portal is undergoing maintenance. During this period, you can't create any new user credentials. If you do, you'll need to recreate the user credential after the maintenance period ends.
Enable pass-through security for a connection in the connection properties. Enable data object caching for pass-through security connections in the pass-through security properties of the Data Integration Service.
Select a connection.
Click the
Properties
view.
Edit the connection properties.
The
Edit Connection Properties
dialog box appears.
To choose pass-through security for the connection, select the
Pass-through Security Enabled
option.
Optionally, select the Data Integration Service for which you want to enable object caching for pass-through security.
Click the
Properties
view.
Edit the pass-through security options.
The
Edit Pass-through Security Properties
dialog box appears.
Select
Allow Caching
to allow data object caching for the SQL data service or web service. This applies to all connections.
Click
OK
.
You must recycle the Data Integration Service to enable caching for the connections.