Saturday, 22 June 2013

DATASTAGE INTRODUCTION

  DATA STAGE
Data Stage is a powerful Extraction, Transformation, and Loading tool. Data Stage has the following features to aid the design and processing:
  • Uses graphical design tools. With simple point-and-click techniques you can draw a scheme to represent your processing requirements
  • Extracts data from any number or type of database
  • Handles all the metadata definitions required to define your data warehouse or migration. You can view and modify the table definitions at any point during the design of your application
  • Aggregates data. You can modify SQL SELECT statements used to extract data
  • Transforms data. Data Stage has a set of predefined transforms and functions you can use to convert your data. You can easily extend the functionality by defining your own transforms to use.
IBM WebSphere Data Stage TX delivers the ability to easily and seamlessly automate high-volume, complex transactions without the need for additional coding-resulting in a quick return on investment.
IBM WebSphere Data Stage TX 6.7 delivers rapid ROI through a highly scalable, open architecture.

IBM WebSphere Data Stage TX allows you to: >br /> Quickly and seamlessly integrate many of the most popular applications, databases, and messaging systems Respond quickly and with flexibility to rapidly evolving, strategic business requirements Leverage the value of your enterprise systems and applications Meet your project-based or full integration solution needs

IBM WebSphere Data Stage Features & Benefits
IBM WebSphere Data Stage provides these unique capabilities: The Most Powerful ETL Solution - Supports the collection, integration and transformation of high volumes of data, with data structures ranging from simple to highly complex. Data Stage manages data arriving in real-time as well as data received daily, weekly or monthly.

The Most Scalable Platform
Enables companies to solve large-scale business problems through high-performance processing of massive data volumes. By leveraging the parallel processing capabilities of multiprocessor hardware platforms, DataStage Enterprise Edition can scale to satisfy the demands of ever-growing data volumes and stringent real-time requirements and ever shrinking batch windows

The Most Comprehensive Source and Target Support
Supports a virtually unlimited number of heterogeneous data sources and targets in a single job, including: text files; complex data structures in XML; ERP systems such as SAP and PeopleSoft; almost any database (including partitioned databases); web services; and SAS.

Real-time Data Integration Support
Operates in real-time capturing messages from Message Oriented Middle ware (MOM) queues using JMS or WebSphere MQ adapters to seamlessly combine data into conforming operational and historical analysis perspectives. IBM WebSphere RTI Services is a service-oriented architecture (SOA) enabling middleware that brokers enterprise-wide the benefits of the Ascential Enterprise Integration Suite across a continuum of time constraints, application suites, interface protocols and integration technologies.

Advanced Maintenance and Development
Gives developers maximum speed, flexibility and effectiveness in building, deploying, updating and managing their data integration infrastructure. Full data integration reduces the development and maintenance cycle for data integration projects by simplifying administration and maximizing development resources.