Teradata OLAP Connector Enriches Direct Excel Connectivity

Teradata Corporation has announced that the Teradata OLAP (online analytical processing) Connector provides Microsoft Excel PivotTable users with direct access to real-time data, which enriches their reporting and analytics capabilities. Supported by real-time business data, the new enterprise intelligence capabilities help companies make more insightful, timely business decisions, which can create a sustainable advantage.

“Teradata OLAP Connector allows Excel users to directly link to fresh and detailed data, without the disadvantages of always moving and storing data locally on their desktops. The extraction and storage of data in Excel Workbooks have many hidden costs, because it creates data inconsistencies between users and report auditability,” said Randy Lea, Vice President, Products and Services, Teradata Corporation. “The Teradata OLAP Connector allows business users to continue using their familiar tool Excel, and to maximise their decision making by leveraging the unmatched performance, scalability and manageability of the Teradata database.”

Businesses can rely on their internal resources or look for outside assistance to create an interface between Excel with Teradata. According to Dan Ross, Managing Partner, Claraview, a division of Teradata Corporation, “For business users who prefer to use Excel for their daily reporting and analytics, Claraview’s consulting services can assist customers to quickly create the interface. Users can get direct and optimised access to the business data and use that data to better manage their business.”

According to Lea, “The Teradata OLAP Connector allows business users to create their own self-service analytics by utilising a proven set of uniquely powerful and superior technologies - Teradata and Excel. Self-service analytics reduces the burden on the information technology organisation and increases the agility of users to respond to their consumers with greater speed.”

The Teradata OLAP Connector is the latest tool from the growing Teradata Business Intelligence Optimiser suite of products, which are designed to optimise the performance of business intelligence applications within a Teradata environment.