SAP Integration with SharePoint and Office 365

Views:
 
Category: Education
     
 

Presentation Description

SAP data can be integrated with Office 365 and SharePoint, codeless, two-way and with no-touch using the Layer2 Cloud Connector.

Comments

Presentation Transcript

slide 1:

14.04.2014 1 Integration SAP with SharePoint and Office 365 via NetWeaver and OData Frank Daske Business Development Manager Layer2 The Layer2 Cloud Connector integrates SAP with SharePoint and Office 365 via NetWeaver and OData in just minutes

slide 2:

Who is Layer2  As a Microsoft Gold Certified Partner and ISV based in Hamburg Germany Layer2 is one of the leading providers of Microsoft SharePoint Office 365 and Azure apps in Europe with a major focus on Data Integration Collaborative Knowledge Management Social Networking and Cloud.  Layer 2 has also been known as a reliable partner to customers in Central Europe offering additional consulting and services in the fields of SharePoint .NET programming and IT infrastructure for more than 20 years. 14.04.2014 Layer2 is one of the leading providers of Microsoft SharePoint and Office 365 apps in Europe 2

slide 3:

SAP Integration with SharePoint and Office 365: Key customer pain points 14.04.2014 The Layer2 Cloud Connector makes ALL native SharePoint and Office 365 features available for external data 3 How to provide SAP data in the well-known Office user interface How to make sure quality consistancy and up-to-dateness of integrated data How to avoid programming and complex architecture What about performance and relayability of the integration Do I need additional SAP licenses No How to securely transfer and access SAP data

slide 4:

What is the SharePoint Cloud Connector  Layer2 Cloud Connector can connect native SharePoint lists and libraries on- premise or in the cloud directly to almost any external data source codeless and bi-directional including SAP data.  All SharePoint features are available as usual for your your external data e.g. views search metadata alerts and even workflows to take business actions in SharePoint when external data records are changed.  The Cloud Connector simplifies your SharePoint architecture increases end user performance and availability overcomes limitations and solves many issues that still exists with the SharePoint out-of-the-box data integration via BDC and BCS today especially in the cloud.  The Cloud Connector runs as standalone application MMC and Windows Service on any Windows server or client safely within the corporate network. No access to SAP data from outside is required. No data transfer to 3 rd parties.  Supports SharePoint 2010 2013 SharePoint Foundation Office 365 and SharePoint Online all plans 14.04.2014 The Layer2 Cloud Connector makes ALL native SharePoint features available for external data 4

slide 5:

CC any local Windows server or client • Connection management • Data synchronization • Logging reporting Cloud Connector How does it all work 14.04.2014 The Layer2 Cloud Connector operates safely inside the corporate network. No data access from outside required. 5 SAP / NetWeaver Data Access Provider OData SharePoint Client Side Object Model CSOM Web Services HTTPS / SSL Windows AD Claims-based FBA Office 365 Standard ADFS Federated etc. Secure Data Transfer SharePoint / Office 365 No Direct Access

slide 6:

What else can be connected to SharePoint  Databases with existing ODBC / OLEDB / OData or other .NET based drivers 32-bit / 64-bit e.g. SQL Server SQL Azure Oracle IBM DB2 Informix AS/400 MySQL and many more.  File Content like Microsoft Office Excel Access XML CSV or other text files etc.  File System to sync with SharePoint libraries  Applications like Exchange Active Directory SharePoint etc.  ERP / CRM / DMS / ECMS systems like Navision SAP MS Dynamics etc.  Cloud-based systems like Salesforce SharePoint Online CRM Online Google Twitter Facebook any RSS or other XML-based web requests etc.  More data sources via 3rd party provider and gateways. 14.04.2014 Almost any data source can be connected to SharePoint via Business Data List Connector 6

slide 7:

