Welcome to SOTI Snap 2024.1 Help
Build Apps
Build Business Apps
Managing Built Apps
Managing Saved Drafts
Publishing Apps
Distribute Apps
App Manager: Sharing Apps
Track App Responses
Accessing App Logs
Extending SOTI Snap
Managing Environments
System Settings
SOTI Snap Link
SOTI Snap Agent Help
SOTI Snap Data Access Controller (DAC)
- Setting up the SOTI Snap Data Access Controller
  To setup the SOTI Snap Data Access Controller (DAC), you must download the setup wizard, install the SOTI Snap DAC, and then access it from your local machine using a web browser.
- Creating a New Service for SOTI Snap Data Access Controller
  Create a RESTful API service by connecting to an existing database. SOTI Snap applications can then perform create, read, update and delete (CRUD) operations on database table data using the API.
- Importing An SSL Certificate for SOTI Snap Data Access Controller
  By default, the SOTI Snap DAC uses an insecure HTTP connection between a SOTI Snap application and the SOTI Snap DAC endpoint. This connection sends plain text messages that are vulnerable to threats. You can upload a SSL certificate to use the more secure HTTPS protocol to provide an extra layer of protection using encryption and verification.
- Viewing the SOTI Snap Data Access Controller Request History
  You can view the history of your SOTI Snap DAC by reviewing the most recent 100,000 requests. You can also delete the request history by selecting Remove Request History.
- Constructing an API URL for the SOTI Snap Data Access Controller
  From the API Docs tab, you can view the API documentation to construct an API URL for yourself so you can connect to your DAC endpoints. You can also use the Construct URL feature to have the SOTI Snap Data Access Controller help you construct an API URL.
- Managing SOTI Snap Data Access Controller Settings
  Customize the settings of your SOTI Snap DAC.
- Connecting SOTI Snap Apps to the SOTI Snap DAC Service
  After app_user/creating_a_new_service.html, you can customize your SOTI Snap application to connect to the SOTI Snap DAC service. SOTI Snap applications can access the SOTI Snap DAC service from the following SOTI Snap tools:
Glossary
Notices

SOTI Snap Data Access Controller (DAC)

SOTI Snap Data Access Controller (DAC) is a RESTful API endpoint generator. SOTI Snap DAC applications can perform create, read, update and delete (CRUD) operations to retrieve and submit data directly to your databases.

Overall SOTI Snap Data Access Controller Architecture

You can install SOTI Snap DAC in the following locations:

The server where your database resides. This server can be a dedicated machine.
A remote server in your company, including servers in a demilitarized zone (DMZ).

SOTI Snap Data Access Controller Front Page

SOTI Snap DAC supports the following databases:

PostgreSQL
MySQL
Oracle
Microsoft SQL Server
IBM Db2

CAUTION: Third party software with the correct credentials can use the RESTful API endpoints generated by SOTI Snap DAC. SOTI recommends that you not use third party apps in this way to reduce the risk of leaked credentials.