aster.cloud aster.cloud
  • /
  • Platforms
    • Public Cloud
    • On-Premise
    • Hybrid Cloud
    • Data
  • Architecture
    • Design
    • Solutions
    • Enterprise
  • Engineering
    • Automation
    • Software Engineering
    • Project Management
    • DevOps
  • Programming
    • Learning
  • Tools
  • About
  • /
  • Platforms
    • Public Cloud
    • On-Premise
    • Hybrid Cloud
    • Data
  • Architecture
    • Design
    • Solutions
    • Enterprise
  • Engineering
    • Automation
    • Software Engineering
    • Project Management
    • DevOps
  • Programming
    • Learning
  • Tools
  • About
aster.cloud aster.cloud
  • /
  • Platforms
    • Public Cloud
    • On-Premise
    • Hybrid Cloud
    • Data
  • Architecture
    • Design
    • Solutions
    • Enterprise
  • Engineering
    • Automation
    • Software Engineering
    • Project Management
    • DevOps
  • Programming
    • Learning
  • Tools
  • About
  • Data
  • Engineering

Data Fusion SAP Accelerator For Procure 2 Pay

  • aster.cloud
  • January 25, 2022
  • 3 minute read

Earlier this year, we announced SAP Integration with Cloud Data Fusion, Google Cloud’s native data integration platform to seamlessly move data out of SAP Business Suite, SAP ERP, and S4/HANA. This was followed by the release of our accelerator for SAP Order to Cash which simplifies integrating SAP Order to Cash data into BigQuery and allows organizations to gain invaluable insights using Looker.

Even with a reliable and scalable integration platform like Cloud Data Fusion, creating pipelines to incorporate mission-critical enterprise data into warehouses can be tedious. Hence, the accelerator includes:


Partner with aster.cloud
for your next big idea.
Let us know here.



From our partners:

CITI.IO :: Business. Institutions. Society. Global Political Economy.
CYBERPOGO.COM :: For the Arts, Sciences, and Technology.
DADAHACKS.COM :: Parenting For The Rest Of Us.
ZEDISTA.COM :: Entertainment. Sports. Culture. Escape.
TAKUMAKU.COM :: For The Hearth And Home.
ASTER.CLOUD :: From The Cloud And Beyond.
LIWAIWAI.COM :: Intelligence, Inside and Outside.
GLOBALCLOUDPLATFORMS.COM :: For The World's Computing Needs.
FIREGULAMAN.COM :: For The Fire In The Belly Of The Coder.
ASTERCASTER.COM :: Supra Astra. Beyond The Stars.
BARTDAY.COM :: Prosperity For Everyone.

  • An SAP connector
  • Staging and transformation pipelines in the Data Fusion hub to load the staging schema on BigQuery
  • Target schemas in Google BigQuery for the staging, dimension, and fact datasets
  • A predefined Looker block with a semantic model and operational dashboards

With these integrations, teams spend less time developing data pipelines, defining key metrics, and building out visualizations and instead spend more time analyzing the information and making informed business decisions.

We are now releasing our accelerator for the procure-to-pay process. Let us look into the details of the process and what the accelerator provides.

What is Procure to Pay?

Procure-to-pay is a critical business process that includes requisition processing, sourcing, purchase order processing, goods receiving, accounts payable management, and reporting. A typical procure-to-pay process involves the creation and maintenance of vendors, direct and indirect materials, purchase requisitions, purchase orders, goods receipt, and billing.  Most enterprises depend on these business processes, and they measure success using key performance indicators (KPI’s) around purchase orders, suppliers, cost, etc. As such, It becomes critical for key stakeholders to get insights into these metrics like the procurement cost, cost avoidance, on-contract vs. off-contract spend, supplier scorecard, cost-saving, and overall procurement ROI to effectively measure the health of procurement, develop new sources of supply, and sourcing strategies.

Read More  Google Cloud Now The Most Favored Platform For Research Globally, According To Ipsos

SAP Accelerator for Procure to Pay

As a part of the Google Cloud SAP Accelerators, we are excited to announce the SAP accelerator for procure-to-pay. These accelerators are blueprints and defined content that gives customers a quick start for procure-to-pay scenarios and can be customized as per specific customer needs.

Google offers the following components as a part of the accelerator:

  • Data integration and transformation using Google Cloud Data Fusion
    • SAP Connector: SAP Table Reader connector that can be used for initial data load for all tables and incremental data load for selective tables
    • Staging Pipelines: These pipelines bring the raw data from SAP along with a mapping of abbreviated column names to useful English column names.
    • Transformation Pipelines: These are simplified BQ Execute pipelines that have embedded SQL statements that can be easily customized for specific customer scenarios.

