Getting started with the SQL API

To enable reading of data through the SQL API by external applications you must enable the csense_db_user login by following these steps:

1. Start CSense Runtime Manager.

2. Select Action

3. Select Proficy CSense Run-time Properties

4. Choose Enable SQL Login and select Set Password

5. Provide a strong password.

For a managed instance this will also enable SQL Server Authentication. For a non-managed instance SQL Server Authentication must be enabled on the server by a Database Administrator. See the Secure Deployment Guide for more information.

Note : For a third party application to access the CSense database from a remote machine, an exception will need to be added to the firewall for the SQL Server TCP port number.