In a timeframe of a couple of weeks, SAP independently released 2 products for .NET interoperability: first [December 2010] the next version of the .NET Connector – NCo 3.0; followed a few weeks [Februari 2011] later by the public launch of Duet Enterprise – a combined effort of SAP and Microsoft. These near overlapping release moments may raise questions and uncertainty on the positioning of the 2 .NET interoperability products. Are they competing? Are the successive release moments a symptom of independent products groups within SAP, and will market acceptance determine which one will ‘win’? And what about the SAP ES Explorer? Earlier, SAP spokesman SAP ES Explorer vs. SAP Connector for Microsoft .NET the .NET connector outdated in favor of the ES Explorer.

In my thoughts and analysis, the story is differently. NCo3.0 and ES Explorer on one side, and Duet Enterprise all have a distinct positioning. The 3 products are neither competing nor exclusive for .NET interoperability. Each serves a specific and dedicated purpose.

NCo3.0 and ES Explorer

Both NCo3.0 and ES Explorer are in essence .NET Interoperability technologies. Neither of them is positioned as a product. You can not purchase or license it, but instead can download them from SAP Marketplace if you have a valid S-User ID that acknowledges you as a SAP developer. The release of .NET Connector 3.0 passed rather silently, with only an announcement on SDN. It has not received attention from any of the influencing  IT business magazines, nor IT Research Analysts. There was a Ramp-Up with selected beta-testers, but with minimal noise ahead and attention during.

  • NCO 3.0 is intended as a general purpose technology tool for low level integration plumping. Basically it enables bi-directional interoperability between .NET custom code and SAP RFCs and BAPI Function Modules. Nothing more, nothing less.
  • The role of SAP ES Explorer is in essence the same. In the earlier SAP statement, Rima Rudnik-Sirich characterized it as 'It succeeds SAP .NET Connector 2.0 for .NET'. The difference is within the interoperability manner. SAP ES Explorer works at the level of SAP Enterprise Services, W3*-compliant. You apply it as Visual Studio Add-In, to search through all the SAP Enterprise Services available in your landscape; standards ones from SAP, from third parties deployed in your landscape, and your customer-build Enterprise Services. Runtime invocation of the selected Enterprise Services occurs via a generated WCF service proxy.

Duet Enterprise

Duet Enterprise is a whole other story. Both SAP and Microsoft position it as a product that will directly provide business value. The Duet Enterprise release was done at large: a Virtual Launch Event, press releases and articles within the important IT business magazines, analysis reports by Forrester and CITO Research. Application of Duet Enterprise requires a license, the product can be purchased via SAP and Microsoft. (Note: at moment of writing there is no information disclosed on pricing and licensing model). Before reaching General Availability, Duet Enterprise is evaluated in a combined Ramp-Up / Rapid Deployment Program hosted by SAP and Microsoft together. Participating in the RDP was given substantial noise ahead, and intensive attention during the program course self. (Note: TopForce participated together with a large Dutch insurance company in this RDP.)

The role of Duet Enterprise is twofold. It comes out of the box with direct usable functionalities, and capabilities to compose customer-specific solutions. Its second face is what distinguished Duet Enterprise from the previous Duet versions: integration Foundation to build integration + interoperability that is specific for your situation. Also, SAP and Microsoft believe and want ISVs (the ecosystem) to deliver add-ons on the Duet Enterprise products, e.g. for specific vertical markets. To stimulate this, SAP and Microsoft also launched a partner program: Unite Partner Connection Program.  

The Duet Enterprise Foundation is also interoperability plumping, but of higher level as NCo 3.0 and ES Explorer. SAP / .NET interoperability occurs via standard W3* services; there is out-of-the-box support for SSO, Authorization, landscape monitoring. All aspects that earlier you typically had to handcraft yourself, and thus also maintain.

Duet Enterprise is bounded to usage from within a SharePoint 2010 context, and via SharePoint 2010 as intermediary layer in Office 2010 clients. Duet Enterprise has no role in other .NET contexts, e.g. SharePoint 2007 or 2003, Silverlight, WinForms or WPF apps, WCF handling, BizTalk.

Implications