Critical pipelines and  Key Business Entities in  Cloud Data Fusion for Procure to Pay

 

  • Target Schemas in Google BigQuery
    • Staging Dataset: The staging dataset is where data extracted from SAP through the Staging Pipelines lands
    • Dimension Dataset: After the staging dataset has landed, transformation pipelines are used to transform and capture key fields used for reporting. In the procure-to-pay accelerator, two tables are created: supplier_dimension and material_dimension, they contain information about each supplier and material
    • Fact Dataset: In addition to the dimension dataset, a fact dataset is also created, which contains tables that can be then aggregated in a Business Intelligence tool to calculate KPIs of interest. The procure to pay accelerator provides four tables: purchase_order_fact, goods_receipt_fact, invoice_fact, and accounting_fact which contains metrics around purchase orders, goods receipt, invoice,  and accounting postings
Read More  How The Home Depot Is Teaming Up With Google Cloud To Delight Customers With Personalized Shopping Experiences

 

  • Looker Block
    • Pre-built Semantic Model: The Looker block can be installed through Looker’s in-app marketplace and comes with a pre-packaged LookML model. Here, we have defined KPIs which can be directly used or further customized based on organizational needs
    • Operational Dashboards: Beyond the LookML model, this block comes with four dashboards that allow users to jump right in and begin analyzing their SAP data. One dashboard presents high-level trends in procure-to-pay while the other allows analysts to drill in and focus on the purchase orders, goods receipts and suppliers.

 

 

 

Getting Started with SAP Accelerator for Procure to Pay

For information on how to configure and run the Cloud Data Fusion pipelines, see the SAP Table Reader Guide and the blog.  You can find additional information on the SAP Accelerator for Procure to Pay here.

The Looker block will be released for preview in the Looker marketplace. The LookML powering the block is publicly available in this GitHub repository. You can find details on accessing the Looker marketplace and installing the block here. If you do not have access to a Looker instance and want to try out the block, you can sign up for a free trial here.

 

 

By: Chaitanya (Chai) Pydimukkala (Product Management, Data Integration)
Source: Google Cloud Blog


For enquiries, product placements, sponsorships, and collaborations, connect with us at [email protected]. We'd love to hear from you!

Our humans need coffee too! Your support is highly appreciated, thank you!

aster.cloud

Related Topics
  • Data Analytics
  • Google Cloud
  • Looker
  • SAP
You May Also Like
View Post
  • Engineering

Just make it scale: An Aurora DSQL story

  • May 29, 2025
Getting things done makes her feel amazing
View Post
  • Computing
  • Data
  • Featured
  • Learning
  • Tech
  • Technology

Nurturing Minds in the Digital Revolution

  • April 25, 2025
View Post
  • Engineering
  • Technology

Guide: Our top four AI Hypercomputer use cases, reference architectures and tutorials

  • March 9, 2025
View Post
  • Computing
  • Engineering

Why a decades old architecture decision is impeding the power of AI computing

  • February 19, 2025
View Post
  • Engineering
  • Software Engineering

This Month in Julia World

  • January 17, 2025
View Post
  • Engineering
  • Software Engineering

Google Summer of Code 2025 is here!

  • January 17, 2025
View Post
  • Data
  • Engineering

Hiding in Plain Site: Attackers Sneaking Malware into Images on Websites

  • January 16, 2025
View Post
  • Computing
  • Design
  • Engineering
  • Technology

Here’s why it’s important to build long-term cryptographic resilience

  • December 24, 2024

Stay Connected!
LATEST
  • 1
    Just make it scale: An Aurora DSQL story
    • May 29, 2025
  • 2
    Reliance on US tech providers is making IT leaders skittish
    • May 28, 2025
  • Examine the 4 types of edge computing, with examples
    • May 28, 2025
  • AI and private cloud: 2 lessons from Dell Tech World 2025
    • May 28, 2025
  • 5
    TD Synnex named as UK distributor for Cohesity
    • May 28, 2025
  • Weigh these 6 enterprise advantages of storage as a service
    • May 28, 2025
  • 7
    Broadcom’s ‘harsh’ VMware contracts are costing customers up to 1,500% more
    • May 28, 2025
  • 8
    Pulsant targets partner diversity with new IaaS solution
    • May 23, 2025
  • 9
    Growing AI workloads are causing hybrid cloud headaches
    • May 23, 2025
  • Gemma 3n 10
    Announcing Gemma 3n preview: powerful, efficient, mobile-first AI
    • May 22, 2025
about
Hello World!

We are aster.cloud. We’re created by programmers for programmers.

Our site aims to provide guides, programming tips, reviews, and interesting materials for tech people and those who want to learn in general.

We would like to hear from you.

If you have any feedback, enquiries, or sponsorship request, kindly reach out to us at:

[email protected]
Most Popular
  • Understand how Windows Server 2025 PAYG licensing works
    • May 20, 2025
  • By the numbers: How upskilling fills the IT skills gap
    • May 21, 2025
  • 3
    Cloud adoption isn’t all it’s cut out to be as enterprises report growing dissatisfaction
    • May 15, 2025
  • 4
    Hybrid cloud is complicated – Red Hat’s new AI assistant wants to solve that
    • May 20, 2025
  • 5
    Google is getting serious on cloud sovereignty
    • May 22, 2025
  • /
  • Technology
  • Tools
  • About
  • Contact Us

Input your search keywords and press Enter.