I am extracting a view from Oracle database for a report which contains API(stored procedure) to get the summarize data value from different tables. I cannot go with the join methodology because the data is coming from 10 to 12 different tables and some of the tables doesn't have direct relationship with the other table so the API method is used to get the column data in the view.
The problem here is if i am creating the extract of that view it is taking too much time like 16 to 18 hours and still not getting completed.
Is there any way in tableau that I can call these API inside the Tableau workbook so that I don't need to extract the API columns during the extraction.
I also suggest do a performance recording on tableau server and see the performance output of workbook to see where is takes more time(bottle necks).
hope it helps.