Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions,
see Getting Started with Amazon Web Services in China
(PDF).
Data Federation using Amazon Services
Data federation is a data management strategy that enables, real-time analytics, single source-of-trust, no data duplication or expensive pipelines.
When there is a business requirement to have a consolidated data for transactional, analytics, machine learning, it is preferred for the data to be accessed from the source rather than replicated to avoid latency, inconsistency and extra storage cost.
In the context of SAP and Amazon services, it allows organizations to access, combine, and analyze data from both SAP systems and Amazon cloud services seamlessly.
Amazon Athena
Amazon Athena is a serverless, scalable and flexible interactive query service by Amazon that allows to analyze data directly in Amazon S3. The data stored in Amazon S3 from multiple sources can be further transformed into tables and views using Amazon Athena and queried to replicate meaningful information in a structured way.
Data in Athena can be accessed from SAP Datasphere through data federation from SAP Datasphere connections. Users can also access SAP Datasphere tables and views from Athena by querying SAP HANA using an Athena Federated Query.
Data can also be federated to the SAP HANA Cloud by configuring Athena as a remote source using the Smart Data Access – Athena adapter. The Athena Federated Query connection can also be used to read data from a stand-alone SAP HANA Cloud environment.
Amazon Redshift
Amazon Redshift iis a fully managed, peta-byte scale data warehouse service from Amazon. Customers have built their data warehouses and build data models for analytics and reporting.
Data federation from Amazon Redshift into SAP Datasphere is possible with SAP HANA Smart Data Integration (SDI) or the SAP Data Provisioning Agent. Amazon Redshift data can also be federated through the Athena Federated Query data source connector.
Further resources
The Guidance for Data Federation between SAP and Amazon outlines the process of federating data between SAP and Amazon cloud analytics services, enabling you to establish a data mesh architecture. By federating data between SAP and Amazon. you can easily transform and visualize your data in a scalable, secure, and cost-effective way, helping you inform your decision-making.
