EQQ Administrator Guide

As an EQQ Administrator, you set up and maintain the EQQ environment. This includes managing users and roles, database connections, and the SQL views that Query Creators use to build queries.

Administrator Responsibilities

  • Adding and managing user accounts and role assignments
  • Creating and maintaining database connections
  • Registering and managing the SQL views available to Query Creators
  • Monitoring system performance and reviewing the activity log
  • Applying EQQ product updates

Managing Users

Go to Administration > Users and click Add User. Enter the user's name and email, then assign one or more roles:

  • Query User — can run published queries only
  • Query Creator — can create, build, test, and publish queries using registered views
  • View Creator — can register and manage the SQL views that Query Creators use to build queries
  • Security Administrator — manages users, role assignments, and access control; can review audit logs
  • Settings Administrator — manages database connections and application settings

The new user receives an email invitation to set their password. A user can be assigned multiple roles.

Database Connections

EQQ connects to your business database in read-only (SELECT) mode, ensuring data is never accidentally modified.

  1. Go to Administration > Database Connections and click Add Connection
  2. Enter the server name, database name, and read-only credentials
  3. Click Test Connection to verify, then Save

Managing SQL Views

SQL views are the building blocks Query Creators use. Each view presents a clean, simplified set of fields from your underlying database tables.

  • Create views in your database management tool (SQL Server Management Studio, MySQL Workbench, or pgAdmin depending on your installation), then register them under Administration > Views
  • Give each view a clear name and description so Query Creators know what data it contains
  • Control which Query Creators can access each view for security and relevance

Security Best Practices

  • Use a dedicated SQL login with SELECT-only permissions on your business database
  • Grant view access only to users who need it
  • Review the activity log regularly under Administration > Activity Log

Need Help?

Our team can assist with setup, view creation, and ongoing administration. Contact us via Get In Touch or explore our Services for professional hands-on assistance.