Our solution is an overlay to your systems, minimizing disruption to BAU
With the fastest speed of integration in town we keep costs low and minimize disruption. An example is a 3 screen custom cloud based data integration product to load Bloomberg Data Licence Issuer, Security and Pricing data into a Windows based PMS, completed in only 80 hours.
Having already built the workflows and rules for loading the major market data vendors we save you time and expense
By isolating the business rules that you want control over, you are in charge, which means lower costs and faster response
Providing the data quality controls in a consistent way across all your data sources we help ensure compliance
Using openMDDB as our central trusted copy database gives you control over your data and schema, no licence fees for the schema
We follow a project framework to deliver an integrated EDMFabric system:
Identifies each system where you want the cleansed and homogenised reference and pricing data loaded. Also identify which external data vendors you use and their licencing restrictions relative to the consumers of data.
Work with each of your teams to document and map the inputs directly into the EDMFabric product. Then provide the transformations that draw the data from those systems into openMDDB for cleansing, while agreeing which rules you want applied
Agree with the business which cleansing rules will be applied and who will manage the rules and who will manage the exception queues. Design the workflows to push the cleansed data back to your systems or spreadsheets.
Define, design and build any reporting outputs or custom dashboards you require
Deploy the test system into a private cloud or installed on site. Train the users and carry out user acceptance testing, iteratively changing the system until the users sign off.
The EDMFabric product is based on the BPMN2 standard for the workflows, of which there are 2 types. The first is the overall orchestration of fetching and loading the feeds or the customer internal sources into feed specific schemas, then extracting and cleansing the data into the openMDDB database, finally extracting and transforming into the integration formats required by the customer to load their internal systems. The second workflow type is a network of rules applied to each record going through the ETL process. These rules can be written in Drools, a Rete algorithm based forward and backward chaining language, or Groovy, the official Java scripting language.
The EDMFabric product is made up of 4 interconnected parts. The EDMFabric Designer is a full GUI application that provides a rapid design environment that include Drag and Drop design for workflows, data dictionaries, ETL and rules. The EDMFabric Designer uses a distributed metadata repository, which it shares with the EDMFabric Engine. The EDMFabric Engine can run in the cloud or installed on your site. The schedule for the workflows it runs are controlled from the Security Master web application along with all the data audit, staging and exception queue management.
EDMFabric has automatic discovery of XML schemas and Database schemas to build the required metadata on structures and relationships fully automatically. This saves a lot of time. It has reconciliation features when these models change. Again lowering the cost of ongoing maintenance. Using a consistent representation of data structures and relationships regardless of the data source type saves time and money on design and training.
EDMFabric is not tied to openMDDB, but uses it because it is comprehensive and open, customers can keep the data and model, there is no licence to pay for the openMDDB schema. EDMFabric can very quickly interface to databases, XML, flat and variable length files, spreadsheets, FIX protocol and FpML protocol both for input and output.
By isolating the rules from the ETL and workflow your business people can take control of them with minimal training and ongoing costs.
The EDMFabric Data Explorer manages all data assets, covering flat and variable length files, XML, FIX and FpML protocols, Spreadsheets and Databases - including Tables and Queries
The EDMFabric Data Explorer manages all product assets. Products are workflows including ETL, Mapping Substitutions and rules
EDMFabric supports 2 rules languages, Groovy and Rete. These can be combined in a high performance workflow run for each record processed
EDMFabric ETL Designer allows drag and drop design of Extract, Transform and Load mappings.