Skip to content
< BACK TO ARTICLES

OneStream

SAP Discontinues Maintenance, OneStream Rides in as a White Knight

6 minute read

As a company, CFO, or large enterprise that has used SAP (ECC or SAP S/4HANA) and seen the future development of the multitude of potential SAP products and the forced migration to a flawed product, your most pressing question may be:

"How on earth can we extricate ourselves from this web of software dependencies and still access and integrate our data cost-effectively?"

 OneStream, to many, is a ‘white knight’ riding into the fray of business corporate performance management legacy systems. It provides a unique ability to ensure data quality and enhanced financial reporting analysis while still offering drill-back capabilities to transactional details. Often the OneStream integration with SAP is more straightforward than using SAP CPM solutions, such as BPC. The following data integration illustration shows why over 100 SAP ERP clients have made the switch to OneStream.

 

Harmonious Integrations

OneStream allows a simple and harmonious integration with SAP (ECC or S/4HANA) in any of their versions. Communication can be direct with the ERP and Integration Servers such as SAP PI, SAP PO and SAP Cloud Platform Integrations. OneStream can adapt its interfaces depending on the client's SAP service architecture.

The most common integration plan includes direct connection. This simple solution is meant for non-complex SAP architectures. Its data integration is an easy two-way communication:

Screenshot 2024-06-06 at 4.46.39 PM

However, if your data methodology uses an SAP server, the integration becomes a three-layer process through an SAP integration server or SAP SCPI, which looks like this:

Screenshot 2024-06-06 at 4.47.18 PM

These standard frameworks can use a variety of different protocols but offer easy and simple solutions to ensure quick data transfer and easy data integration into the OneStream platform. 

 

Flexible Protocol Use

One of the reasons integrations are possible is OneStream's ability to use multiple data-call protocols to match your software dependencies and needs. There are a variety of protocols to integrate OneStream with SAP; the following are the most frequently used:  

REST

Representational state transfer (REST) is the most used protocol for these integrations, using HTTP requests to access and consume data. REST makes it easy to call data from various platforms and transfers pure human-readable data in JSON or XML. REST makes the business data self-explanatory and easy for laypersons to understand. Any device which can listen and speak HTTP can consume SAP Data through this protocol.

SOAP

One of the newer technologies for connecting to SAP architecture is the Simple Object Access Protocol (SOAP). This protocol is a pure web technology and can call functions using the HTTP protocol. Remote function calls (RFC), SAP interfacing communication between their systems, are also made available via the SOAP interface. 

RFC

The traditional way for communication between non-SAP systems and SAP is, according to SAP itself, the RFC interface. RFC interfaces are also often used to communicate between SAP systems themselves. Put simply, RFC is a remote function call. OneStream connectors are allowed to consume an SAP RFC.
With multiple options to integrate and secure data transfer between existing SAP architecture and OneStream, moving away from outdated technology and software systems is easier and more cost-effective than you may think.

 

Building Data BR-idges in OneStream

Once data connections are established with your existing SAP architecture, accessing your data is a comprehensive process that matches your Connector Business Rules (BR) to OneStream data fields to import, integrate and stabilize your data within OneStream.


OneStream data quality starts with a simple workflow setup that matches business rules for new or existing data fields and ensures full compliance within your current data organization. The following workflow chart shows the building of our BR-idges to your SAP data:

Screenshot 2024-06-06 at 4.47.59 PM

The logic required for this data conversion follows your Connector BRs as previously established and follows data logic pathing.

Screenshot 2024-06-06 at 4.48.42 PM

After the DataTable object is populated, we can refine the data or use LINQ to add additional logic. The last step is to pass the DataTable as an argument to the OneStream function: API.Parser.ProcessDataTable().

OneStream's data integration capabilities span many different types of data, including:

  •  Trial Balance Summaries
  • Transaction Detail
  • Statistical/Non-financial Data
  • Employees, Jobs and Positions
  • Leads, Opportunities
  • Users and User Security
  • Chart of Accounts
  • Dimensional Hierarchies
  • Operational Metrics
  • Currency Rates

Any data can be pulled from SAP that may be required to facilitate Financial Reporting or Planning processes in OneStream. The power of this process is further enhanced by OneStream's native drill-back and drill-through capabilities.

 

