I'm trying to use an AWS data pipeline to pull data from an externally hosted MySQL datasource into an RDS MySQL instance.
Is this even possible? How can it be configured? I can't find anything about this in the documentation.
If it's not possible, is there any better option, or am I better to set up a manual push from the external server to the RDS instance?