Data Integration Overview interfaces

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

Versie 1.0
Creatie datum 02-05-2021

Data access

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

Auteur Bert Dingemans
Alias
Stereotypes ApplicationInterface
Details van Data access

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

Auteur Bert Dingemans
Alias
Stereotypes ApplicationInterface
Details van Application integration

Portals and widgets

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

Auteur Bert Dingemans
Alias
Stereotypes ApplicationInterface
Details van Portals and widgets

ETL processing

Complex transformation between different database structures

Auteur Bert Dingemans
Alias
Stereotypes ApplicationInterface
Details van ETL processing

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

Auteur Bert Dingemans
Alias
Stereotypes ApplicationInterface
Details van Database integration

User interface

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

Auteur Bert Dingemans
Alias
Stereotypes ApplicationInterface
Details van User interface

Forms and pages

Interface to standardized data via (web) forms and pages

Auteur Bert Dingemans
Alias
Stereotypes ApplicationInterface
Details van Forms and pages

Views and materialized views

Specific relational database interface implementation

Auteur Bert Dingemans
Alias
Stereotypes ApplicationInterface
Details van Views and materialized views

Report

Reporting interface

Auteur Bert Dingemans
Alias
Stereotypes ApplicationInterface
Details van Report

Dashboard

Auteur Bert Dingemans
Alias
Stereotypes ApplicationInterface
Details van Dashboard

Change Data Capture

Auteur Bert Dingemans
Alias
Stereotypes ApplicationInterface
Details van Change Data Capture

JSon/REST

Auteur Bert Dingemans
Alias
Stereotypes ApplicationInterface
Details van JSon/REST

File transfer

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

Auteur Bert Dingemans
Alias
Stereotypes ApplicationInterface
Details van File transfer

Webservice

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

Auteur Bert Dingemans
Alias
Stereotypes ApplicationInterface
Details van Webservice

Graphs

Auteur Bert Dingemans
Alias
Stereotypes ApplicationInterface
Details van Graphs

Fileshare

Auteur Bert Dingemans
Alias
Stereotypes ApplicationInterface
Details van Fileshare

Packages and stored procedures

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

Auteur Bert Dingemans
Alias
Stereotypes ApplicationInterface
Details van Packages and stored procedures

FTP

Auteur Bert Dingemans
Alias
Stereotypes ApplicationInterface
Details van FTP

SFTP

Auteur Bert Dingemans
Alias
Stereotypes ApplicationInterface
Details van SFTP

XML/SOAP

Auteur Bert Dingemans
Alias
Stereotypes ApplicationInterface
Details van XML/SOAP

Database link

Specific implementation of an interface based on a database link concept

Auteur Bert Dingemans
Alias
Stereotypes ApplicationInterface
Details van Database link