B1UP - Faster Add-on start time by not creating a DI-API Connection during startup

[Horizontal Add-on on version 2018.x or higher now have this turned on by default]

High-level summary

During B1UP Startup step 2/5 takes a long time (5-20 sec depending on the system). This is because at this step the SAP DI-API connection is created and the connection is slow.

This feature, if turned on, will not make the DI-API connection and instead use ADO.Net to collect it's data reducing the connection time (we see 200-300% startup time improvement but it will be different from system to system)

You can also see a YouTube version of this article here: https://youtu.be/1BKW3Tvr2OQ

What are the requirements before turning it on?

• You have provided DB Credentials in the B1UP Main config and these credentials have full SELECT/INSERT/UPDATE/DELETE permissions
• Windows Administrator rights on the machine you wish to activate it for

What are the limitations

Currently, the feature has the following limitations:

• Turning the feature on will disable all execution of plugins for the database (they will simply not run)
• it only works if the SAP Legacy Cockpit is turned off

FAQ

Q: Does this feature do anything that is not "Legal" in the SDK Certification (for example raw SQL insert statements to SAP System tables)?

A: No, The system is built so if something needs the DI-API (for example creation of metadata) it will ad-hoc make the DI-API connection needed.