DV dataset read flat files directly from an SFTP server?

Kartik Mali-Oracle

DV dataset read flat files directly from an SFTP server?

Is this functionality already available ?

We are not able to see the path in the upload files configuration, any suggestion how to utilize the functionality.

GayathriAnand-Oracle

OAC DV dataset cannot read files from sftp server. You will have to place file in OCI object storage and you can use OCI Resource connector to read from object storage.

Thanks

Gayathri

Kartik Mali-Oracle

Thank you Gayathri for the response.

Do you have any Oracle documentation to leverage the file to db load functionality in OAC/OAS using dataflows ?

GayathriAnand-Oracle

Not sure what specific documentation you are looking for here is the public doc for OAC Dataflows: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/data-flows.html

You can source from a dataset that is file based and write to a target table which is a oracle db connection.

Thanks

Gayathri