The added value of Duet Enterprise [product, foundation] wrt NCo 3.0 and SAP Explorer [basic interoperability technologies] is that it raises the level of SAP - .NET interoperability. In addition to the bi-directional SAP - .NET runtime communication, it also provides interoperability concepts as SSO, Authorization, System Monitoring. And on top, it comes with direct usable functionalities, and capabilities to compose solutions [building blocks].

The limitation is that it only works from a SharePoint 2010 context (and via SharePoint in Office 2010 clients). If you need .NET interoperability from different .NET context, you have to resort to another approach. SAP provides for this both the NCo 3.0 and SAP ES Explorer; which one is usable is dependent on the level of SAP back-end consumption. If SAP Enterprise Services are available;  apply SAP ES Explorer; for RFCs and FMs you can use NCo 3.0.

Note: there are also several technologies and products delivered outside SAP to enable .NET interoperability. For instance Microsoft provides the BizTalk WCF LOB Adapter SDK, BizTalk itself; third parties provide product like Sitrion, Ometa, ERP Connect. For the scope of this article they are however not considered.

This is the second blog in a series on how to install, check and troubleshoot your Duet Enterprise installation. This time we will focus on the SharePoint side of the installation.

As you know Duet Enterprise is now General Available (GA) and can be downloaded from the Service Marketplace. [DVD: http://www.service.sap.com/swdc -> Installations and Upgrades -> A - Z Index -> D -> DUET ENTERPRISE -> DUET ENTERPRISE 1.0 -> Installation; Latest Service Pack SP02: http://www.service.sap.com/patches -> A - Z Index -> D -> DUET ENTERPRISE -> DUET ENTERPRISE 1.0 -> Comprised Software Component Versions -> SAP IW FND 100 & SAP IW CNT 100 & SAP IW TNG 100 , ...]

If you bought the required licenses from SAP you will also find the Microsoft bits that are required for the SharePoint 2010 add-on on the Service Marketplace. Unlike with the SAP installation you can jump right to SP02 and install these files. So there is no need to first download and install the DVD, but you can go to http://www.service.sap.com/patches -> A - Z Index -> D -> DUET ENTERPRISE -> DUET ENTERPRISE 1.0 -> Comprised Software Component Versions where you will find the SharePoint parts under DUET ENTERPRISE CONTENT 1.0. (if you are a Microsoft customer you can download this software from MSDN).

The most up-to-date documentation on what exactly has to be done on the SharePoint side can be found online on Microsoft TechNet. In this blog I will concentrate on the very basic steps to setup a Proof of Concept.

Prepare the SharePoint Server

The first step that you -- as the SharePoint administrator -- must do is collect and handover some information to the SAP admin. Like outlined in the first blog this is the HTTPS enabled URL to the SharePoint server,  the SSL certificate and the STS certificate and -- if required -- connection details to the Active directory. You should also hand over the SAP Service Models.ZIP file that contains template BDC (Business Data Catalog) XML files that will be modified and retrurned to you by the SAP admin.

FieldExample
HTTPS URL to the SharePoint Serverhttps://contoso.corp.com:443
SSL certificate of the SharePoint server\\\\contoso\\UpdatedModels\\DuetSSLCert.cer
STS certificate of the SharePoint server\\\\contoso\\UpdatedModels\\DuetSTSCert.cer
BDC Models for Duet EnterpriseSAP Service Models.zip
AD DS Server namecontosoDC
Port number of AD DS389
AD DS account and passwordContoso\\ADUser
Attribute in AD DS where SAP user name is maintainedThis name is an attribute in AD DS. For example, sAMAccountName.
User Base Domain NameCN=Users,DC=dev24,DC=dev,DC=contoso,DC=com

 

Since the goal of this blog is to setup a proof of concept environment (with the Start Service ready-to-use capabilities), I will explain how to create a new web application (so there is no intereference with your existing web applications that you might have running), extend it for secure access and also create a self signed certificate.

Install Duet Enterprise Add-on

Installing Duet Enterprise is as simple as installing any Microsoft product. Just run setup.exe from the SP02 installation files. By default it will create a folder on C:\\Program Files\\Duet Enterprise\\1.0 and copy all required files in there.

Then you have to install Duet Enterprise into SharePoint. For this open a command shell and run from the above folder DuetConfig.exe /Install

That was it. Now Duet Enterprise should be ready...

TeaserMossPreReq.gif

Install Content

Again I will first concentrate on the ready to use capability Reporting, Starter Servivces and Workflow. The main goal really is to see "some" SAP data in SharePoint and then continue from there --  after all Duet Enterprise is an integration platform. The next steps can only be performed once you get some information from the SAP admin.

Field

Example

User name for WSDL access

SP_ACCESS
Password for WSDL accessSomePassword
SSL certificate of SCL SystemSSL_servername.cert
Updated BDC Model filesBDC.zip

Since the communication from the SAP system (or better the Service Consumption Layer, SCL) to SharePoint is done via SSL we have to import the SSL certificate from the SAP system first. Then we also have to import Business Data Connetivity, BDC models. This can be done manual (but is a very painful process), or via the DuetConfig tool.

Before running this tool make sure that you have created / initialized the Secure Store in SharePoint Central Administration. After that run

DuetConfig /ImportBDC <path to the extracted BDC model files>\\models.xml /AddUsers "NT Authority\\Authenticated Users" /UserName SP_ACCESS /Password <Password> /Email <Email>

With this command all the models in the BDC.zip will be imported, all Authenticated users will get access to use these services (however, in the end site permissions and of course SAP permissions will kick in) and for retrieving the WSDLs from the SAP System that are mentioned in each model file, the service user SP_ACCESS will be used.

After that -- even if you are not going to use Reporting or Workflow -- deploy all scenarios to SharePoint. Like said we want to get the Start Services running and for that we need everything deployed. For Reporting and Workflow you first have to adjust the DuetConfig.exe.config files.

The important things here are the Reporting section where you have to specify the HTTPS enabled web application URL and a service user (which is used to send data from the SAP system to SharePoint).
Then in the workflow section you also have to specify a service user. They can be the same, but I would recommend to use two different ones to make troubleshooting simpler.

Once that is done, just run (where vmw3428 is my SharePoint server and 20000 is the port of my web application):

DuetConfig.exe /configuresolution "Reporting" /webappurl http://vmw3428:20000

This will deploy the required solutions on SharePoint. Then just continue with the other solution.

DuetConfig.exe /configuresolution "Workflow" /webappurl http://vmw3428:20000
DuetConfig.exe /configuresolution "ProductWorkspace" /webappurl http://vmw3428:20000
DuetConfig.exe /configuresolution "OrderToCash" /webappurl http://vmw3428:20000
DuetConfig.exe /configuresolution "CustomerWorkspace" /webappurl http://vmw3428:20000
DuetConfig.exe /configuresolution "Portal" /webappurl http://vmw3428:20000

That is it!

Create a new Site Collection

Now go to SharePoint Central Administration from which you can create a new Site Collection on the web application that you have specified above.

When the site collection is created -- and the users are already mapped on the SAP side -- you should already see data under the Customers, Products or Reporting tab.

However, before Reporting and Workflow can be used you have to hand over two additional URLs and access users to the SAP admin. This is the WSDLs for OBAFileReceiver (=Reporting) and OBAWorkflowService (=Workflow). Without this information no Reports or Workflow will ever reach SharePoint :-). The URL is always build up like this https://<server>:<port>/<yourSiteCollection>/_vti_bin/OBAFilesReceiver.asmx?wsdl or https://<server>:<port>/<yourSiteCollection>/Tasks/_vti_bin/OBAWorkflowService.asmx?wsdl

Field

Example

URL to OBAFileReciever for reporting

https://contoso.domain.com:443/sites/DuetEnterprise/_vti_bin/
OBAFileReceiver.asmx?wsdl

URL to OBAWorkflowService for Workflow

https://contoso.domain.com:443/sites/DuetEnterprise/Tasks/_vti_bin/
OBAWorkflowService.asmx?wsdl

 

Account name

Description

Report publisher account

Contoso\\ReportingUser

SAP workflows service account

Contoso\\WorkflowUser

 

You can take a look at all these steps if you click on the image below.

TeaserMossInstall.gif

It's that simple!

Like I said the goal here was just to get you started. In the next Microsoft related blog I will talk about Workflow (which requires a little more configuration), the Role Sync (which also requires the configuration of the User Profile Store) and the My Site / My Profile integration.

Stay tuned...

Filter Blog

By author: By date:
By tag: