Logging RDS table inserts into AWS Cloudwatch
I have a requirement to extract data from a third party RDS Oracle table whenever it is updated or inserted. I thought of creating a trigger in the third party DB and calling a Lambda function to extract data when an insert happens. The third party has refused to allow external overheads like triggers in their system for our purpose. Considering this, I am analyzing over utlizing Cloudwatch logs to watch for inserts without intervening their DB setup. When instance table is inserted/updated, can this info be logged in cloudwatch or no?
Yes, you can configure your Amazon RDS for the Oracle DB instance to publish log data to a log group in Amazon CloudWatch Logs. With CloudWatch Logs, you can analyze the log data, and use CloudWatch to create alarms and view metrics. Amazon RDS publishes each Oracle database log as a separate database stream in the log group. For example, if you configure the export function to include the audit log, audit data is stored in an audit log stream in the /aws/rds/instance/my_instance/audit log group. RDS for Oracle supports the following logs:
- Alert log
- Trace log
- Audit log
- Listener log
- Oracle Management Agent log
- AWS Elastic Beanstalk - Environment must have instance profile associated with it
- How to delete all images in an ECR repository?
- How to Remove Delete Markers from Multiple Objects on Amazon S3 at once
- AWS MediaConvert: HLS Output Video Plays Without Audio, Despite .aac and .ts Files in S3
- EC2 Instance Cloning
- CDK Unable to Add CodeStarNotification to CodePipeline
- Invalid index in dynamic block
- AWS Cloudformation- How to do string Uppercase or lowercase in json/yaml template
- AWS CodeArtifact public npm package version missing
- R random numbers almost the same but not identical
- AWS CodePipeline: GitHub > CodePipeline (CodeBuild - Maven Java .WAR) > S3/CodeArtifact > Elastic Beanstalk (Apache Tomcat)
- InvalidImage(ImageLayerFailure: UnsupportedImageLayerDetected when deploying AWS Docker Lambda using AWS CDK
- Proper syntax in redshift sql for "schema"."table"."field"?
- Getting 'blocked by CORS policy' error while adding authentication from AWS
- Does AWS Step-functions-local support map tasks?
- How to find an Amazon EC2 AMI if I only have the id?
- Amazon EMR 7.2 does not support Ganglia?
- AccessDenied on AWS Athena
- Parsing secrets from AWS secrets manager using AWS cli
- Boto3 generate_presigned_url, SignatureDoesNotMatch error
- serverless Cannot have overlapping suffixes in two rules if the prefixes are overlapping for the same event type
- Error copying parquet file to Redshift having comma separated data in one column
- module initialization error: Cannot load native module 'Crypto.Cipher._raw_ecb' at AWS lambda
- AWS EC2 > IGW Outbound Traffic Filtering by Domain or URL
- The new key policy will not allow you to update the key policy in the future
- How to modify the nginx.conf file during AWS Elastic Beanstalk deployment
- DynamoDB not as scalable as it seems?
- How can I print / debug all available fields of a data source resource?
- How to upgrade AWS EC2 instance type t2.medium to t3.medium?
- chmod unable to change permissions