Data Gateway Service (DGS)

The Data-Gateway Service (DGS) is a platform independent virtual warehouse designed to be the backbone of your corporate data access. It provides formal and controlled retrieval of data from any source, making the data visible to multiple channels including Excel & Word (on your desktop), Web Services and a Java API for integration with your in-house applications. By having one source for your data you ensure consistency throughout your organisation.

The DGS can enhance the corporate data with sign-off, security, snapshot, data maintenance, filtering and processing capabilities all within a simple to maintain and standard framework.

Extract	The DGS can extract data from any JDBC compliant source, including Oracle, Sybase, DB2, and MS SQL Server, plus XML, CSV and Excel files.
Sign-off	The optional sign-off capability allows corporate users and systems to automatically gain confidence in the data they are reading by preventing disapproved data from being returned.
Security	Security is managed at all levels (functional, source definition & data), ensuring that only approved users may use the system and access the data.
Snapshots	Snapshots can be taken of a data source and cached in the DGS. Each subsequent request for that piece of data will retrieve it from the DGS thus guaranteeing data stability and speed of access. You always have the option to refresh the snapshot or drop the cache altogether.
Data Maintenance	Some data you need, such as commentary, may not exist in your corporate systems so the DGS provides its own data maintenance facility. Each source is defined by you and exposed in the same way as your other sources.
Filtering	Filtering allows you to enrich your data so only certain rows are passed through depending on certain rules and values. It can be data driven but you can implement your own rules programmatically by creating your own Java classes.
Processing	Each data source can be enhanced to take many feeds, from any location, of different types (e.g. Sybase with Excel) as input, process the data and then pass the resulting data set as output. You can create your own processing engine for each source by plugging in your own Java classes making the possibilities are limitless. Each data source can be thought of as a building block which can be chained together so the output of one becomes the input of another. This brings strength of design which keeps individual sources simple but together provides a greater value. Chained data sources provide data-mining allowing users to delve deeper into their corporate data by traversing down the chain.

Figure: DGS data sources chained together provide a data-mining infrastructure that can build up more and more complex datasets.

Developers

The same signed-off data that is visible to DGS corporate users is accessible through the DGS Java API, making the DGS the essential toolkit for corporate application developers whose requirement is to ensure that their reported data is consistent and secure.

Cross vendor data source joining is no longer an issue for developers. The DGS allows legacy data that resides on different data servers and databases to be quickly and simply merged or transformed within a standard and easy to implement framework.

Infrastructure

DGS is a J2EE application that comes complete with user and security maintenance screens that controls its security model.

If required, Vermilion provide qualified technicians to ensure the smooth implementation of the DGS product as well as provide any tailoring, training or post-sales support that may be required.

The Vermilion Reporting Suite (VRS) is a separate product provided by Vermilion Software and automatically incorporates the DGS product for its data handling functionality.

To arrange a meeting to learn more on the DGS or the VRS products, please fill out the request for more information form by clicking here, or call our Sales hotline on +44 (0) 845 241 9966.