Teradata and Informatica
Company - Australian Pharmaceutical Industries
API is one of Australia's leading providers of products and services
to branded and independent community pharmacies. It provides daily
distribution of products to pharmacies through its network of distribution
centers and regional branches throughout Australia.
"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,"
said Doug Horwood, manager of information management, API Pharmacy.
Business Requirement - improve API's ability to
react to changed circumstances and assist in monitoring performance
and profitability through aggregated data and improved reporting.
API implemented a Teradata EDW and Informatica's integration software
for information delivery to support its pharmaceutical wholesale
Enterprise Data Warehouse
API's new Enterprise Data Warehouse on a Teradata 550P server
with 2.1 terabytes of spinning disk. This configuration is designed
as an entry-level data warehouse server.
The Teradata 550P Server and Teradata Database offer a completely
integrated data warehouse solution with optimized system performance.
API chose the 550P server for its speed, simplicity and affordability,
making it the ideal investment for the growing logistical demands
of its pharmacy wholesale business.
Informatica provided the data integration platform utilizing PowerCenter
8 and PowerExchange to support all the data management for the Teradata
The new EDW will:
- Better support the ever-changing API business with better and
faster information delivery to business users.
- Significant improve the routine publishing of daily analytical
- Provide more ad hoc on-demand capability to the user community
The combination of technologies from Teradata and Informatica will
help improve our ability to react to changed circumstances and assist
us in monitoring performance and profitability through appropriately
aggregated data and improved reporting.
This case example demonstrates a common trend for corporations
to turn to data warehousing for competitive advantage. The link
between data management and successful data warehousing is becoming
Back To Top
The World's Leading Guide To BI Strategy, Program & Technology
Data Tools Index | MS
SQL Server 2008 | Informatica | Teradata
MDM | Teradata & Informatica
| Vendor Models | DW
Platform Requirements | Sybase PowerDesigner