Data Virtualization

You can use the FintechOS platform to capture order details that are managed by an external (remote) system. However, sales representatives want to view and update real-time order information in the FintechOS platform without having to learn or use an external system.

Data virtualization allows you to integrate data spread across multiple systems, manage it, and deliver it to the end user in real time.

The below table shows how to view, search, and modify data stored outside of the FintechOS database, without moving the data from the external system into the FintechOS database.

Procedure Fit Description
Transient Data entities Best Transient data entities allow FintechOS to temporarily store and display data that has been loaded from or is going to be saved to an external data source.
The transient data entity's attributes are included in the flow's data model through data extensions and their values are preserved only while the flow is open.
Transient data entities use automation scripts for load/ save that are triggered when such a flow is displayed or when it is saved to facilitate data transfers from/ to external sources.
Memory caching Best Data can be temporarily stored in memory in certain cases and then be available for the entire request or workflow duration or kept further if it’s required.
When the workflow has finished, or the data is not needed anymore, it will be removed/ cleaned.
This is best suited when the data is stored in an external location.
Request and Reply Suboptimal Use FintechOS web service APIs to make ad-hoc data requests to access and update external system data.

This solution includes the following approaches:
  • Use FintechOS SOAP API. A page or button initiates a SOAP callout in a synchronous manner. In FintechOS, you can consume a WSDL and generate a resulting client. This class provides the necessary logic to call the remote service. A user-initiated action on a FintechOS Portal page then calls a backend controller (server automation script) that performs the remote call.
  • Use FintechOS REST API. A custom FintechOS Portal page or button initiates a HTTP callout (REST service) in a synchronous manner. In FintechOS, you can consume an OpenAPI specification file and generate a resulting client. You can use several HTTP classes to integrate with RESTful services. A user-initiated action on a FintechOS Portal page then calls a backend controller (server automation script) action that performs the remote call.
For additional details, see the Request and Reply pattern.