Oracle Communities

Oracle Analytics and AI

Child Item

How can I extract data by creating dataflow ?

Hi Community,
I need to download data from DV but as you all know there's a limitation on 1000 lines. My workbook is large so I am looking for an alternate method for data download in one go except for dividing data into chunks. So I came across a solution, by creating dataflow we can download over 1000 lines of data. But I don't know the process or steps for it. So it would be great if someone can guide me with the same.

Find more posts tagged with

Accepted answers

Mostafa Morsy-Oracle

@User_2QQI0 can we get more insights on your requirements here ?
What is limitation in dv for 1000 lines? is that Dataset file-based ?
if we get more details we can suggest best Options for you

I hope you elaborate more about the requirements so we can help

All comments

Sumanth V -Oracle

@User_2QQI0 - Data flows serve to combine, organize, and integrate data into datasets. Please refer to the document below to review all available options in data flows for integrating and organizing your data.
https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/what-steps-can-i-use-organize-and-integrate-my-data.html

Gianni Ceresa

@User_2QQI0 ,

Posting only a title isn't going to get you many replies.

The more time you invest in writing a full question, the more chances to get a valid reply you get.

For example things like what kind of "extract" do you have in mind? Let's not turn this into an XY problem: state your need and products you are having available, instead of thinking data flows is the thing you need and you just need to figure out how to make it work the way you decided it should.

Also, please update your profile by setting a "profile name" (also following the Oracle rules for employees to identify as Oracle).

Edit: OP now edited the question to add some content…

RanaAshutosh-Oracle

About Data Flows

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/data-flows.html

https://www.youtube.com/watch?v=ig5Lbx6sn5U

https://www.youtube.com/watch?v=HKVNupPd2pY

Mostafa Morsy-Oracle

@User_2QQI0 can we get more insights on your requirements here ?
What is limitation in dv for 1000 lines? is that Dataset file-based ?
if we get more details we can suggest best Options for you

I hope you elaborate more about the requirements so we can help

GayathriAnand-Oracle

Max rows exported to formatted reports for a classic report/dashboard is set to 1000 for a 1 OCPU instance. Based on your description that you are hitting 1000 row limit, I presume you have a 1 OCPU instance. If yes and If you are running a production workload, its strongly recommended that you scale up your OCPU.

The row limit for export for formatted and non-formatted reports is documented here : https://docs.oracle.com/en/cloud/paas/analytics-cloud/acoci/create-services.html

As for your statement about finding a solution using dataflows to overcome this limit, what is this solution that you are referring to? share details.

Thanks

Gayathri