Enbridge Inc, one of the world`s leading energy companies and the operator of the world`s longest crude oil and liquids pipeline system, has chosen Ascential Software`s DataStage XE/390 as the foundation of its enterprise data warehouses.
DataStage is the industry`s leading data integration solution for mainframe and client-server environments. "Ascential gives us a comprehensive, integrated solution to extract, transform and load data in an efficient and flexible manner," says Paul Dalglish, VP, Enbridge Commercial Services. "DataStage XE/390 helps us put our finger on the pulse of our customers` needs and preferences, which allows us to serve them better and enhance our efficiency."
The Ascential solution supports Enbridge Commercial Services` highly distributed and mixed Unix and mainframe environment and provides user-accessible business intelligence for Enbridge Consumers Gas, Canada`s largest natural gas distributor, and Enbridge Home Services, a retail energy services company.
DataStage XE/390, which Enbridge Commercial Services implemented in September, transforms and loads DB2-, Oracle- and Adabas-based customer and billing usage files from IBM mainframes and Unix servers into two separate Oracle-based HP-Unix data warehouses.
Using a single development interface to manage its mainframe and Unix data sources, the IT group builds graphical jobs that extract data from the mainframe using Cobol code and from Oracle using Oracle`s native interface. Other DataStage jobs then transform and load the data into Oracle-based warehouses on HP-Unix.
"Mainframe systems continue to be a vital source of customer information for enterprise data warehouse and CRM systems," says Julian Field, GM Ascential Software South Africa. "As companies strive to enhance their 360-degree understanding of their businesses and customers, it is critical to integrate mainframe data with other enterprise systems, including CRM, ERP and e-business applications. Enbridge`s decision to use DataStage XE/390 strongly reflects this reality."
Share
Enbridge Commercial Services is a subsidiary of Enbridge Inc, which is a leader in energy transportation, distribution and services in North America and internationally. As a distributor of energy, Enbridge owns and operates Canada`s largest natural gas distribution company and distributes gas to more than 1.5 million customers in Ontario, Quebec, New Brunswick and New York State. Enbridge is also involved in international investments, the distribution of electricity, and retail energy products and services.
Editorial contacts