Showing posts with label SOA. Show all posts
Showing posts with label SOA. Show all posts

Tuesday, March 6, 2012

Breaking News—Informatica Launches Version 9 of its Data Integration Platform

0 comments
Informatica today announced version 9 of its data integration platform with the theme of "Enabling the Data-Driven Enterprise." The Informatica platform is a comprehensive offering that provides for enterprise data integration, cloud data integration, B2B data exchange, and data quality across the whole enterprise. Major new features in version 9 of the platform focus on the areas of SOA-based data services, pervasive data quality, and Business-IT collaboration.
Arvind Parthasarathi, vice president of product management for Informatica, tells 5 Minute Briefing that "the key elements of building a data-driven enterprise are the ability to provide relevant, trustworthy, and timely data to the organization. Informatica 9 enables all three of these through the feature areas of business-IT collaboration, data quality, and multi-modal data provisioning services. Features in version 9 that enable Business-IT collaboration include the ability to provide users with views into their data based on the way they are used to seeing it. This allows business users to participate in the entire process of getting the data they want. Data quality is provided via capabilities such as highly accurate global matching and address cleansing with domain aware pre-built rules and reference data.
Regarding multi-modal data provisioning services, Parthasarathi continued by saying "we provide the right data to users at the right time based on their business needs. The right data means data in its most relevant form for its intended use including various data types and data technologies. The right time can vary according to the amount of data latency any given business process can tolerate and Informatica offers numerous data delivery styles and technologies in a sliding-scale fashion to meet all various needs. This includes batch ETL, real-time change data capture, and federated query capabilities."
According to Informatica, version 9 is the single most important release in the company's history, and is a comprehensive solution for solving the challenges of managing data across the enterprise. With Informatica 9, companies can lower the costs and time to discover data and deliver it the way it is needed. They can also identify the bad data that is impacting business decisions and fix it faster. This is facilitated by Informatica's support for all data domains and all applications across all geographies. Lastly, version 9 enables the control and management of data wherever it is located, whether that be on-premise, in the cloud, with partner networks or any combination of these.
newer post

Sunday, January 8, 2012

Informatica ETL products

0 comments
Informatica PowerCenter is an enterprise data integration platform working as a unit. With its high availability as well as being fully scalable and high-performing, PowerCenter provides the foundation for all major data integration projects and initiatives throughout the enterprise.



    These areas include:
    B2B exchange
    data governance
    data migration
    data warehousing
    data replication and synchronization
    Integration Competency Centers (ICC)
    Master Data Management (MDM)
    Service-oriented architectures (SOA) and more.

PowerCenter provides reliable solutions to the IT management, global IT teams, developers and business analysts as it delivers not only data that can be trusted and guarantees to meet analytical and operational requirements of the business, but also offers support to various data integration projects and collaboration between the business and IT across the globe.

Informatica PowerCenter enables access to almost any data sources from one platform. It is possible thanks to the technologies of Informatica PowerExchange and PowerCenter Options.

PowerCenter is able to deliver data on demand of the business offering the choice of data access of real-time, batch or change data capture (CDC).

Informatica PowerCenter is capable of managing the broadest range of data integration initiatives as a single platform. This ETL tool makes it possible to simplify the development of data warehouses and data marts.

Supported by PowerCenter Options, Informatica PowerCenter software meets enterprise expectations and requirements for security, scalability and collaboration through such capabilities as:

    dynamic partitioning
    high availability/seamless recovery
    metadata management
    data masking
    grid computing support and many more


In order to increase operational efficiency and to manage and execute various initiatives, the platform enhances successful collaboration between the business and IT.

Informatica ETL products

PowerCenter has an offer of a wide range of features designed for global IT teams and production administrators, as well as for individual developers and professionals:

    - Metadata Manager (consolidates metadata into a unified integration catalog)
    - development capabilities (team-based; accelerate development, simplify administration)
    - a set of visual tools and productivity tools (manages administration and collaboration between different specialists)
    - metadata-driven architecture (eliminates the recoding requirement).

    The Informatica ETL (Informatica PowerCenter) product comprises three major applications:
    Informatica PowerCenter Client Tools. These tools have been designed to enable a developer to:
    - report metadata
    - manage repository
    - monitor sessions' execution
    - define mapping and run-time properties (sessions)
    Informatica PowerCenter Repository - it is the centre of Informatica tools where all data (eg. related to mapping or sources/targets) is stored. Here all metadata for application is kept. All the client tools as well as Informatica Server use the Repository to obtain data. The Repository can be compared to a harddisk or memory in a PC - without it it is possible to process the data but there is virtually no data that can be processed.
    Informatica PowerCenter Server - server is the place where all the actions are executed. It physically connects to sources and targets to fetch the data, apply all transformations and load the data into target systems.
