In this post, we are going to talk about data integration between SAP Data Warehouse Cloud and Amazon S3. And the example here generally explains how easily SAP Data Warehouse can access external data sources like csv data stored in Amazon S3 bucket.
First things first, we create a private bucket and upload the csv file into it.
Next, we need an S3 user with programmatic access and have an access key created for this user.
And of course, we need to attach proper policy for the user in order to access the S3 bucket later. We assign full s3 access here for testing purpose.
Now, in SAP Data Warehouse Cloud, we are going to create a new connection to S3 bucket. You will find the connections tab under Space Management/Your Space.
Fill up all the required fields as shown in the screenshot. Once it is created, you can also check the connection status by clicking the validation button.
Next, we create a new Data Flow which will utilize the connection we created as data source.
You can explore the bucket now and drag the csv data file into the work area as a data source.
In summary, this post presents you with how an easy data integration could be done from SAP Data Warehouse to Amazon S3 and what we can do with the connection we set up. And of course, SAP Data Warehouse is capable of accessing various external data sources. You can find more on its main page.
Thanks for reading. If you have any questions, please reach out to ci_sce@sap.com.
First things first, we create a private bucket and upload the csv file into it.
Next, we need an S3 user with programmatic access and have an access key created for this user.
And of course, we need to attach proper policy for the user in order to access the S3 bucket later. We assign full s3 access here for testing purpose.
Now, in SAP Data Warehouse Cloud, we are going to create a new connection to S3 bucket. You will find the connections tab under Space Management/Your Space.
Fill up all the required fields as shown in the screenshot. Once it is created, you can also check the connection status by clicking the validation button.
Next, we create a new Data Flow which will utilize the connection we created as data source.
You can explore the bucket now and drag the csv data file into the work area as a data source.
In summary, this post presents you with how an easy data integration could be done from SAP Data Warehouse to Amazon S3 and what we can do with the connection we set up. And of course, SAP Data Warehouse is capable of accessing various external data sources. You can find more on its main page.
Thanks for reading. If you have any questions, please reach out to ci_sce@sap.com.
- SAP Managed Tags:
