1 Reply Latest reply on May 3, 2018 2:21 AM by kumar bharat

    Extract taking time due to API in oracle views

    Osama Mustafawi

      Dear All,

       

      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.

       

      Regards,