Product Support and Client Responsibilities
Use the provided service account to interface systems to the database.
Product Support
By enabling permission to client IP address, data can be accessed 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 for egress which has additional cost implications.
- Ingest process: the use of a script or system based process to query the data required to ingest into the environment.
- Simple reporting process: interface a system(such as a reporting platform) to the database as a data source:
- Depending on your requirement, you may choose for the performance between 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, clients should ingest data into their own environment such that they can then operate on it locally.
- Calyx can increase the sizing of the database both vertically and horizontally, but this is at additional cost and mediated by Pro Services architecture team.
- Calyx will not provision access to individual user accounts to run queries against the database.
- Calyx 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
- 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.
- Accessing data over the Internet may increase performance issues which are not controlled by Calyx. 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 an increased amount of time. This can cause performance issues and are not controlled by Calyx 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.