For a recent project, I developed an integration to automate the synchronization of product data from SAP to HubSpot, using AWS tools like Lambda, DynamoDB, EventBridge, and SNS. The goal was to ensure that HubSpot always had the latest product information without manual intervention.
To achieve this, I designed a solution where AWS Lambda polls SAP at regular intervals for updated product details. This polling schedule is managed by Amazon EventBridge, which triggers the Lambda function at specific times to ensure that the data is consistently up-to-date.
When the Lambda function is triggered, it connects to SAP via API to fetch the latest product data. I used the Lambda function to process this data and format it into an Excel sheet, organizing critical product information like SKUs, descriptions, prices, and stock levels into a structured layout. The Excel file is then temporarily stored in Amazon S3, which serves as a secure and centralized repository.
The next step of the integration involved importing this data into HubSpot. I created another Lambda function that retrieves the Excel file from S3, reads its contents, and imports the product data into HubSpot via its API. This ensures that the sales and marketing teams always have access to the most recent product information.
To enhance the reliability of the process, I implemented Amazon SNS to send notifications in case of errors or issues, allowing for quick resolution. Additionally, I used DynamoDB to log each operation, tracking successful imports and any errors that occurred. This provides a persistent record that can be audited and reviewed.
The project highlights my ability to integrate complex systems, automate data flows, and ensure data integrity across platforms using AWS services.
