(Example) Create a Database Access Token

To create a access token to connect to a database, do the procedure in this topic.

Prerequisites

  • A database with the name Absence_Request.
  • In the Absence_Request database, a table with the name Available_Leaves.
  • In the Available_Leaves table, columns named EmployeeID, RemainingLeaves, and Name.

How to Start

  1. In the Manage Center, click App Builder > Global Access Tokens.
  2. On the Global Access Tokens screen, click Add Token
  3. On the Add Global Access Tokens screen, select Database .
  4. Click Next.

Procedure

  1. On the Add Global Access Token screen, in the Token Name field, enter Database Access Token.


  2. In the Database Type list, select SQL Server.


  3. In the Database Server Name list, enter the database server name, where your database is installed.

    Example:

    AP-456



  4. Select SSPI (Integrated Security.


  5. In the Database Name field, enter Absence_Request.


  6. Click Test Connection to make sure the database account is correct.
  7. Click Encrypt.
  8. Click Done.

Download Files

This file has the database table used in this example. You can copy the contents of this table into your SQL database to test it.