Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
What is the best way to export large amount of data to file? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

What is the best way to export large amount of data to file?

Received Response
108
Views
16
Comments
in Planning 16 comments

Summary:

Trying to expor data to file but having issues of either Data export job generating .zip file, exportdataslice has cell limit of 500.000 or getting around cell limit by creating multiple files.

Content (required):

I am trying to export data from Planning into an external system (Power BI). I am able to read csv files from the outbox/inbox explorer directly into the external system using REST download (Download (oracle.com))

Initially I defined an Export Data job to generate the data file. However, the resulting file is in zip-format, which I am unable to process further. Is it possible to generate a csv-file instead of zip?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!