You can use Amazon S3 V2 Connector to connect to Amazon S3 from Data Integration.
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.
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.
Amazon S3 V2 Connector cannot read or write Avro, JSON, ORC, and Parquet files on Windows.