Product Support and Client Responsibilities

Use the provided service account to interface systems to the database.

Product Support

Granting permission to client IP address, allows data access by client systems through service account information that includes credentials, SQL database, and server information. VPN is not required for accessing data.

You can use the client system to work with data without any constraints except when there is a network disruption or outage which has additional cost implications.

The service account provided is used to enable interaction between the client systems and the database and supports:
  • Ingest process: the use of a script- or system-based process to query and import data from various sources into the environment.
  • Simple reporting process: Integrating, via an interface, a system (such as a reporting platform) to the database as a data source:
    • Depending on your requirement, you may choose the Azure SQL and Internet model you have.
    • The standard principle for compute-intensive operations is that data must be local to the compute resources. Therefore, download data to a local folder to use it efficiently.
    • Ennov can increase the size of the database both vertically and horizontally, but this is at additional cost and mediated by the Professional Services architecture team.
  • Ennov will not provision access to individual user accounts to run queries against the database.
    • Ennov will not manage user accounts / starters / movers / leavers process.
    • If a client wants to present data to their users with granular controls around access, they may do so from their own solutions / environment.

Client Responsibilities

Clients are responsible for:
  • Connecting to their own data. Any SQL client may be used while accessing the SQL Reporting database.
  • Data replication into their own environments.
  • Use of reporting software. Any reporting software that supports SQL may be used.
Clients may encounter the following performance issues while accessing data:
  • Accessing data over the Internet may increase performance issues which are not controlled by Ennov. These issues may increase when loading large amounts of data which tend to be slow and time-consuming.
  • Accessing data over the Internet may require more time. This can cause performance issues and are not controlled by Ennov other than potential metrics in-line with different latencies.

Clients will have real-time insight into performance matrix. Performance data is available in the portal for the SQL database and alerting (this is CPU, memory type utilization positions).

Client owns the source system interfacing (and the performance of any queries) with Azure SQL and MS own the performance of Azure SQL as a service position, and networking is dependent on latency.