Back to all announcements

Swiss Private Bankers Deploys Sunopsis to Help Process 30 Million Records for its Data Warehouse

12 June 2006

Lombard Odier Darier Hentsch & Cie, one of the largest house of private bankers in Europe, has implemented Sunopsis Data Conductor to help it integrate data into its data warehouse.

Mark Ali, Technologies and Banking Infrastructure Project Leader at Lombard Odier Darier Hentsch, commented: “Sunopsis Data Conductor brings us tremendous flexibility for developing and maintaining all loading flows because it allows us to separate the definition of business rules from the technical definition of the data flows.”

The solution’s business rules driven approach allows for a functional oriented definition of the data movement and transformation rules. The flow models, defined separately, are then applied to these business rules to generate the data flows. These models, defined as Knowledge Modules in Sunopsis Data Conductor, are entirely customizable.

“Beside data movements, a number of additional calculations and integration rules need to be applied,” comments Mark Ali. “Sunopsis Data Conductor generates native code for each of the databases in the information system, executing these transformations as close to the data as possible and fully leveraging available resources.” A major reason for the decision to choose Sunopsis is that is can connect natively to a wide variety of systems and to leverage them to execute integration processes.

Sunopsis’ flexibility was also an important advantage. Mark Ali explains: “Sunopsis Data Conductor’s ability to work in multiple environments allows us to manage the complexity of having multiple information sources for each business entity; it also greatly simplifies the deployment of these processes for additional business entities – which can be performed without editing a single line of code.”

Over 300 loading processes now run at Lombard Odier Darier Hentsch with some processing over 30 million records. “Sunopsis Data Conductor brings also an important added value in the production environment,” says Mark Ali. “Indeed, all execution results and potential errors are centralized in a single operator console, also available as a web interface. This global vision allows us to ensure the correct execution of all processes.”

Reflecting on the benefits of Sunopsis Data Conductor for Lombard Odier Darier Hentsch, Mark Ali concludes: “Thanks to the efficiency of Sunopsis Data Conductor, we can concentrate on our integration business rules and delegate the technical implementation to Sunopsis. This significantly reduces development times, allows us to deliver more quickly processes that are more optimized. Sunopsis Data Conductor is the cornerstone that underpins our data warehouse architecture.”