Integration user for analytical access to read only data stores generated from transactional systems

摘要

The technology disclosed preserves the tenant specificity and user specificity of the tenant data by associating user IDs to complementary special IDs referred to as the integration user(s). In particular, it combines the traceability of user actions, the integration of security models and the flexibility of a service ID into one integration user(s).

主权项

1. A computer-implemented method of controlling and tracking usage of an analytic data analysis system associated with a transactional data management system, the method including:
a transactional data management system that manages data stored in a transaction data store receiving a logon request with an associated user ID for use of the transactional data management system, authenticating the logon request, and identifying that authorizations associated with the user ID include usage of the analytical data analysis system; wherein the analytical data analysis system responds to requests to visualize data stored in an analytic data store that is a subset of, but not all of, the data stored in the transactional data store; and responsive to a request to use the analytical data analysis system with the user ID, invoking a complementary special ID linked to the user ID, wherein
the special ID grants rights related to a specific analytic data analysis system;the special ID rights provide read-only access to at least one analytic data store accessed through the specific analytic data analysis system; anduse of the transactional data management system is separately licensed and accounted for from the analytical data analysis system.