An integration in Data Hub connects a source system through a specific technology, such as RFC, JDBC, or OData, to the Lucanet Data Lake. Each integration corresponds to a source system that you select when you create a connection, for example SAP S/4HANA (RFC). The Source system drop-down list only displays the integrations that your company has licensed.

An integration in Data Hub consists of two parts:

  • A connection with the settings to access the source system. For more information, see Managing Connections.
  • One or more source datasets that specify which data to extract. For more information, see Managing Source Datasets.

The connections and source datasets of all integrations are listed on the Integrations page of Data Hub. Each integration has its own page, which describes the version of the integration, its prerequisites, every step from creating the connection to starting the import, the connection settings, every option of the source dataset configuration, example configurations, and the release notes. The pages of the individual integrations are listed under Available Integrations in Data Hub.

The following integrations in Data Hub are documented, in alphabetical order:

  • Microsoft Dynamics 365 Business Central Beta: The Microsoft Dynamics 365 Business Central Beta integration in Data Hub extracts data from Microsoft Dynamics 365 Business Central online through OData v4 and writes it into the Lucanet Data Lake as raw datasets.
  • Microsoft Dynamics 365 Business Central (JDBC): The Microsoft Dynamics 365 Business Central (JDBC) integration in Data Hub extracts data directly from the database of an on-premises Microsoft Dynamics 365 Business Central installation, including former Microsoft Dynamics NAV (Navision) installations, through JDBC and writes it into the Lucanet Data Lake as raw Parquet datasets.
  • Microsoft Dynamics 365 Business Central (OData): The Microsoft Dynamics 365 Business Central (OData) integration in Data Hub extracts data from Microsoft Dynamics 365 Business Central through OData v4 and writes it into the Lucanet Data Lake as raw Parquet datasets.
  • SAP S/4HANA (RFC): The SAP S/4HANA (RFC) integration in Data Hub extracts data from an SAP S/4HANA system through RFC and writes it into the Lucanet Data Lake as raw Parquet datasets.

Importing data with an integration in Data Hub takes the same three steps for every integration. The page of each integration describes every step with the options of that integration.

To import data with an integration in Data Hub, proceed as follows:

1

Creating a Connection

Create a connection and select the integration in the Source system drop-down list. The connection contains the settings that Data Hub uses to access the source system. For more information, see Managing Connections.

2

Creating a Source Dataset

Create a source dataset for the connection and specify which data to extract from the source system. For more information, see Managing Source Datasets.

3

Starting an Import

Start an import of the source dataset. Data Hub extracts the data from the source system. For more information, see Importing Data.

This content was generated using AI and reviewed by Lucanet subject matter experts before publication.