Skip to content

Set Up the Database

  1. Create an SQL file that will add your data definitions to the Terminal ID Management database:

    • Refer to the Example Scripts.

    • The Populate IDs example is a good place to start. Copy its contents into a local .sql file and open it in a text editor.

    • The script includes basic examples of the various ID attributes and pool types that you are likely to need.

    • After you identify your organizational needs, including the users and sessions that you plan to manage, edit your script as needed to define your pools.

  2. In the Terminal ID Manager Console, use the Server Settings panel to execute your script and configure the database:

    • In the Database management section click the Execute SQL File button. Locate your script file and choose it for upload.

    • Click OK when prompted to confirm that you would like to configure the database.

    • A dialog will display the output of the script.

  3. Upon successful execution, the Server Status banner will immediately become green and indicate that the database is available.

  4. Next step: Configure Additional Server Settings in the Terminal ID Manager Console.