You can use Amazon S3 V2 Connector to connect to Amazon S3 from Data Integration.
You can create an Amazon S3 V2 connection and use the connection in mappings or mapping tasks. You can switch the mapping to advanced mode to include transformations and functions that enable advanced functionality. The advanced cluster can be a self-service cluster, a local cluster, or hosted on Amazon Web Services. You can read and write primitive data types for Avro, Parquet, JSON and ORC files.
Use Amazon S3 V2 Connector to read or write Avro, flat, binary, ORC, and Parquet file formats for mappings, and Avro, flat, ORC, Parquet and JSON for mappings in advanced mode. You can read and write hierarchical data types only for Avro, Parquet and JSON for mappings in advanced mode.
Create a mapping task to process data based on the data flow logic defined in a mapping or integration template.
You cannot use Amazon S3 V2 Connector to read or write Avro, JSON, ORC, and Parquet files on Windows.