la salesforce.com user group: shopzilla and informatica cloud
DESCRIPTION
PresentTRANSCRIPT
1
Informatica Cloud
Los Angeles User Group
November 9th, 2011
2
• Informatica Cloud Overview
• Shopzilla Customer Success Story
• Q & A
Agenda
www.informaticacloud.com
3
Enterprise Companies Trust Informatica
• 2010 Revenue: $650 million
• 5-year Average Growth Rate:20% per year
• Employees: 2,125+
• Partners: 400+• Major SI, ISV, OEM and
On-Demand Leaders
• Customers: 4,280+• 84 of Fortune 100
• 87%+ of Dow Jones
• Government Organizations in20 countries
• # 1 in Customer Loyalty Rankings (5 Years in a Row)
$150
$200
$250
$300
$350
$400
$450
$500
$550
$600
$650
2005 2006 2007 2008 2009 2010
4
#1 by Customer Count #1 by Data Processed
AppExchange
Industry Leader in Cloud Integration
#1 by Connectivity
Informatica Cloud Marketplace
1,500+ companies 20B+ transactions/month
#1 by Customers/Analysts
5
Primary Cloud Integration Use Cases:
Load Data Synchronize Data Replicate DataCleanse Data
…without data integration, cloud-based systems won’t provide the value you’re seeking, indeed they may not be cost
effective at all.”
“
6
Informatica Cloud
True SaaS Solution
Proven Customer Success
www.InformaticaCloud.com
Kendall Collins, CMO
“Informatica’s focus on customer success and innovative technology has earned
them the top spot for data integration on the AppExchange.
”
Integration Simplicity
7
Pricing and Functionality that Scales for a Small Division or Large IT Organization
8
Informatica Cloud Mobile: Data Integration-on-the-Go!
• Released at Dreamforce ’11• Monitor Informatica Cloud usage
• Check the status of and troubleshoot data integration tasks
• Schedule and re-schedule data integration tasks as well as access Informatica Support
• Free on iTunes App Store
9
Contacts
• Carlos Clavel – Corporate Sales Manager• [email protected]• Phone # 650.385.5474• 888.345.4639
www.informaticacloud.com
10
Informatica Cloud Customer Success
DataSynchronization
Data Loader
DataReplication
DataQuality
DataSynchronization
DataQuality
Synchronizing Salesforce CRM with Oracle ERP
and other business apps
1.5M rows of data synchronized
daily
Consolidated SmithBarney and Morgan Stanley data on day one
of merger: No disruption
Managers didn’t lose momentum
in ongoing recruiting efforts
Decreased operational
issues from 70 percent to 30 percent of IT
workload
Enabled faster, more accurate
decision-making based on timely,
trusted data
Reduced time needed to
process and submit provider directories from 14 days to five
(64% reduction)
Enhancedcustomer sat and
optimized business process, efficiency
LOB accomplished
75% of what they needed in a day
Reduced time to information for
sales team from weeks to seconds
Now takes minutes a day
to process enrollment data
(use to take weeks)
SalesManagement can now make hiring and deployment decisions based
on accurate membership data
11
Agenda
• Informatica Cloud Overview
• Shopzilla Customer Success Story
• Q & A
www.informaticacloud.com
12
• A premier portfolio of online shopping brands in the US and Europe, consisting of Bizrate, Beso, Shopzilla, TaDa, PrixMoinsCher, and SparDeinGeld
• Connects shoppers with over 100 million products from tens of thousands of retailers with its unique portfolio of engaging and informative websites
• Reaches a global audience of over 40 million shoppers each month through both the destination websites and affiliate network
• A leading source of sales and consumer feedback for online merchants and retail advertisers
• With offices in Los Angeles, San Diego, and London, the company operates sites and business services in the United States, the United Kingdom, France and Germany
About Shopzilla, Inc.
13
Considerations When Choosing a Solution
• Are there any requirements on the Oracle schema? • How are relationships between objects handled? • How are changes to Oracle tables detected? • How are errors handled? • What happens if the synchronization app goes down, but the
other systems are still running? How are the missing updates discovered and reconciled?
• Can synchronization jobs be grouped?• What is the user interface like?• many more...
14
Why Informatica Cloud?
• Initial trial showed it could do the job• Informatica Cloud UI makes it easy for a user to get up to
speed and get something working• Mapping is done by dragging and dropping columns
from one table to another• Transformations reminiscent of spreadsheet formulas
• It's possible to copy an existing job and edit it• Built-in migration from Dev to QA to Production (without an
IDE)
www.informaticacloud.com
15
Challenges/Lessons Learned (1)
Rounding Errors in Large NumbersOracle: 123 456 789 012 345 678Salesforce: 123,456,789,012,345,696
Oracle: 12 345 678 901 234 567Salesforce: 12,345,678,901,234,570
Oracle: 1 234 567 890 123 456Salesforce: 1,234,567,890,123,456
• Informatica converts all numbers to floating point with 15 digits of precision, even if they’re integers
16
Challenges/Lessons Learned (2)
Trailing Zeros in Smaller NumbersOracle: 5067Salesforce: 5067.000000000000000
• Informatica converts all numbers to floating point before converting them to text
• Workaround for both: convert numbers to text using Oracle's to_char() function
17
Challenges/Lessons Learned (3)
Oracle Views vs. Informatica Transformations•Informatica can do simple joins on the fly, but it can’t do more complicated joins
• In one Oracle view the underlying query now contains 3 left outer joins and a CASE statement
• Another view concatenates multiple values in order to create a unique external identifier for Salesforce
•to_char() calls need to be in Oracle•rule of thumb: Oracle view per Salesforce object
Informatica Log Files Rollover•rolls over after 10 log files, which for us is 10 hours•using Rsync-Incr for automated archiving
18
Results
Business users can create custom reports and do analysis in their preferred environment
• show value of individual user over time• identify users who return to site more often
Uploaded 11 million accounts • Informatica worked fine• Salesforce did not scale
• Reports constantly timing out• SOQL queries always timed out if they had any
where clause, frequently even without a where clause
Deleted 10 million accounts – better now
19
Results (2)
In Production 24/7 since 11/22/10• had a problem with tasks getting stuck in Feb and
again in April 2011• promised that Summer 2011 release would fix it, and
apparently it did• however Summer 2011 release also took away
schedule blackout settings feature
Informatica gets the blame• problems with bad data getting into Oracle• problems with Salesforce going down
BUT it is actually quite reliable…
20
Agenda
• Informatica Cloud Overview
• Shopzilla Customer Success Story
• Q & A
www.informaticacloud.com
Rony Sawdyi, VP of EngineeringSteve Corwin, Lead Software EngineerCarlos Clavel, Manager, Corporate Sales
Free 30 Day Trial
21