Create external data group in Intrexx application

Below you will find a description of how to create an external data group that references the Intrexx Connector for SharePoint Server/Online.

Step-by-step guide

To create an external data group in an Intrexx application, proceed as follows:

  1. Start the application in which you want to create the external data group.

  2. Select the application and right-click on it.

  3. Select the "External data group" entry in the context menu.

    The "Properties - External data group" dialog box is displayed on the "General" tab.

    Title

    Enter the title of the external data group.

    Database connection

    Select "mssharepoint_<connector name>intrexxsharepointconnector" here (e.g. "mssharepoint_intrexxsharepointconnector").

    Datahandler

    Select "Connector Api - Data handler" here.

    Table / View

    1. Click on the icon.

      The "Search tables / views" dialog box is displayed.

    2. Click on Search.

      The data groups that were created in Intrexx Connector for SharePoint Server/Online are displayed.

    3. Select the desired table or data group.

    4. Click on "OK".

  4. Switch to the "Data fields" tab.

  5. Click on the icon.

    The "Select data field" dialog box is displayed.

  6. Select the data fields that you want to add to the external data group.

    Data type "file"

    You need the data type "file" to be able to access file attachments or to be able to upload and download them via your Intrexx portal.

    The "file" data type requires its own configuration.

    Detailed information on this can be found in section Set up file field in external data group.

  7. Click on "OK".

    You will return to the "Data fields" tab.

    The data fields are displayed.

  8. Switch to the "Expert" tab.

    The following keys and values are displayed:

    Attribute Value
    connector.dataGroup.adapter.class en.uplanet.lucy.server.odata.consumer.sharepoint.SharePointDataGroupAdapter
    sharepoint.list.name [ListName]
    sharepoint.list.type
    Cunning (For SharePoint lists)
    Library (For SharePoint document libraries)
    sharepoint.service.uri https://[TenantName].sharepoint.com
    sharepoint.site.name

    [SiteName]

    Sharepoint Online

    Enter the name of the "Site"(sites/mysite) here.

    Sharepoint On Premise

    Enter the name of the "Site" and the "SiteCollection path"(websites/mysite) here.

    In the next steps, you must replace the names [ListName], [TenantName] and [SiteName] shown in square brackets with the corresponding values from SharePoint.

  9. Click on Settings.

  10. Select the key "sharepoint.list.name".

  11. Click on the icon.

    The "Edit setting" dialog box is displayed.

  12. Enter the name of the SharePoint list in the "Value" selection field (e.g.: IntrexxSharepointList).

  13. Click on "OK".

    You return to the "External data group properties" dialog box.

  14. Enter the values for the other keys in the same way:

    Value Example
    sharepoint.list.type
    Cunning (For SharePoint lists)
    Library (For SharePoint document libraries)
    sharepoint.service.uri https://examplecompany.sharepoint.com
    sharepoint.site.name Intrexx SharePoint Site

  15. Click on "OK".

More information

You can find more information about external data groups in Intrexx in the following section External data group.

Next steps

Set up file field in external data group

Display data You can now display the data fields added to the external data group in a view table in your portal, for example.

Entering data You can write data in SharePoint by creating input fields with reference to the data fields in the external data group.

Detailed information on this can be found in the following sections: