Home icon

Building data integration with IBM Planning Analytics SaaS and AWS Lambda

IBM and Red Hat Blog

This article demonstrates how to build AWS Lambda functions with TM1py to transfer data between AWS data sources like Amazon S3 and Amazon RDS, and IBM Planning Analytics SaaS on AWS.

Specifically, the article covers:

  • Obtaining IBM Planning Analytics API keys and storing credentials in AWS Secrets Manager
  • Loading data from Amazon S3 to IBM Planning Analytics using AWS Lambda and TM1py
  • Creating an Amazon RDS database for PostgreSQL
  • Pulling data from IBM Planning Analytics to Amazon RDS using AWS Lambda and TM1py
  • Creating Amazon API Gateway REST APIs to invoke the Lambda functions
  • Testing data transfer between Amazon S3, IBM Planning Analytics, and Amazon RDS
  • An architecture for creating data integration pipelines from sources like Salesforce to IBM Planning Analytics
  • Conclusion on automating data integration with IBM Planning Analytics on AWS
Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Apr 5
2024
Accelerate Data Modernization and AI with IBM Databases on AWS
Aug 14
2024
Building integration APIs with IBM Cloud Pak for Integration and AWS services
Apr 9
2024
Build a Modern Data Architecture on AWS with your IBM Z Mainframe
Dec 3
2025
Enable AI with enterprise data using new IBM watsonx.data features on AWS

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.