A connection specifies the authentication settings that Data Hub uses to access an external source system, such as SAP S/4HANA, Microsoft Dynamics 365, or an SQL database accessed through JDBC.

The settings of a connection in Data Hub depend on the source system. They are described in detail on the page of each integration, together with every step from creating the connection to starting the import. For the available integrations, see Integrations in Data Hub.

You can manage connections on the Integrations page, which you open from Data Hub in the main menu. The page lists every connection together with its source datasets: each connection is a parent row that you can expand to display the source datasets that use it.

Which actions you can perform for a connection in Data Hub depends on your user role for Data Hub and on whether you own the connection or the connection has been shared with you. For more information, see Sharing a Connection below and User Roles in the CFO Solution Platform.

The Integrations page is displayed as follows, for example:

Shows the 'Integrations' page in Data Hub with the connections 'MS-BC-Test' and 'SAP HANA Test' expanded to display their source datasets as child rows, for example 'BC GL Balance Filter' and '2022 ACDOCT'. The table has the columns 'Connection name, Number of associated data sources', 'Source system', 'Status', 'Created by', and 'Import', and the 'Import' column displays the status 'Succeeded' for some source datasets. Highlighted in red is 'Data Hub' in the main menu.
Connections and their source datasets on the 'Integrations' page

The overview table on the Integrations page in Data Hub provides the following information for each connection:

ColumnDescription
Connection name, Number of associated data sourcesName of the connection and the number of source datasets that use it
Source systemExternal system the connection is established to, for example SAP S/4HANA, Microsoft Dynamics 365, or an SQL database
StatusStatus indicating whether the connection is active or inactive
Created byUser who created the connection. The Created by column does not change when the owner of the connection is changed.
ImportStatus of the most recent import of the connection's source datasets

To create a connection in Data Hub:

1

In the main menu, select Data Hub. The Integrations page is displayed.

2

In the top-right corner, click Create new connection. The connection form is displayed as follows, for example:

Shows the connection form in Data Hub with the empty 'Enter connection name' field and the message 'This field is required.', the 'Test connection', 'Cancel', and 'Create' buttons in the top-right corner, and the open 'Source system' drop-down list with the options 'Microsoft Dynamics 365 Business Central (JDBC)', 'Microsoft Dynamics 365 Business Central (OData)', 'Microsoft Dynamics 365 Business Central Beta', and 'SAP S/4HANA (RFC)'.
Connection form with the source-system selection
3

Select the source system you want to connect to. For the selected source system, the Version of its connection template is displayed in the top-right corner of the Source system area.

4

Enter the connection settings for the selected source system. For more information, see Connection Settings below.

5

Optional: Click Test connection to check whether Data Hub can reach the source system with the settings you have entered. Data Hub tests the settings without saving them. For more information, see Testing a Connection below.

6

Click Create. The connection is created and displayed on the Integrations page.

The connection settings in Data Hub depend on the source system you want to extract the data from.

The following connection options in Data Hub are the same for every source system:

OptionDescription
Connection nameName that identifies the connection on the Integrations page. Required
SEA instanceInstance of the Lucanet.Script Execution Application (SEA) that runs the connection. Required for integrations that run on an SEA instance. Not displayed for integrations that run in the Lucanet cloud, for example Microsoft Dynamics 365 Business Central Beta
DescriptionOptional description of the connection

All other settings are provided by the connection template of the selected source system and are grouped by purpose. The values for these settings come from the source system.

The connection settings are displayed as follows, for example:

Shows the connection settings of an SAP S/4HANA (RFC) connection in Data Hub, with the connection template 'Version: 1.4.0' in the 'Source system' area, the 'SEA instance' field in the 'Configuration' area, the 'Language' field in the 'General' area, the 'Host', 'Instance number', 'Client', 'User', and 'Password' fields in the 'Authentication' area, and the 'Description' field.
Connection settings of an SAP S/4HANA connection

The connection settings of each integration in Data Hub are described on the page of the integration, for example the settings of SAP S/4HANA (RFC) or Microsoft Dynamics 365 Business Central (OData). For the available integrations, see Integrations in Data Hub.

Connections to Microsoft SQL Server, Oracle Database, and PostgreSQL databases use the Microsoft Dynamics 365 Business Central (JDBC) source system with the matching database driver. Their settings are described on the page of the Microsoft Dynamics 365 Business Central (JDBC) integration.

You can manage an existing connection from the Three-dot icon icon in the row of the connection on the Integrations page in Data Hub. Which options are displayed depends on your user role for Data Hub and on your permission for the connection. The following options are available:

OptionDescription
View detailsOption to display the settings of the connection without being able to change them
Test connectionOption to check whether Data Hub can reach the source system with the saved settings of the connection. For more information, see Testing a Connection below.
EditOption to display and change the settings of the connection and to display the users with whom the connection has been shared
Create new datasetOption to define a source dataset for the connection. For more information, see Managing Source Datasets.
Deactivate / ActivateOption to set the connection to Inactive or back to Active. While a connection is inactive, it cannot be used for imports, and all its source datasets are inactive as well.
ShareOption to share the connection with other users. For more information, see Sharing a Connection below.
Change ownerOption to transfer the connection to a new owner. This option is only available to users with the Administrator role for Data Hub. For more information, see Changing the Owner of a Connection below.
DeleteOption to delete the connection. You can only delete a connection which is not used by any source dataset.

When you deactivate a connection in Data Hub that still has active source datasets, you must confirm the change, and the connection together with all its source datasets is set to Inactive. Activating a connection again does not automatically reactivate its source datasets. You cannot deactivate a connection or source dataset while one of its imports is running or queued.

