Integration with AWS data sources

Data from AWS data sources can be harmonized with SAP and non-sap data via SAP Datasphere's data fabric architecture.

Architecture

Solution Diagram Resources

You can download the Solution Diagram as a .drawio file for offline use. Alternatively, you may view and edit the Solution Diagram directly on draw.io.
Please note that any changes made online will need to be saved locally if you wish to keep them.

Download

Edit

1. Integration with Amazon Athena

Mode(s) of Integration: Federating data live into SAP Datasphere .

Amazon Athena is Amazon's interactive query service that helps query and analyze data in S3.

Non-SAP data from Amazon Athena can be federated live into remote tables in SAP Datasphere and augmented with SAP buisness data for real-time analtyics in SAP Analytics cloud.

For detailed step by step information and to try out the integration, visit the blog : Integrate Amazon Athena with SAP Datasphere

2. Integration with Amazon S3

Mode(s) of Integration: Replicating data out with Replication Flows, Importing data into SAP Datasphere using Data Flows .

S3 is an Object storage service built to store and retrieve any amount of data from anywhere

Non-SAP data from Amazon S3 can be imported into SAP Datasphere though the Data Flow feature of SAP Datasphere for use with applications such as Financial Planning or business analytics in SAP Analytics Cloud .

For detailed step by step information and to try out the integration, visit the blog : Accessing data in Amazon S3 from SAP Datasphere

3. Integration with Amazon Redshift

Mode(s) of Integration: Federating data live into SAP Datasphere .

Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse service that is optimized for datasets ranging from a few hundred gigabytes to a petabyte or more .

Integrating Amazon Redshift with SAP Datasphere though its data federation architecture, you can augment the non-SAP data in Amazon Redshift with SAP data in SAP Datasphere and build unified data models. These models can be used to build stories and analytical applications in SAP Analytics Cloud. Smart Data Integration (SDI) is a key component that helps you to achieve this goal.

How You Get There - What is the solution?

Smart Data Integration (SDI) is a key component that helps you to achieve this integration. SDI uses CamelJDBCAdapter adapter to connect to the Amazon Redshift. Once SDI is configured to connect to SAP Datasphere and remote connection to Amazon Redshift is established, virtual tables can be created in SAP Datasphere for the source tables in Amazon Redshift. The virtual tables can be used just like regular tables in views and procedures. Data can be virtually access or can be snapshot replicated onto SAP Datasphere.

For detailed step by step information and to try out the integration, visit the blog : Data Federation from Amazon Redshift through SAP Datasphere