ParAccel Unveils Teradata, Oracle Analytics Offload Integration

Campbell, Calif.-based analytic database provider ParAccel will this week expand its Analytic Offload capabilities—by which firms can move complex analytic workloads out of their standard data warehouses and into ParAccel’s database for faster analysis—with the launch of Analytic Offload for Oracle and Analytic Offload for Teradata versions, created using new On-Demand Integration modules for loading data from Oracle and Teradata databases.

The new ODI modules provide analysts with in-line access to data in Oracle’s and Teradata’s data warehousing platforms. Firms have typically used those vendors’ data warehouses to support reporting and dashboard requirements, but it takes longer to run complex analytics, as well as to prepare the data modeling, indexing and partitioning of the data warehouse before the calculations can be run, says John Santaferraro, vice president of solutions and product marketing at ParAccel. Furthermore, the data warehouse needs to be reconfigured each time analysts want to run different types of queries, which leads to administrative backlogs to set up and run analytics, he adds.

ParAccel’s Analytic Offload solution uses the ODI modules and the vendor’s analytic platform, combined with a set of services to help firms identify which analytics to move from their data warehouse to ParAccel’s platform.

“These traditional data warehouses are pretty good when it comes to the static and simpler analytics, but where ParAccel excels is when the analytics become more dynamic, with constantly changing data and algorithms, or where you have very complex kinds of analytics,” Santaferraro says. ParAccel’s column-based storage and parallel-processing architecture is purpose-built for running complex calculations, such as complex risk calculations or enterprise risk management across different kinds of portfolios, he adds.

Rather than spending the majority of their time gathering data and waiting for calculation results, offloading analytics onto ParAccel’s platform enables analysts to spend more time focusing on their analysis and developing new queries, Santaferraro says. “This whole solution is designed to relieve all that analytic backlog, to free up the data warehouse to do what it was designed to do, and to create an environment of unconstrained analytics for analysts to use our platform to do the analysis they were hired to do,” he says.