au2mator Documentation

Configure SQL Question Type

Setting Information

  • Question Types
  • available since Release 2.5

Detailed Information

To configure SQL Query as a Question Type, configure your Service and choose “SQLQuery” as Type

SQL Server

  • Type in the Name of your SQL Server

SQL Database

  • Enter the Name of your Database

SQL Query

  • enter your SQL Query
  • Write SQL command in lowercase
  • don’t copy and paste from SQL Management Query Windows

Authentication 

  • Is SQL Windows Authentication, the logged on Windows User is used
  • SQL Authentication, Ente Usernamen and Password tor SQL Authentication

Make sure the User has access to the SQL Server and to the Database

The SQL Query will run each time a User is selecting this related Service

Something More

Make sure, the Query you are entering is, as simple, as possible. Do not use heavy commands like ORDER BY, DISTINCT or something similar.

Instead, build a View, where all your Information is ready, and only use simple Select in our Portal

Reason: Heavy Queries can also slow down our Portal, and that is something, no one wants.

Related