Data Integration Overview interfaces

Specialized model of the various interfaces available for the consumers of the standardized datasets.

Version 1.0
Created date 02-05-2021

Change Data Capture

--

Author Bert Dingemans
Alias --
Stereotypes ApplicationInterface
Details of Change Data Capture

XML/SOAP

--

Author Bert Dingemans
Alias --
Stereotypes ApplicationInterface
Details of XML/SOAP

JSon/REST

--

Author Bert Dingemans
Alias --
Stereotypes ApplicationInterface
Details of JSon/REST

FTP

--

Author Bert Dingemans
Alias --
Stereotypes ApplicationInterface
Details of FTP

SFTP

--

Author Bert Dingemans
Alias --
Stereotypes ApplicationInterface
Details of SFTP

Fileshare

--

Author Bert Dingemans
Alias --
Stereotypes ApplicationInterface
Details of Fileshare

Dashboard

--

Author Bert Dingemans
Alias --
Stereotypes ApplicationInterface
Details of Dashboard

Database link

Specific implementation of an interface based on a database link concept

Author Bert Dingemans
Alias --
Stereotypes ApplicationInterface
Details of Database link

File transfer

File transfer for example via FTP or the usage of a file share, mostly applied for batch data processing

Author Bert Dingemans
Alias --
Stereotypes ApplicationInterface
Details of File transfer

Forms and pages

Interface to standardized data via (web) forms and pages

Author Bert Dingemans
Alias --
Stereotypes ApplicationInterface
Details of Forms and pages

Graphs

--

Author Bert Dingemans
Alias --
Stereotypes ApplicationInterface
Details of Graphs

Packages and stored procedures

Database functionality for the transformation and extraction of data via an interface

Author Bert Dingemans
Alias --
Stereotypes ApplicationInterface
Details of Packages and stored procedures

Report

Reporting interface

Author Bert Dingemans
Alias --
Stereotypes ApplicationInterface
Details of Report

Views and materialized views

Specific relational database interface implementation

Author Bert Dingemans
Alias --
Stereotypes ApplicationInterface
Details of Views and materialized views

Webservice

Webservice interface for application to application integration. This can be implemented in a service bus environment. Mostly applied in event based data processing

Author Bert Dingemans
Alias --
Stereotypes ApplicationInterface
Details of Webservice

Application integration

Different application integration types for application - application integration Well known integration types ares:
- Webservices
- Filetransfer and FTP etc
See for details the description in the TenneT architecture

Author Bert Dingemans
Alias --
Stereotypes ApplicationInterface
Details of Application integration

Data access

Generic description of the interface for the extraction of standardized data for the various consumers.

Author Bert Dingemans
Alias --
Stereotypes ApplicationInterface
Details of Data access

Database integration

Integration from data storage to data storage. For example the relational database integrations like
- views,
- materialized views
- database logic in packages and stored procedures.
- ETL: implementations

Author Bert Dingemans
Alias --
Stereotypes ApplicationInterface
Details of Database integration

ETL processing

Complex transformation between different database structures

Author Bert Dingemans
Alias --
Stereotypes ApplicationInterface
Details of ETL processing

Portals and widgets

Web user interface for the display and maintenance of data within a portal application (for example Sharepoint)

Author Bert Dingemans
Alias --
Stereotypes ApplicationInterface
Details of Portals and widgets

User interface

Different graphical user interfaces like:
- Reports
- Analytical tools
- Geospatial viewers
- Forms
- Portals and widgets e.g.

Author Bert Dingemans
Alias --
Stereotypes ApplicationInterface
Details of User interface