Use Windows impersonated security connection

Link to or import data from a SQL Server table with the Impersonate Client option. See Data access recommendations for linked tables.

Note: If linking to a SQL Server that is not on the same computer as the PI AF server, it may be necessary to configure Kerberos to allow the client's identity to be forwarded from the PI AF server to the SQL Server.

1. Create a local user group for impersonated clients.

2. Configure security on the target table's database.

3. Import or link SQL server tables.