Google last week launched the connection between Sheets and SAP. Companies using SAP and Google, can now export data directly from SAP GUI and SAP ECC 6.0 to Sheets and analyze the data with tools like charts, pivot tables, and Explore.
Google says that with this new integration, companies can skip manually exporting data to CSVs and uploading them to Drive.
Users can use the Sheets “Explore” feature to find new insights from data in SAP, easily analyze and create data visualizations, and collaborate with a single source of truth.
The integration between SAP GUI and Google Sheets is via Google Drive. Access uses the OAuth 2.0 protocol, so before SAP end-users can use the Google Sheets support, the SAP system administrator must perform a one-time set up to support OAuth authentication with Google Drive. The set up requires defining Google Drive as a web service in SAP and configuring BADI implementations and the SAP OAuth 2.0 Client to manage authentication with Google.
After access to Google Drive is set up, users can upload data to Google Drive by choosing the Google Sheets format when exporting their data to a spreadsheet. The first time users export to Google Sheets, they must sign in to Google. After they are signed in, they can return to the SAP GUI interface and export to Google Drive without further authentication.
The spreadsheet is exported to Google Drive as an Office Open XML file. Once in Google Drive, the spreadsheet can be accessed and edited directly through the Google Drive and Google Sheets interfaces by using any browser. In Google Drive, the data is stored permanently and can be accessed securely, shared with others, or downloaded in other formats.