How to access TimeXtender Master Data Management data through SQL connection
Behind the scenes, TimeXtender Master Data Management data is stored either in SQL Azure Database or in Microsoft SQL Server.
Within the TimeXtender Master Data Management, administrators can create new SQL Logins to access the data.
Common scenarios are:
-
Create a read-only user on specific projects to view data in Excel or Power BI
-
Create a write user the imports data into TimeXtender Master Data Management from Azure Data Factory or TimeXtender Classic
Create a user and set privileges
- Open Settings by clicking the "Gear" icon in the bottom left corner
- Open "Database User Configuration"
- Select Add and create a unique name and generate the password
Note: The password can not be recovered so make sure to store it in a secure place. If you forget the password the only option is to generate a new one.
- Select which schemas and what privilege the user should have
- Save and click to How to Connect to get details regarding the database behind TimeXtender Master Data Management.
