Configuring Users & Permissions

Why Are Permissions Important?

TimeXtender Classic relies on seamless integration with SQL-based data sources and target systems. Proper permissions ensure that the platform can execute tasks like data extraction, transformation, and loading (ETL) securely and efficiently. Misconfigured permissions can lead to errors, failed processes, or security vulnerabilities.

What Does TimeXtender Require?

TimeXtender uses Windows user accounts and Active Directory (AD) for authentication and access management. These accounts are categorized into:

  • Developer Accounts: For users building and managing TimeXtender projects.
  • Service Accounts: For running TimeXtender services like the Scheduler and Server Service in non-development environments.

To streamline management, all accounts should be grouped into an AD security group (e.g., TXDevelopers). This group is granted the required permissions across servers, databases, and services.

How to Configure Permissions

  1. Create User Accounts:
    • Assign individual accounts for developers.
    • Create service accounts for non-development environments to run TimeXtender services.
    • Developers should never log-in using Service accounts to develop in TimeXtender as this can lead to repository corruption.
  1. Set Up a Security Group:
    • Create an security group (e.g., TXDevelopers).
    • Add all user and service accounts to this group.

  1. Assign Permissions:
    • Application Server: Grant the security group Local or Domain Administrator rights to manage TimeXtender services.
    • Project Repository: Provide either sysadmin or db_owner permissions on the SQL database hosting the repository.
    • Source Databases: Grant READ permissions to each source database.
    • Target Databases: Assign sysadmin or db_owner permissions for SQL-based target systems.

By organizing permissions through a security group, you simplify administration while ensuring secure and efficient operations.

Next