Cloud Data Integration : 2013 : August Skip navigation
2013

Our fourth Informatica Cloud #TechTuesdays session, "Benefits of Using REST APIs in Integration", focused on the specific resources that Informatica Cloud's REST API provides, and the various scenarios in which they can be used. We first went over the most common kinds of requests (such as GET, POST, PUT, DELETE) that REST calls make, and then gave an overview of the resources that the Informatica Cloud REST API provides. These resources can be broadly grouped into the following categories:

  • Activities
  • Secure Agent Details
  • Jobs
  • Logins
  • Integration Templates
  • Workflow Details
  • Schedules

 

When using Informatica Cloud's REST API, it is very important to know what the header configuration looks like, and also to use only Version 2 of the REST API. The demo showcased the following scenarios:

 

  • Embedding integration into a SaaS Application
  • Job scheduling & monitoring
  • Administering new users

 

Here are the slides and entire recording featuring Amol Dongre from our Cloud Engineering team. Tomorrow's session will focus on using SOAP web services within Informatica Cloud.

Our third Informatica Cloud #TechTuesdays session, "Simplifying SAP Connectivity with Cloud Integration", focused on how cloud applications were rapidly gaining traction, especially in the CRM space, and needed to connect to SAP R/3 to access crucial customer, pricing, and product master data. The reason why integration to SAP is so important is because over 25% of ERP deployments in 2012 were based upon SAP (Souce: Forbes, Gartner).

 

http://b-i.forbesimg.com/louiscolumbus/files/2013/05/ERP-Market-Share-2012-Stats.jpg

 

Although SAP only grew 2.2% from 2011 to 2012 while other cloud-based  ERP vendors such as Workday, and NetSuite grew 114.7% and 34%  respectively over the same period, the fact remains that as a category,  SAP still holds the lions share of the ERP market. Coupled with the fact  that CRM is one of the fastest growing categories of cloud  applications, it's not hard to see why integration between cloud CRM  applications (such as Salesforce and Microsoft Dynamics CRM Online ) and  SAP is such a sought-after solution.We discussed three primary use  cases for SAP integration: data warehousing, data migration, and data  synchronization. Some of the most exciting features of Informatica  Cloud's

SAP connector that were shown on the demo was the ability to toggle between the  technical and business names in R/3, and how easy it was to extract data  from transparent, clustered, and pooled tables and views. The demo  zeroed in on the following themes:

 

  • Loading SAP customer info into Salesforce
  • Bulk extraction from clustered tables to flat files
  • Using Salesforce outbound messaging
  • Performing lookups

 

Here are the slides from the session, and the entire recording featuring Anand Peri, who takes care of product management for our SAP connector.

 

Session 4, which focused on using the Informatica Cloud REST API for integration just got over this morning and we'll have the slides and recordings up soon.

Our second Informatica Cloud #TechTuesdays session, "Accelerating Big Data Initiatives through Cloud Integration", shone a light upon the growing use of Big Data for datawarehousing projects. We cleared the confusion around many of the flavors of Big Data out there, such as Hadoop, and focused the discussion on Big Data providers in the cloud, such as Amazon RedShift.

 

Big Data has several use cases such as data warehousing, predictive analytics, machine data, and OLTP, and we decided to tackle the data warehousing use case. When looking at the industries that had the fastest adoption of Big Data, we found out, not suprisingly, that the banking, media, and government industry verticals led the way (Source: Forbes, Gartner).

 

http://blogs-images.forbes.com/louiscolumbus/files/2012/08/big-data-heat-map-by-industry.jpg

 

During the session, we discussed that the main drivers behind moving to cloud-based Big Data for data warehousing projects was because of the speed with which you could provision multiple database nodes. Other benefits involved saving on costs of provisioning multiple on-premise databases, as well as the ability to start petabyte-scale data warehousing projects a lot sooner. The demo itself touched on the following aspects of using Amazon RedShift:

 

  • Configuring RedShift for first-time use by downloading SQL Workbench
  • Ensuring that security groups were set up correctly
  • Writing to Amazon RedShift using the Informatica Cloud connector
  • Reading from Amazon RedShift using ODBC

 

Here are the slides from the session, and the entire recording featuring Vijay Narayanan, who takes care of product management for a lot of our new connectors.

 

Session 3, which focused on SAP integration just got over this morning and we'll have the slides and recordings up soon.