API rolls out joint solution for its enterprise data warehouse

Includes 2.1 terabytes of spinning disk

Australian Pharmaceutical Industries (API) is rolling out an integrated data warehouse solution to support its daily distribution of products to distribution centres and regional branches across the country.

API is using a joint solution from Teradata and Informatica which includes Teradata's 550P server with 2.1 terabytes of spinning disk.

Informatica will provide the data integration platform utilising PowerCenter 8 and PowerExchange.

API Pharmacy manager of information management, Doug Horwood, said the combination of technologies will improve the company's ability to react to changed circumstances and assist in monitoring performance and profitability through aggregated data and improved reporting.

"Efficiency in the API pharmaceutical wholesale business is vital to ensure that Australians are able to access all medicines from their local pharmacy within 24 hours no matter where they live," Horwood said.

He said the Teradata 550P Server and Teradata Database offer a completely integrated data warehouse solution with optimised system performance.

"API chose the 550P server for its speed of enquiry and future capacity expansion capabilities. The new enterprise data warehouse (EDW) will support faster information delivery to business users," he said.

"The company expects a significant improvement in publishing routine analytical reports by start of business the following day as well as providing more ad hoc on-demand capability to the user community."

Teradata A/NZ general manager, Noel Pettitt, said the decision by API to implement this solution shows the continuing momentum of Australian corporations turning to data warehousing for competitive advantage.

"Today, Teradata EDW solutions are being installed by businesses looking to improve results through better data analysis," he said.

"API is well on its way to having one of the premier data warehouses in the Australian pharmaceutical industry with actionable and timely information for business users, which is critical in the highly competitive wholesale business."

Informatica A/NZ managing director, Laurie Newman, said the link between data management and successful data warehousing was becoming more apparent.

Newman said API will gain significant value to its business and it will also ensure the costs and resources required to reconcile, deliver and manage the large volumes of data to and from the data warehouse will be minimised.

Join the newsletter!


Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.

More about Australian Pharmaceutical IndustriesAustralian Pharmaceutical IndustriesInformaticaNewmanSpeedTeradata Australia

Show Comments