Virtual info provider allows one to connect to exterior data sources at runtime to make particular data accessible in an environment while not needing to physically repeat it in Dataverse. This is particularly useful for circumstances where you want to reference professional data from an outside origin but generally there may not be a need to keep it coordinated with the program.
To build a virtual info provider you create a fresh plugin assembly and a fresh InfoProvider that referrals the plug. The InfoProvider comprises of the BEx query that is used to retrieve the data, as well as the logical name that specifies the table to get back. The online data hosting company is induced when the BEx query is certainly executed and sends it is characteristic selections to an external system. The non-SAP system then procedures the selections and moves the data to the BW OLAP engine.
The virtual info provider may be a flexible approach to pass feature selections to an external data source but it surely requires additional time and effort to develop and maintain since the query manifestation must be translated and the exterior system highly processed. However , it gives you the flexibility of modifying the database structure and can support more complex computations.
Another benefit of using a VDR is that the software is highly custom and blends with most operating systems and devices. In addition, it has a large number of data safe-keeping options and multiple global https://www.eetz.info/how-to-prepare-your-company-for-post-merger-integration/ servers. Depending on your business needs, you can choose the data hosting location that is good for you and select a pricing policy that matches your finances.