Virtual data provider allows you to connect to exterior data sources at runtime to make specific data available in an environment with no the need to physically repeat it into Dataverse. This is particularly useful for conditions where you would want to reference master data from an outside resource but right now there may not be a need to keep it coordinated with the system.

To build a virtual info provider you create a new plugin set up and a new InfoProvider that sources the connect to. The InfoProvider comprises of the BEx query that is used to get the data, and the logical brand that identifies the table to obtain. The virtual data professional is caused when the BEx query is usually executed and sends the characteristic selections to an exterior system. The non-SAP program then procedures the options and transactions the data towards the BW OLAP engine.

The virtual info provider can be described as flexible approach to pass characteristic selections to an exterior data source nonetheless it requires more time and effort to formulate and maintain considering that the query term must be translated and the external system refined. However , it gives you the flexibility of modifying the database framework and can support more complex measurements.

Another good thing about using a VDR is that the software is highly easy to customize and along most systems and devices. Furthermore, it has various data storage space options and multiple global computers. Depending on your business needs, you are able to choose the data hosting area that is best for you and select a pricing insurance plan that matches your budget.