spacer.gif
Home
spacer.gif
spacer.gif
spacer.gif
Data Transfer Tool
Overview
System Requirements
spacer.gif
spacer.gif Data Transfer Tool
spacer.gif
spacer.gif spacer.gif

 

Overview

This tool supports the efficient and parallel transfer of large data sets from a ZLE Data Store to an analytical server for analysis in SAS Enterprise Miner. The tool, provides an intuitive and convenient web browser interface for transferring a table from a ZLE Data Store directly into a SAS data set on an analytical server.


 

Data Transfer Tool provides following features:

  • Ability to transfer the data on various flavors of UNIX and Windows
    platform
  • Ability to specify the format in which the data is transferred a.k.a. the
    ASCII file (delimited or CSV, Fixed Width Format), the SAS dataset
  • Ability to Schedule the execution and monitor of an actual data transfer
  • Ability to verify that sufficient disk space exists on the destination
    machine before the transfer begins
  • Ability to preview the first n (e.g. 100) rows
  • Ability to compress the data before transferring over the network
  • Ability to detect errors using check sum, to assure that the data was
    transferred successfully without errors.

System Requirements

The system and software requirements for each of the four components of the Data Transfer Tool are described below.

Client Workstation

  • Internet Explorer 5.5 (or higher).

The tool should work with other browsers as well, though, since the web server component returns only HTML to a client browser for display. In other words, no browser support for JavaScript or anything other than HTML is required.


Web Server

  • Operating System: Windows NT/2000, HP Tru64 Unix
  • Web Server: Apache Tomcat, Version 4.0 or higher on Windows platforms and 1.1 or higher on Tru64 platforms
  • Java Runtime Environment: Version 1.4.0 or higher

This layer could run on the Mining Mart server itself. This is not a necessity. The Web Server accesses the ZDS using JDBC. If the Web server resides on Windows NT/2000, it accesses ZDS using JDBC ODBC (Type 1) driver, if the Web Server resides on Alpha-Tru64, it accesses the ZDS using JDBC Type 3 driver.

Mining Mart

  • Operating System: Windows NT/2000, HP Tru64 Unix.

 

HP NonStop™ Server

  • NonStop™ SQL/MX version 1.5 or higher

JDBC/MX server (needed only when a Tru64 web server platform is used)
NonStop™ Himalaya system, on which a NonStop™ SQL/MX ZLE ZDS resides. The servers on the Himalaya system communicate with the Servers residing on the Mining Mart (handling Transfer functionality) using TCP/IP.


spacer.gif