Export Portal Data to DB

rishub over 7 years ago

Hi All,

Do we have any plug-in through which we can export Portal Report Data to Database directly?

Thanks
Rishu

Discussion posts and replies are publicly visible

Parents

0 Stefan Helzle
A Score Level 3
over 7 years ago

You could create a web API which calls queryProcessAnalytics and creates a CSV. Not sure how much data you can export in one call. There are some limits. Another idea is, create an expression that creates CSV data from queryProcessAnalytics use the textDocFromTemplate to store it to a file. You could repeat (MNI) this and append to the same file when you write the placeholder to the file in the last line.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Stefan Helzle
A Score Level 3
over 7 years ago

You could create a web API which calls queryProcessAnalytics and creates a CSV. Not sure how much data you can export in one call. There are some limits. Another idea is, create an expression that creates CSV data from queryProcessAnalytics use the textDocFromTemplate to store it to a file. You could repeat (MNI) this and append to the same file when you write the placeholder to the file in the last line.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data