Data warehousing will provide the foundation for applications such as CRM and e-business as they are deployed in organisations over the next 12 months. "The last thing implementers of these applications want is to have to worry about the integrity, reliability and movement of production data into their data warehouses," says Robyn Miller, Sterling Commerce product manager at Datacentrix company Supported Software.
In line with its position as the infrastructure optimising company, Supported Software is addressing the issue of reliable, safe and secure data movement in the data warehousing market through Sterling Commerce`s CONNECT:Direct.
"CONNECT:Direct addresses many of the issues related to data movement in the data warehousing market," says Miller, "and has gone into production in various data warehousing implementations around the world, including South Africa."
Data warehousing success depends on the reliable movement of data between operational databases and the data warehouse itself, says Miller. "There are such issues as application integrity, security and automated scheduling of data transfer to be considered."
CONNECT:Direct`s traditional strength is the movement of large amounts of data between heterogeneous environments. This has positioned it for deployment in the data warehousing market, which benefits from the intelligent, reliable, automated movement of large volumes of data.
"This means data can be quickly used and organisations can get rapid results from their data warehouse." CONNECT:Direct`s value-added benefits include:
Application integrity: It integrates seamlessly with existing operations supporting data warehousing-specific applications, across platforms from mainframes to midrange LANs and Unix systems. "This is important in today`s heterogeneous environments," says Miller, "where source databases and target operational databases typically cover a multitude of platforms."
Automation: Organisations can be sure they are retrieving the latest data due to CONNECT:Direct`s scheduling features and 24x7 unattended operations. It can be scheduled on a one-time, recurring or continuous basis, and it simplifies system administration through automation and scripting facilities.
Security and auditability: A choice of security enables administrators to control access to data, network and resources by individual users or classification of users.
Reliability: CONNECT:Direct provides a reliable data movement foundation through error handling, notification and recovery capabilities so the user or application knows immediately if a data transfer is interrupted. Checkpoint restart capabilities recover work in progress and resume the transmission from the point of failure rather than the beginning of the file.
Efficiency and performance: Direct file-to-file transfer means no staging, spooling or manual intervention, which reduces transfer time and production cycles.
Share