Cloud Connector for SharePoint – Why we made it.  Overcome Limitations: SharePoint out-of-the-box solutions for external data integration such as the Business Connectivity Services BCS or SkyDrive Pro / One Drive for Business are not available for all SharePoint editions and have serious limitations – compared to native lists and libraries especially in the cloud. The Cloud Connector works with all SharePoint editions and connects to native lists or libraries. You have views search metadata alerts workflows as usual. No problems with forms or 3 rd party extensions.  Easy to configure – no changes in SharePoint: BCS is difficult to configure. Tools XML customizing or even programming a web service is required. The Cloud Connector is easily configured using wizards. Every admin can do it. No installation on SharePoint.  Secure access: BCS requires data access from outside to corporate data via web services. The Cloud Connector operates safely inside the corporate network as a “man in the middle” to push and pull data. No access from outside required. No 3 rd party involved.  Simple architecture and deep integration: BCS only displays the external data inside the SharePoint UI. That not only causes limitations but also ends up in a complex architecture with real-time user access to all external sources at any page view and possibly licensing issues as well. With the Cloud Connector users access native SharePoint lists and libraries only as a stable synced cache with high performance and availability.  Cost-effective solution: One-time fee per installation no user CALs no additional SAP licenses. 14.04.2014 The Cloud Connector can be easily installed 7

slide 8:

Installation Setup  register download unzip  select between 32-bit or 64-bit installation depending on requirements current hardware and OS providers to support. Both supported in case of SAP .  use the installer: start setup.msi  run as admin if required  accept license agreement  select typical installation  accept changes to computer  install the Cloud Connector components and additional data providers  press “Finish” to exit  you can upgrade repair or uninstall at any time using the installer again 14.04.2014 The Cloud Connector can be easily installed. 8

slide 9:

What is installed  Connection Manager 64-Bit or 32-Bit to manage your connections.  Start and Stop Cloud Connector Service to operate the Windows service for automatic background updates.  Start Synchronization Manually for debug and specific requirements only.  Cookie Manager required to support specific authentication features.  Folder access to samples documentation connections license log files etc.  Uninstall link.  Layer2 Data Providers 14.04.2014 The Cloud Connector can be easily installed. 9

slide 10:

The Connection Service  Layer2 Cloud Connector Service is installed as a Windows service.  This service automatically executes enabled connections defined with the Connection Manager in background.  You can operate directly in Server Manager Services or via Connection Manager.  Make sure that it is running to synchronize any connection in background. 14.04.2014 The Cloud Connector can be easily installed. 10

slide 11:

How to create a connection  Start the Connection Manager Windows Start Menu  To create a new connection please copy an existing sample connection that best fits your requirements. Click right and select “Duplicate Connection”.  For SAP please select „Sample – SAP NetWeaver to SharePoint Connection“  Rename and modify the new connection as required.  In case of a Personal Edition please note that you can have only one connection leftover. Remove all others before executing. 14.04.2014 With the Cloud Connector you can easily connect to almost any data source 11

slide 12:

SAP Data Entity Settings Define your data entity properties as follows:  Enter a data entity title e.g. SAP NetWeaver.  Take care about the entity type shown here e.g. source destination or bi-directional. You can modify in the connection settings.  Select a data provider to access your data entity. All installed drivers are listed. To connect to SAP you need the OData Provider.  Enter a connection string to connect to your data entity. You need the URL the collection authentication and user / password. The sample URL goes to the SAP NetWeaver Demo Portal  See Odata specifications below.  Enter a query to select your data or leave blank  When the query is verified take a look at the data preview see action menu right hand side to check for primary key.  Enter the primary keys if required here: agancynum The Cloud Connector requires a few inputs only to be configured - everyone can do 12 14.04.2014

slide 13:

Office 365 Data Entity Settings Define your data entity properties as follows:  Enter a data entity title e.g. my SharePoint Server.  Take care about the entity type shown here e.g. source destination or bi-directional. You can modify in the connection settings.  Select a data provider to access your data entity. All installed drivers are listed. To connect to SharePoint / Office 365 you need the CSOM Provider.  Enter a connection string to connect to your data entity. You need the URL to a list authentication and user / password.  See CSOM specifications below.  You don’t need any primary key list item ID is used The Cloud Connector requires a few inputs only to be configured - everyone can do 13 14.04.2014

slide 14:

Field Mapping between data entities  You have to map the fields / columns of your data entities to each other as follows:  There is no automatic creation of list structures. Please create the list and columns manually before mapping. Refresh mapping when the data structure has been changed.  If data source and destination have similar structure / field names you can enable auto-mapping. Auto-mapping is done automatically by field name.  Take care about the data types. There is some built-in type conversion but please match as best as you can.  Add new mapping entries using the “+” button. Remove unwanted mappings using the “-” button.  Unmapped fields are kept untouched in case of updates.  Map the SharePoint title column to any field that fits.  Verify mapping when you are ready. The Cloud Connector requires a few inputs only to be configured - everyone can do 14 14.04.2014