Drilling to the Heart of the Data

Comparing, qualifying and validating transactional data in other financial reporting software suites requires you to open another third-party application to drill-back or through to the original values. OneStream provides this within its platform, saving you a considerable amount of time.


The following diagram outlines how data is gathered, mapped, consolidated, integrated and provided to support your business reporting and analytics while still giving you drill-back and drill-through transparency.

Screenshot 2024-06-06 at 4.49.29 PM

In OneStream, your financial data is accessible and visible through every stage from its creation point to reporting. Even more important is integrating your data from legacy or disparate systems such as SAP and other ERP, CRM, GL, and HCM environments. This integration offers you business intelligence reports that are more accurate, automated and instantly available in real-time. Fully integrating your data across these various systems will allow you to reduce errors and inefficiencies, as seen above in the extensible Connector BRs, and enable your teams to make SmartCPM decisions.

I look forward to providing more in-depth tech tips and commentary on OneStream and its advantages in the months to come.


If you would like more information on OneStream or Ascend Partners, a globally renowned architect and implementation team, contact us today.

 

SOURCES:

https://www.onestreamsoftware.com/platform/financial-data-quality-management

https://blog.onestreamsoftware.com/why-data-integration-and-data-quality-are-critical-to-successful-cpm-projects

https://blog.onestreamsoftware.com/why-onestream-is-the-proven-alternative-to-sap-bpc

https://www.us-analytics.com/onestreamblog/onestream-xf-questions

https://cpminsights.com/2020/01/14/add-external-database-connection-in-onestream-quick-tip-5/

https://www.performanceanalytics.com/wp-content/uploads/2019/09/Bringing-Data-Integration-to-the-Next-Level.pdf

https://www.syntax.com/whats-the-difference-between-sap-ecc-sap-hana-and-sap-s-4hana/

Ascend Partners Technical Team, "SAP Connector Business Rules Brief," Internal Brief, February 2021.

Ascend Partners Technical Team, "SAP OS Data Integration Brief," Internal Brief, February 2021.

Industries we serve

From real estate to manufacturing, mining and everything in between, discover why OneStream is the CPM of choice for over 1,200 global enterprises across all verticals.

Learn More

Why Ascend?

Our team possesses the perfect combination of technical expertise and extensive knowledge to provide cutting-edge solutions that perfectly align with the constantly evolving technological landscape of today and tomorrow.

Discover the Ascend difference

Read our recent blog posts

ascend-partners-unveils-corporate-values-and-new-visual-identity-for-its-10th-anniversary Company Updates & Announcements

Ascend Partners unveils corporate values and new visual identity for its 10th anniversary

As Ascend Partners reaches a significant milestone, we are thrilled to announce the launch of our refreshed visual identity, marking a decade of growth, innovation, and unwavering commitment to our clients and partners.

READ MORE
ascend-partners-unveils-dynamic-new-visual-identity-reflecting-innovation-and-growth Press Release

Ascend Partners Unveils Dynamic New Visual Identity Reflecting Innovation and Growth

Ascend Partners, the most trusted OneStream Diamond Partner, is pleased to launch its new corporate values and refreshed visual identity to commemorate its 10th year anniversary. TORONTO, May 8, 2024 - Ascend Partners, a leading provider of bespoke ERP and EPM solutions specializing in OneStream Intelligent Finance, is thrilled to ...

READ MORE
ascend-partners-year-2023-in-review Events

Ascend Partners Year 2023 in Review

As 2023 comes to a close, Ascend Partners looks back on another remarkable year filled with success and growth. This year, Ascend experienced rapid internal expansion, welcoming 26 new employees from around the globe. Combined with our 21 hires in 2022, we are showing no signs of slowing down. Without a doubt, our achievements have come ...

READ MORE
navigating-onestream-administration-and-strategies:-webinar-insights OneStream

Navigating OneStream Administration and Strategies: Webinar Insights

Whether it's dealing with quarter-end crunch time, resolving mysterious validation issues, or finding ways to streamline workflows, the Ascend Partners’ team know all too well the realities OneStream admins face day-to-day to keep such a robust application (and all its data) running smoothly. That's why we were thrilled to have our VP of ...

READ MORE

Take control of your financial data

Schedule a consultation