In Data Hub, a connection can be shared with other users who have the Data Manager role. These users receive the Manage permission, which enables them to edit, share, and delete the connection and to create source datasets for the connection. A connection can be shared with up to 50 users.

The following users can share a connection in Data Hub:

  • The owner of the connection
  • Users with whom the connection has been shared
  • Users with the Administrator role for Data Hub

To share a connection in Data Hub:

1

On the Integrations page, click the Three-dot icon icon in the row of the connection and select Share. The Share Connection dialog is displayed as follows, for example:

Shows the 'Share Connection' dialog in Data Hub for the connection 'Sales Data Business Central', with the 'Share with' drop-down list displaying 'Select user', the activated 'Manage' check box under 'Shared permission', and the 'Cancel' and 'Share' buttons.
'Share Connection' dialog
2

In the Share with drop-down list, select the users with whom you want to share the connection. You can select several users. The list contains only users with the Data Manager role for Data Hub.

3

Click Share. The connection is shared with the selected users.

When you share a connection in Data Hub, the users do not receive access to the source datasets of the connection. If required, you can share each source dataset separately (see Sharing a Source Dataset).

The users with access to a connection in Data Hub are listed on the Shared tab of the connection. The Shared tab is only available if you have shared the connection with at least one user. To display the tab, click the Three-dot icon icon in the row of the connection on the Integrations page and select Edit or View details from the context menu. Then click the Shared tab. If you display the tab with View details, you can view the users but cannot change their access.

The Shared tab of a connection is displayed as follows, for example:

Shows the 'Shared' tab of the connection 'Sales Data Business Central' in Data Hub, next to the 'Configuration' tab. The table with the columns 'Name', 'Owner', and 'Permissions' lists two users with blurred e-mail addresses: the owner with 'Yes' and the 'Edit' action, and a second user with 'No' and the 'Edit' and 'Revoke' actions, both with the 'Manage' permission. Below the table is the 'Share connection' button.
'Shared' tab of a connection

The Shared tab of a connection in Data Hub displays the following information for each user:

ColumnDescription
NameE-mail address of the user
OwnerIndicator of whether the user is the owner of the connection
PermissionsPermission of the user for the connection, for example Manage

On the Shared tab of a connection in Data Hub, you can manage the access of the users as follows:

  • Revoke access: Click Revoke in the row of the user and confirm. If the user has shared the connection with other users, the other users keep their access.
  • Change the owner: Click Edit in the row of the owner. The Change Connection Owner dialog is displayed. This option is only available to users with the Administrator role for Data Hub. For more information, see Changing the Owner of a Connection below.
  • Share with further users: Click Share connection below the table.

In Data Hub, users with the Administrator role can transfer a connection to a new owner, for example when the owner of the connection leaves the company. The new owner must have the Data Manager role for Data Hub.

To change the owner of a connection in Data Hub:

1

On the Integrations page, click the Three-dot icon icon in the row of the connection and select Change owner. The Change Connection Owner dialog is displayed as follows, for example:

Shows the 'Change Connection Owner' dialog in Data Hub for the connection 'Sales Data Business Central', with the current owner blurred under 'Owner', the required 'New owner' drop-down list displaying 'Select user', and the 'Cancel' and 'Change owner' buttons.
'Change Connection Owner' dialog
2

In the New owner drop-down list, select the user who is to become the owner of the connection.

3

Click Change owner and confirm the change. The selected user becomes the owner of the connection.

When the owner of a connection in Data Hub changes, the previous owner loses all permissions for the connection. All other users keep their access. The owners of the source datasets of the connection do not change. If the previous owner is to continue working with the connection, share the connection with the previous owner after the change.

When you test a connection, Data Hub checks whether it can reach the source system and whether the source system accepts the credentials. This way, you can detect an incorrect host, incorrect credentials, or an unavailable source system before an import fails. Testing a connection does not change its settings.

You can test a connection at any time, for example after the password has been changed in the source system. The following options for testing a connection are available in Data Hub:

WhereHowWhat is tested
Integrations pageIn the row of the connection, click the Three-dot icon icon and select Test connection.Data Hub tests the saved settings of the connection. You can also test an inactive connection.
Connection form, when you create a connectionIn the top-right corner, click Test connection.Data Hub tests the settings entered in the form without saving them.

Note: The Test connection button is available as soon as you have selected a source system and entered the required settings. A connection name is not required for the test.

Connection form, when you edit a connectionIn the top-right corner, click Test connection.Data Hub tests the settings in the form, including changes that you have not saved yet. If you do not fill in the Password field again, Data Hub uses the saved password.

You do not have to test a connection before you create or save it in Data Hub.

The Test connection option on the Integrations page is displayed as follows, for example:

Shows the 'Integrations' page in Data Hub with the menu of the connection 'MS-BC-Test' opened from the three-dot icon, listing the options 'Test connection', 'Edit', 'Create new dataset', and 'Deactivate'. Highlighted in red are the three-dot icon of the connection and the 'Test connection' option.
The 'Test connection' option in the menu of a connection

In Data Hub, the result of a connection test is displayed in a notification:

  • If the test is successful, the notification Connection Test Successful is displayed together with the source system, for example Successfully connected to SAP S/4HANA.
  • If the test fails, the notification Connection Test Failed is displayed together with the reason and what to check.

The following reasons can be displayed when a connection test in Data Hub fails:

ReasonWhat to check
The source system rejected the credentials.User name and password
The source system could not be reached.Host and port, and whether the source system is running and the port is open
The source system did not respond in time.Whether the source system is busy or temporarily unavailable. If so, try again in a moment.
The source system rejected the connection configuration.The connection settings
The connection could not be established.The credentials and the configuration

If the test cannot be performed at all, for example because the SEA instance does not respond, an error message is displayed instead of a test result. In that case, check that the SEA instance is running and try again.

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