Source and Destination

An interface often consists of exactly one source system ("source") (from which data is to be transferred or exported) and one target system ("destination") (to which the data is to be imported).

Examples of such simple interfaces are:

Transferring fields from a database table to an Excel list
Import of data from a csv file (e.g. from an export from SAP) into a PIM system (e.g. into the Contentserv PIM system)

In these cases it is sufficient to define a "source module" and a "destination module" in ADIB and to store the corresponding parameters.

NOTE: Special modules (such as the export of data from the Contentserv system) are usually defined neither as a source module nor as a destination module - but rather as a ws module (see below).

Source module

The source module defines the source of the application integration - i.e. where the data that you want to send to another system comes from. Depending on the selected module (e.g. MySQL), different (connection) parameters must then be entered so that ADIB knows how to access the data.

Example: You would like to regularly write the data from a MySQL table to an Excel file.

The following source modules are available:

Excel: The source data is in the form of an Excel (or csv) file.
MySQL: The source data is available in a MySQL database.
MS_SQL: The source data is in a MS SQL Server database.
Oracle: The source data is in an Oracle database.
SQLite: The source data is in an SQLite database.
XML: The source data is an XML-file.
Contentserv-Cloud data model
Contentserv-Cloud PIM/DAM export

Note: Webservices (even if they are the source of an interface) will be defined as "ws-module" (see below)

Destination module

The Destination module defines the destination of the application integration - that is, where the data that you want to retrieve from the source system is written to. Depending on the selected module (e.g. MySQL), different (connection) parameters must then be entered so that ADIB knows how to access the data.

Example: You would like to regularly write the data from a MySQL table to an Excel file. In this case select MySQL as srcModule and Excel as destModule.

The following destination modules are available:

Excel: Export data to Excel files.
MySQL: Export data to a MySQL database.
MS-SQL: Export of data to an MS-SQL-Server database.
Oracle: The source data is in an Oracle database.
SQLite: The source data is in an SQLite database.
CS-ISA-Configuration PIM: The configuration of the Contentserv PIM system
CS-ISA-ItemImport PIM: The product data import for the Contentserv PIM system
CS-ISA-Valuelist PIM: The import of value lists into the Contentserv PIM system
CS-ISA-ItemImport DAM: The image import for the Contentserv DAM system
CS-ISA-Valuelist DAM: The import of value lists into the Contentserv DAM system
XML: The source data is an XML-file.