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.
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
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 ?
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.
Hi @GayathriAnand-Oracle. Could you please help us understand how we can transfer the files from the SFTP server to Object Storage?
Thanks Harika
Moving files from sftp to object storage is not a oac specific functionality. You could use products like Oracle Integration Cloud, OCI Data Integration, etc. for this
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
I tried the following expression and it blows up when I select more that one value in the list see image
We are using Oracle Analytics Server 2026 with WebLogic Server 14.1.2. Our Account Statement report is accessed through '/xmlpserver'. We need to capture the following details in the OAS/Publisher log files whenever a user runs the report: Username Report name and path Report execution timestamp Account Number From Date To…
We need to download a report with the order number as the file name. In the main report, we have a data action (hyperlink) on each order number. When we click an order number, the linked report is downloaded with the corresponding order details. Currently, the file is downloaded using the report name. We need to download…
Hi all I work in UK healthcare across 30 hospitals nationwide, and we're currently reviewing our Oracle estate and roadmap. Part of that is deciding whether to make a case for investing further in Oracle Analytics Cloud for workforce reporting, or whether OTBI and our existing tools are enough for now. Our HR data sits in…
