JavaScript is disabled on your browser.

The OData Protocol

The Open Data Protocol (OData in the following) is a standardized web protocol. It supports the simple integration and manipulation of data and is significantly more conveniently designed than previous web services for developing web and mobile applications.

OData is based on open web standards like HTTP, Atom Publishing Protocol and JSON, and like the World Wide Web, is constructed based on the REST (Representational State Transfer) architectural style. Complex database requests can be accomplished with OData using the URL alone. Consequently, OData is also known as "ODBC for the web".

Functionalities of the OData Business Adapter

The Intrexx OData Business Adapter allows data to be consumed and served.

Provide Data

When you provide data with the Intrexx OData Business Adapter, the following features are available to serve OData services using Intrexx:

Consume Data

When you consume data with the Intrexx OData Business Adapter, the following features are available to integrate OData services into Intrexx:

System requirements

The OData Business Adapter supports version 2.0 of the OData specification. Some characteristics specified in version 3.0 and later may already be available, but are not officially supported.

Provide Data

To ensure friction-free communication between the Provider and an OData client, depending on the type of connection (HTTP / HTTPS), the corresponding ports must be opened on both.

Furthermore, at least one Intrexx user is required for configuration and service creation. This user must also possess all required rights to create OData services in the Integration module of the Intrexx Portal Manager.

Consume Data

In order to create applications in Intrexx, OData services can only be used that provide a corresponding service metadata document. The connection test in the Intrexx service configuration checks this condition and returns a corresponding error message if no metadata is available.

To ensure friction-free communication between the Intrexx portal server and the OData server, depending on the type of connection (HTTP / HTTPS), the corresponding ports must be opened on both.

Further, for configuration and application creation with the adapter, at least one service user is required that possesses the required rights to access the metadata for the OData service.

Further information on this topic can be found in the Intrexx handbook OData Business Adapter.

SAP NetWeaver Gateway and the OData Protocol

The Open Data Protocol (hereinafter OData) is a standardized Web Protocol, that is used by SAP NetWeaver Gateway. It supports easy integration and manipulation of data, and is specifically designed to be far more convenient for the development of web and mobile applications than traditional web services.

OData is based on open Web standards including HTTP, Atom Publishing Protocol and JSON, and, like the World Wide Web, is built on the REST architecture style (Representational State Transfer). Complex database queries can be entered using OData via the URL alone. Accordingly, OData is also known as "ODBC for the Web".

Functionality of the Business Adapter

The Intrexx Business Adapter for SAP NetWeaver Gateway offers the following key features for the integration of SAP systems in Intrexx:

System requirements

To use the Intrexx Business Adapter for SAP NetWeaver Gateway successfully, at least SAP NetWeaver Gateway 2.0 Service Pack 2 is required. United Planet recommends Service Pack 3 or higher.

The Adapter itself supports the OData Specification Version 2.0. Functions, which are specified in Version 3.0 or higher, may in some cases already be available, but are not supported officially. For the creation of applications in Intrexx, only OData Services that provide a corresponding Service Metadata Document can be used. The connection test in the Intrexx service configuration checks for this condition, and issues an appropriate error message if no metadata is available.

To ensure smooth communication between the Intrexx Portal Server and the SAP NetWeaver server, the appropriate ports must be released, dependent on the connection type (HTTP / HTTPS). Furthermore, for configuring and building applications with the SAP Adapter, at least one user with the necessary privileges to access the metadata of the OData Services is required.

Further information on this topic can be found in the Intrexx handbook SAP NetWeaver Business Adapter.

Intrexx and Microsoft SharePoint

The Business Adapter for Microsoft SharePoint enables you to integrate SharePoint lists and document libraries into Intrexx applications and processes. The adapter expands Intrexx data groups with features that allow you to communicate with SharePoint using the HTTP and OData protocols and to transmit the data structures of both systems in the format needed for the other. With this, accessing the SharePoint server with Intrexx always takes place in the context of a SharePoint user, although any SharePoint authentication type is supported.

Features of the SharePoint Adapter

The SharePoint Adapter offers the following features:

System requirements

The Microsoft SharePoint Business Adapter from Intrexx (included as of version 7, online update 8) supports the SharePoint versions 2010 and 2013. Some features, however, are only available when using SharePoint 2013.

The adapter itself supports the SharePoint OData service on the basis of the OData specification 2.0. Features, which are specified in SharePoint 2013 with the OData version 3.0 service, are used to some extent by Intrexx for features specific to SharePoint 2013. When creating an application in Intrexx, the OData service must provide a corresponding service metadata document. The connection test in the service configuration tests this condition and delivers an appropriate error message if the metadata isn’t available.

So that communication between the Intrexx portal server and the SharePoint server runs smoothly, the corresponding ports must be opened, which ports depends on the connection type (HTTP / HTTPS). When using HTTPS, a security certificate must be imported via the portal’s properties dialog. Furthermore, at least one SharePoint user will be needed for the configuration and when developing applications with the adapter, this user needs to have the necessary permissions to access the metadata of the OData service. Additionally, this SharePoint user needs to be able to log in to SharePoint either with Windows-based authentication (user/password) or with forms-based authentication.

Licensing

You require a license to be able to use the Microsoft SharePoint Business Adapter. Please request a license either directly from your partner or from United Planet at the following email address info@unitedplanet.de. The license key will be sent to you via email.

Configuration

Creating a SharePoint connection

In the module Integration, you can setup a new connection to a Microsoft SharePoint data source under the point Consume data and by using the context menu New data source. Further information can be found in the Intrexx handbook Microsoft SharePoint Business Adapter.