slide 15:

First Synchronization and further options  To sync your connection first time please press “Run Now” in connection settings.  Please note that the first update can take some time depending on amount of data and configuration. Take care about warnings or error messages. The free shareware is limited to 25 records / items. Contact saleslayer2.de for a time-limited full-featured trial.  After first update is finished successfully press update again. No items should be changed now if the given primary key works as expected and there are no mapping or type conversion issues. The 2 nd update should be much faster.  To process further updates automatically please enable scheduling. Set appropriate intervals depending on requirements amount of data and configuration.  Please note that the Connection Service must be running for background updates see root node of your connections tree  You can also update the connection on demand via command line or API. The Cloud Connector requires a few inputs only to be configured - everyone can do 15 14.04.2014

slide 16:

Highest Security Level  With the Cloud Connector your SharePoint users do not access your external data directly. That gives you the highest security level possible.  The Cloud Connector operates safely in the local network with full control.  No data access to local data from outside the network required e.g. via incoming web services.  No data is exposed to any 3rd party e.g. Windows Azure.  You can hide your connection settings by using encryption and file system access rights.  SSL / HTTPS fully supported for secure communication.  You can use integrated authentication if supported by the data providers.  No administrative rights required on the SharePoint side just write access to the target list. With the Cloud Connector you have highest seurity for your internal data 16 14.04.2014

slide 17:

Highest Performance – Reliable Architecture  End users do access native SharePoint list data only for highest performance – not the external source directly.  For best update performance use as few columns as possible e.g. no select from myTable. Use views in case of SharePoint.  Restrict your result set if possible using where clauses or views.  Changes are committed only – not the whole data sets.  The Cloud Connector is proven to work with up to more than 100.000 records / items depending on configuration and data source performance. No problem with the 5.000 items list view threshold in SharePoint. Use the unmodified AllItems view in this case.  Please note that the SharePoint configuration and bandwidth must meet the Microsoft requirements. With the Cloud Connector you have highest performance for data access 17 14.04.2014

slide 18:

All Native SharePoint List Features Available for your External Data  You can use native SharePoint lists and libraries of any type e.g. contacts  ALL list features are fully available  Views sorting filtering grouping calculated fields managed metadata tagging …  Search with all options as usual  Alerts and notifications RSS  Workflows on external data change with SharePoint OOTB Visio VS Nintex etc.  Additional SharePoint-only columns and attachments  Offline availability e.g. in Outlook Workspace SkyDrive Pro  Datasheet view detail forms InfoPath Nintex Forms etc.  Item context menus  Export to Excel  Events Web services XML  Compatible with all 3rd party add-ons With Cloud Connector you have all list features available without any restrictions 18 14.04.2014

slide 19:

What else can you do  Provide consistent enterprise data in SharePoint always up-to-date for your users to create lookups build forms etc. – before they copy manually.  Save LOB user CAL licenses e.g. for CRM/ERP because users don’t access the LOB system directly. They can work with the familiar SharePoint / Office interface now on-premise or in the cloud.  Build secure extranets with pre-selected replicated enterprise data for customers or other partners.  Access your pre-selected enterprise data mobile via Office 365.  Aggregate feeds right into SharePoint lists e.g. RSS or Twitter for search and notifications.  Sync your Office 365 or SharePoint Online cloud-based data with your local SharePoint.  Include your external data in SharePoint search Knowledge Management and Social Networking using terms and tags enterprise metadata activity feeds to keep your users up-to-date.  Sync files and folders from any local file system with SharePoint libraries.  Create cloud-to-cloud connections e.g. to Office 365 Salesforce MS CRM Google Facebook Twitter etc.  Replicate any data source with any other not only with SharePoint Enterprise Edition. With the Cloud Connector you have all list features available without any restrictions 19 14.04.2014

slide 20:

Layer2 Data Provider for SharePoint CSOM 1/2  Connects to SharePoint lists and libraries on-premise and in the Microsoft cloud bi-directional if required.  URL parameter required provides the link to the source list or library. Please copy from browser. Best to use a certain view.  Authentication provides an authentication method e.g. IntegratedWindows default Windows Office365 IECookie Anonymous ADFS ADFSWindowsIntegrated.  For Windows integrated authentication take care that all users that use update on demand have access and / or the Windows Timer Service account if background update is used.  For Windows and Office 365 authentication the parameter user and password are required additionally. Please use the same values as if you would login manually.  For IECookie authentication Cookie Manager is required. See below for more.  For ADFS authentication at Office365 / SharePoint Online the parameter OnlineUser username and password must be provided.  For ADFSWindowsIntegrated the parameter OnlineUser must be provided.  OnlineUser must be set to the mapped user id used as online id for Office 365 authentication. With the Cloud Connector you can sync your local data with other SharePoint or Office 365 lists or libraries 20 14.04.2014

slide 21:

Layer2 Data Provider for SharePoint CSOM 2/2  License Option: LicenseSPAppStore can be used to indicate that the licensing should be managed by Microsoft SharePoint 2013 App Store.  AppWebURL Option can be used to point to your app site e.g. AppWebUrlhttps://MyDomain- acfbd392f35f45.sharepoint.com/MySite  For best performance please use a defined view with the required columns only.  Select statements are not supported. Please use a view on data source side to select your data.  There are more options available for more specific requirements. Please see specification in FAQs.  Contact saleslayer2.de if there are any issues. With the Cloud Connector you can sync your local data with other SharePoint or Office 365 lists or libraries 21 14.04.2014

slide 22:

Layer2 Data Provider for OData  Use this provider to query external data via OData interface and sync bi-directional.  A common usage for this provider is syncing SAP NetWeaver data with SharePoint.  URL: This is the Service Root URL for the OData source.  Collection: Identifies the resource to be interacted with e.g. Products.  Authentication: See CSOM  Any OData query statement supported.  There are more options available for more specific requirements. Please see specification in FAQs.  Contact saleslayer2.de if there are any issues. With the Cloud Connector you can sync your local data with external Odata sources e.g. MS CRM Online 22 14.04.2014

slide 23:

Free Shareware Licensing  The Cloud Connector can be used as free Shareware with limitations 25 items per list. Full featured time-limited license on request.  The Cloud Connector can be licensed per local installation. No user CALs required. One-time fee.  Optional annual Software Assurance for free updates and upgrades per installation available.  The Personal Edition is limited to one connection to SharePoint.  The Professional Edition supports an unlimited number of connections but is limited to SharePoint on one end.  The Enterprise Edition has no limitations.  Several support options e.g. free or per hour.  No new installation is required for licensing just placing the license file in license directory.  You can order online using any payment procedure you want.  Contact saleslayer2.de if you have any questions or need a quote. 14.04.2014 You can use the Cloud Connector as free Shareware as long as you want – or license per installation. 23

slide 24:

Layer2 SharePoint Apps – who runs business with it  Layer2 apps are used all over the world in thousands of small mid-sized and large companies and organizations like The Coca-Cola Company Bauer Inc IBM Deloite US Defense Department NATO United Nations World Food Programme WFP Unico Banking Group Swiss Life AG and many others.  See www.layer2.de/en/products/ for more products and customer references. Layer2 is one of the leading provider of SharePoint Office 365 and Azure apps in Europe 24 14.04.2014

slide 25:

Layer2 Partner Program for Reseller and Implementer  Completely cost-free partner program. No contract required.  Partner links at our product pages. Sales leads will find you as a local partner and will contact you for order and implementation support.  Silver and Gold Partnership: 15 - 30 discount on production licenses to use our solutions in your external customer projects or for resale.  Place your orders using our on-line shop system. Simply enter your partner coupon codes to receive your discounts.  As a partner you can use our solutions internally for demonstration or within your intranet extranet or even Internet as free NFR version.  Premium support level with high priority and direct access to the product development team. Joint development options. Project support if required.  Free marketing and sales support ready to use digital marketing kit including flyers presentations and evaluation downloads. Layer2 as a vendor is powerful together with its partners - and for its partners. 25 14.04.2014

slide 26:

What are you waiting for  Please click below to register download and evaluate today. See here for FAQs. Make your SharePoint and Office 365 even better – download and try today. 26 14.04.2014

authorStream Live Help