According to our measurements, APIs of cloud applications typically have an error rate a factor 100 to 1.000 higher than on-premise applications. This also holds for use within business hours / SLA-covered hours.
Invantive SQL provides significant business value by gracefully common and uncommon communication errors with cloud APIs. However, it can not cover all your business scenario and it remains important to mitigate your business risks by testing your procedures for enterprise-critical applications of Invantive SQL in scenarios where communication problems can have a business impact.
This article explains you how to simulate typical cloud connectivity issues for OData and/or REST-based cloud API’s.
Perform the following steps to simulate a typical cloud connectivity issue:
Start Invantive Query Tool.
Connect to a connector which supports simulation of communication errors, such as Visma.net or Exact Online. In this scenario we will use Visma.net.
First disable all caches to ensure that all SQL statement directly transform into actual cloud API calls:
set use-http-disk-cache false set use-http-memory-cache false
Activate simulation of on average 25 HTTP 400 errors per 100 calls:
set simulate-http-400-errors true set simulate-http-400-percentage 25
Select all partitions:
Run a query:
select * from financialperiods
The query will now raise an error, such as shown in the picture:
The following types of errors can be simulated by setting connector attributes:
Configure Error Percentage
All connector attributes are listed on the connector-specific documentation on https://documentation.invantive.com.