To report and analyze on these data sources, many companies are turning to tools like Tableau with rich visualization and trending capabilities. However, the first step to reporting on Oracle PBCS or FCCS data is often the most challenging: getting the data into Tableau from these source systems. Traditionally this has meant setting up external data extract jobs or Excel retrieves, manipulating the data into an appropriate format, landing the data somewhere that Tableau can pick it up, and ultimately pointing Tableau to stale data. This process introduces risk at each step as well as perpetuates inconsistent performance and delayed results.
Full post here.