Oct. 19, 2009 (PR Newswire) --

WOODCLIFF LAKE, N.J., Oct. 19 /PRNewswire/ -- Syncsort, a global leader in high-performance data processing, data integration and data protection and recovery software, today announced that Overstock.com® (Nasdaq: OSTK) has selected Syncsort DMExpress to extract, transform and load data from its clickstream platform to a Teradata enterprise data warehouse. The solution proves easy to deploy and maintain, is scalable to Overstock.com's current environment, and is faster and more efficient than hand-coding in supporting actionable analytics.

(Logo: http://www.newscom.com/cgi-bin/prnh/20000922/SYNCSORTLOGO )

Overstock.com is a leading on-line retailer of high-quality, low-cost goods. Without a brick and mortar presence, the company relies on quickly making 30 GB of daily clickstream data available for analysis by brand and category managers. This analysis supports strategies for marketing spend, offerings, pricing, and campaigns aimed at increasing website traffic. The process previously involved using lengthy, complex, custom coding to move data from the web analytics platform into a data warehouse powered by Teradata. The code, used for parsing, manipulation, and cleansing of data prior to loading, was time-consuming to maintain.

"We need an environment that supports agile development and rapid delivery of information," says Sam Peterson, SVP Technology at Overstock.com. "Time to deployment and the ability to do file-based processing was important to us. DMExpress was fast and efficient."

Eliminating the need to maintain hundreds of lines of code, DMExpress now pulls the clickstream data files, performs complex transformations - including parsing and cleansing of URLs, reassembling records, parsing of files, and pattern matching - and hands the data over to the Teradata load utility. By reducing dependence of highly-specialized coding expertise, DMExpress enables developers of any skill level to easily develop, modify, maintain, and reuse complex transformations.

Before choosing Syncsort, Overstock.com participated in a Syncsort Proof-of-Concept (PoC) using production size clickstream data files and hosted on servers within the Overstock environment. "We were very impressed with the quality of Syncsort's pre-sales service engineers and the success and format of the PoC," says Peterson. "We were also impressed by Syncsort's history in file-based processing and the strength of its references."

"Like many of our customers expecting growth in data volumes in 2010 and beyond, Overstock.com is driven by clickstream analytics," says Harvey Tessler, Senior Vice President, Marketing at Syncsort.