newer post

Tuesday, January 11, 2011

ETL Architectures – Concepts and Implementation

0 comments
ETL Architectures is an in-depth, technical course that teaches the concepts for designing and implementing the appropriate architectures to use in managing the extraction, transformation and loading (ETL) of data for:

    High performance decision support environments (data warehouses, dimensional data marts, Operational Data Stores (ODS), etc)
    Master Data Management hubs (Customer Data Integration (CDI), Product Information Management (PIM), etc)
    General data integration (e.g. Service Oriented Architectures (SOA))

This course will review these architectures and concepts with the primary focus on the concepts and techniques that apply to various approaches to ETL. Participants will learn when to use certain techniques, based on their technical and business requirements. With hands-on workshops, attendees will study different ETL products and methodologies for implementation in today’s heterogeneous system environments.
Benefits To Your Company

By learning the best way to design ETL architectures, architects and ETL developers will be able to implement the appropriate tools and techniques to satisfy business requirements and relate them to the supporting data structures. They will:

    Understand the concepts of extraction, transformation and loading in decision support systems, master data management systems, SOA environments.
    Understand the various forms of data architectures and how to apply ETL techniques to these
    Understand sophisticated techniques for more complicated ETL solutions (real-time, high volume, etc)
    Construct ETL architectures that are flexible to support changing business and technical requirements
    Learn about the most common ETL products and their strengths and weaknesses.

Who Should Attend

    Data Warehouse Architects
    Enterprise Architects (Data, Technical)
    ETL Developers
    Data Architects
    Business Intelligence designers
    Database designers
    Database administrators (DBA)

What Makes This Certified Course Unique

This ICCP-certified course provides participants with practical, in-depth understanding of how to create appropriate ETL architectures for decision support and data integration solutions. Hands-on workshops throughout the course will reinforce the learning experience and provide the attendees with concrete results that can be utilized in their organizations.
Course Outline

    Review common system architectures
        Transaction Processing
        Decision Support
        Master Data Management
        Service Oriented Architecture
    ETL Concepts
        General principles
        Design and plan for reuse
        Design for error handling
        Design for performance
        Design for maintainability
        ETL Standards
        ETL and Meta Data
        ETL Tool Usage
    ETL for Decision Support
        ETL for the Data Warehouse
            Data Sourcing / Changed Data Capture
            Data Transport
            Data Staging
            Changed Data Determination
            Loading normalized warehouse structures
        ETL for the Data Mart
            Surrogate key lookup and assignment
            Slowly Changing Dimensions - Types 1,2, 3 & 6
            Denormalization and impact on ETL
            Populating “junk” dimensions using a Cartesian product
            Aggregation
        ETL for the ODS
            Real/near time approaches
            Data Modeling differences
        Row level security
        Closing the loop
    ETL for Master Data Management (MDM) and Service Oriented Architectures (SOA)
        Customer Data Integration (CDI)
        Product Information Management (PIM)
        Integrating ETL and SOA environments
        Integrating ETL with Data Quality tools
        Integration with OLTP systems
    ETL Tools
        Leading ETL tool vendors
        ETL tool strengths / weaknesses
        Choosing the correct ETL tool
    High performance ETL
        Indexing (b-tree, bitmap, join indexes, etc)
        Forms of Parallelism
        RDBMS tuning and ETL
        Massively Parallel Processing (MPP) platforms vs. Symmetrical Multiprocessing (SMP) platforms
        ETL query optimization
    Workshop conclusion
        Summary, additional exercises, sources for further reading, etc.

SOURCE:http://www.ewsolutions.com/education/data-warehouse-training/document.2008-04-23.8274387713
newer post
older post Home