I have got one requirement where we have to write real-time data to AWS Aurora (PostgreSQL) using StreamSets Data Collector. I have never worked on StreamSets but I have learn that it's a data connector. I tried to search to get something on this topic but no luck. Any idea how StreamSets can be used to write data to Aurora?
You can use StreamSets Data Collector's JDBC Producer destination to write data to Aurora. Data Collector includes the JDBC driver required for PostgreSQL.