Virtual info provider allows you to connect to external data sources at runtime to make particular data for sale in an environment not having being forced to physically duplicate it in to Dataverse. This is especially useful for circumstances where you would want to reference control data via an outside source but there may not be a purpose to keep it coordinated with the platform.
To build a virtual info provider you create a new plugin assemblage and a fresh InfoProvider that work references the connect to. The InfoProvider features the BEx query which is used to retrieve the data, plus the logical term that specifies the desk to access. The virtual data supplier is triggered when the BEx query is executed and sends it is characteristic selections to an exterior system. The non-SAP system then operations the options and exchanges the data for the BW OLAP engine.
The virtual info provider is mostly a flexible method to pass characteristic selections to an external data source but it surely requires more time and effort to develop and maintain since the query reflection must be translated and the external system processed. However , it gives you the flexibility of modifying the database composition and can support more complex calculations.
Another good thing about using a VDR is that the applications are highly customizable and harmonizes with most operating systems this article and devices. Moreover, it has many data safe-keeping options and multiple global hosting space. Depending on your business needs, you are able to choose the info hosting area that is most effective for you and select a pricing insurance policy that matches your finances.