Jump to content

Informatica

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by 72.37.244.132 (talk) at 18:37, 19 August 2015. The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.
INFORMATICA
Company typePrivate
Industry Software industry
Headquarters
Redwood City, California
,
United States
Area served
Worldwide
ProductsData Integration, Data Quality, Master Data Management, Information Lifecycle Management, Cloud
Revenue$948 million(2013) [1]
Number of employees
5500+
Websitehttp://www.informatica.com

Informatica Corporation is a software development company founded in 1993. It is headquartered in Redwood City, California.[2] It was founded by Zohaib Abbassi. Anil Chakravarthy is the company's CEO.[2]

History

The company was founded in 1993. It went public on NASDAQ Stock Exchange under the stock symbol INFA on April 29, 1999.

On April 7, 2015, Permira and Canada Pension Plan Investment Board announced that a company controlled by the Permira funds and CPPIB has signed a definitive agreement to acquire Informatica for approximately US$5.3 billion.[3]

On August 6, 2015, Informatica announced completion of acquisition with Microsoft and Salesforce Ventures joined as strategic investors. The company's stock ceased trading on the NASDAQ under the ticker symbol INFA effective on the same date.[4] [5][6]

Products

Informatica's product is a portfolio focused on Data Integration: ETL, Information Lifecycle Management, B2B Data Exchange, Cloud Data Integration, Complex Event Processing, Data Masking, Data Quality, Data Replication, Data Virtualization, Master Data Management, Ultra Messaging; currently at version 9.6 [2] These components form a toolset for establishing and maintaining enterprise-wide data warehouses. It has a customer base of over 5,000 companies.[2][7]

In 2006, Informatica launched its Informatica Cloud business.[8]

In 2010, the Informatica Marketplace was launched offering a data integration eco-system for Partners, Customers, Developers and Informatica to share and leverage data integration solutions.[9] As of Sept 2014, it features over 1,300 pre-built mappings, templates, connectors and add-ons for Informatica data integration and cloud data integration products.[10]

Architecture

Informatica ETL product, known as Informatica Power Center consists of 3 main components.

1. Informatica PowerCenter Client Tools: These are the development tools installed at developer end. These tools enable a developer to

Define transformation process, known as mapping. (Designer) Define run-time properties for a mapping, known as sessions (Workflow Manager) Monitor execution of sessions (Workflow Monitor) Manage repository, useful for administrators (Repository Manager) Report Metadata (Metadata Reporter)

2. Informatica PowerCenter Repository: Repository is the heart of Informatica tools. Repository is a kind of data inventory where all the data related to mappings, sources, targets etc. is kept. This is the place where all the metadata for your application is stored. All the client tools and Informatica Server fetch data from Repository. Informatica client and server without repository is same as a PC without memory/hard disk, which has got the ability to process data but has no data to process. This can be treated as backend of Informatica.

3. Informatica PowerCenter Server: Server is the place, where all the executions take place. Server makes physical connections to sources/ targets, fetches data, applies the transformations mentioned in the mapping and loads the data in the target system.

Types of transformations

  • Active : One that can change the number of rows being output.
  • Passive : One that cannot change the number of rows being output.
  • Connected : One that has at least one link with other transformations or objects in a mapping
  • Unconnected : One that does not have any link with any transformations or objects in a mapping

Also, Active transformation are recognised by any of the following three factors:

  • the transformation changes the row type
  • the transformation changes the row order
  • transaction control happens in the transformation

A transformation which has these properties is said to be an "active transformation", otherwise it is said to be a "passive transformation".

Examples:

  • Source qualifier - converts source datatypes to Informatica datatypes; joins two source tables or files of the same type
  • Expression - transforms data with functions without affecting cardinality or data order
  • Lookups - enhances data elements with lookup values; may be connected or unconnected
  • Filter - filters incoming data
  • Router - routes data to selected output paths
  • Sorter - sorts data and optionally removes duplicate rows
  • Aggregator - aggregates data
  • Joiner - joins relational data midstream; can be used when source data is of multiple types
  • Normalizer - used with flat file input containing arrays or repeated data to create normal form relational data
  • Update Strategy - determines whether data is to be updated, inserted or deleted in cases where there are multiple output targets
  • Transaction Control - creates transactions and controls commits and rollbacks
  • Sequence Generator - generates a sequence of unique values as per the specified parameters
  • Java transformation - invokes Java methods, variables, third-party API's and built-in packages

Financial results

Informatica headquarters in Redwood City
2013 2012 2011 2010 2009
Revenue (USD) [11] 948,171,000 811,571,000 783,779,000 650,076,000 500,693,000
Net Income (USD) [12] 86,400,000 93,180,000 117,500,000 86,320,000 64,210,000

Informatica has mainly seen growth through a combination of organic growth and growth through acquisition.[7][13]

References

  1. ^ Seeking Alpha, Seeking Alpha, retrieved 23 January 2014
  2. ^ a b c d Informatica, Informatica website, retrieved 15 May 2010
  3. ^ "Informatica Announces Agreement to be Acquired by The Permira Funds and Canada Pension Plan Investment Board". permira.com. Retrieved 7 April 2015.
  4. ^ "Informatica Corporation Announces Completion of Acquisition by the Permira Funds and Canada Pension Plan Investment Board". informatica.com. Retrieved 7 August 2015.
  5. ^ "Salesforce Ventures and Microsoft Join Informatica Buyout". nytimes.com. Retrieved 7 August 2015.
  6. ^ "Microsoft And Salesforce Join In $5.3 Billion Buyout Of Informatica". forbes.com. Retrieved 7 August 2015.
  7. ^ a b Magic Quadrant for Data Integration Tools, Gartner, 25 November 2009, retrieved 15 May 2010
  8. ^ Adrian, Merv (10 June 2010), Informatica Re-Factors the Value Chain for the Cloud, IT Market Strategy, retrieved 7 July 2010
  9. ^ "Informatica Marketplace-Press Release". Informatica. 9 February 2010.
  10. ^ "Informatica Marketplace - Home". marketplace.informatica.com. Retrieved 17 September 2014.
  11. ^ http://www.nasdaq.com/symbol/infa/revenue-eps
  12. ^ http://www.wikinvest.com/stock/Informatica_(INFA)/Data/Net_Income
  13. ^ Karel, Rob (28 January 2010), Introducing The MDM Market’s Newest 800lb Gorilla: Informatica Acquires Siperian!, Forrester, retrieved 15 May 2010
Wikimedia Commons has media related to Informatica Corporation.

Retrieved from "https://en.wikipedia.org/w/index.php?title=Informatica&oldid=676877404"