• Success
    Manage your Success Plans and Engagements, gain key insights into your implementation journey, and collaborate with your CSMs
    Success
    Success Accelerators
    Accelerate your Purchase to Value engaging with Informatica Architects for Customer Success
    My Engagements
    All your Engagements at one place
  • Communities
    A collaborative platform to connect and grow with like-minded Informaticans across the globe
    Communities
    Product Communities
    Connect and collaborate with Informatica experts and champions
    Discussions
    Have a question? Start a Discussion and get immediate answers you are looking for
    User Groups
    Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
    Get Started
    Community Guidelines
  • Knowledge Center
    Troubleshooting documents, product guides, how to videos, best practices, and more
    Knowledge Center
    Knowledge Base
    One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
    Support TV
    Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
    Documentation
    Information library of the latest product documents
    Velocity (Best Practices)
    Best practices and use cases from the Implementation team
  • Learn
    Rich resources to help you leverage full capabilities of our products
    Learn
    Trainings
    Role-based training programs for the best ROI
    Certifications
    Get certified on Informatica products. Free, Foundation, or Professional
    Product Learning Paths
    Free and unlimited modules based on your expertise level and journey
    Experience Lounge
    Self-guided, intuitive experience platform for outcome-focused product capabilities and use cases
  • Resources
    Library of content to help you leverage the best of Informatica products
    Resources
    Tech Tuesdays Webinars
    Most popular webinars on product architecture, best practices, and more
    Product Availability Matrix
    Product Availability Matrix statements of Informatica products
    SupportFlash
    Monthly support newsletter
    Support Documents
    Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
    Product Lifecycle
    End of Life statements of Informatica products
    Ideas
    Events
    Change Request Tracking
    Marketplace
| Sign up
Videos → Support Videos → 30 Minute API Tutorial : Real Time Data from MS SQL, Salesforce, and a JSON/REST Web Service
28:28
990 Views | 27 Nov 2019
Add to Favorites
Remove from Favorites

30 Minute API Tutorial : Real Time Data from MS SQL, Salesforce, and a JSON/REST Web Service

Cloud Application Integration Enablement English

In this tutorial Casey Clayton creates a REST Web Service process that accepts a Vehicle Identification Number (VIN) and returns vechicle data for use in a customer service portal. As you'll see the process actually comprises of data aggregated from a a number of data services called in real-time.

Informatica Cloud Application Integration provides a code-free solution for creating and publishing API's, and also orchestrating real-time service-oriented process. The cloud-based process designer allows data architects and business subject matter experts to create working real-time integrations around almost any business or application event.

Application Integration

Informatica Support 97/145
SumItUp with Sumeet: Informatica iPaaS Innovation Update, Q3 2024
playIcon
26:54

SumItUp with Sumeet: Informatica iPaaS Innovation Update, Q3 2024
The Five "E" Vision of Informatica iPaaS
playIcon
01:11

The Five "E" Vision of Informatica iPaaS
Real-Time API and Event-Based Integration in Cloud Application Integration
playIcon
06:54

Real-Time API and Event-Based Integration in Cloud Application Integration
Integrating Kafka, Salesforce, and AWS Redshift using Cloud Application Integration
playIcon
08:53

Integrating Kafka, Salesforce, and AWS Redshift using Cloud Application Integration
Cloud Application Integration: Guide Designer Overview
playIcon
12:31

Cloud Application Integration: Guide Designer Overview
Operational Insights for Cloud Application Integration
playIcon
11:43

Operational Insights for Cloud Application Integration
How to Integrate Cloud Application Integration Process as a Webhook in Twilio
playIcon
09:58

How to Integrate Cloud Application Integration Process as a Webhook in Twilio
HOW TO: Invoke a Stored Procedure using Informatica Cloud Application Integration (formerly ICRT)
playIcon
23:49

HOW TO: Invoke a Stored Procedure using Informatica Cloud Application Integration (formerly ICRT)
How to Consume an Outbound Message from a Primary Salesforce Org in CAI
playIcon
03:11

How to Consume an Outbound Message from a Primary Salesforce Org in CAI
How to queue/dequeue using AMQP using Cloud Application Integration
playIcon
09:46

How to queue/dequeue using AMQP using Cloud Application Integration
Error Logs: Cloud Application Integration
playIcon
10:37

Error Logs: Cloud Application Integration
ICRT Managed Package Installation, Configuration and Uninstallation for Salesforce
playIcon
05:38

ICRT Managed Package Installation, Configuration and Uninstallation for Salesforce
How to create SQS Connection in Informatica Cloud Real Time (ICRT)
playIcon
07:51

How to create SQS Connection in Informatica Cloud Real Time (ICRT)
Corvisa Services Discuss How They Use Informatica Cloud Extend for Salesforce
playIcon
16:58

Corvisa Services Discuss How They Use Informatica Cloud Extend for Salesforce
How to Loop Paginate in Application Integration
playIcon
07:58

How to Loop Paginate in Application Integration
Salesforce Quick Start - Part 1: Set Up and Publish your First Salesforce App Connection
playIcon
13:17

Salesforce Quick Start - Part 1: Set Up and Publish your First Salesforce App Connection
POC 1, Part 3: Executing Processes and the Process Console
playIcon
12:43

POC 1, Part 3: Executing Processes and the Process Console
Using API Manager in Informatica Intelligent Cloud Services
playIcon
06:34

Using API Manager in Informatica Intelligent Cloud Services
Two Minutes Overview of the Informatica API Manager
playIcon
02:02

Two Minutes Overview of the Informatica API Manager
Disabling Access to Cloud Endpoint URLs in OData-Enabled JDBC Connections
playIcon
05:41

Disabling Access to Cloud Endpoint URLs in OData-Enabled JDBC Connections
Using the FTP/SFTP Connector for Cloud Application Integration
playIcon
27:33

Using the FTP/SFTP Connector for Cloud Application Integration
Integrating and Automating Processes in Informatica Cloud Application Integration
playIcon
08:28

Integrating and Automating Processes in Informatica Cloud Application Integration
How to create Service Connectors using a swagger service definition in Cloud Application Integration
playIcon
13:57

How to create Service Connectors using a swagger service definition in Cloud Application Integration
Demo 3: Informatica iPaas
playIcon
03:30

Demo 3: Informatica iPaas
Consuming CAI APIs as Apigee Extensions new
playIcon
03:24

Consuming CAI APIs as Apigee Extensions new
How to connect to ActiveMQ using AMQP connector in Cloud Application Integration
playIcon
09:00

How to connect to ActiveMQ using AMQP connector in Cloud Application Integration
Document Approvals in Salesforce Using Informatica Cloud Extend
playIcon
06:21

Document Approvals in Salesforce Using Informatica Cloud Extend
Informatica Cloud Application Integration and Cloud Integration Hub Combined Use Cases
playIcon
07:39

Informatica Cloud Application Integration and Cloud Integration Hub Combined Use Cases
Design time update to Eric Egertson’s “Process and Guides: Interactive Access to Data” Demonstration
playIcon
09:17

Design time update to Eric Egertson’s “Process and Guides: Interactive Access to Data” Demonstration
Informatica Cloud Extend vs Salesforce Visual Flow
playIcon
23:17

Informatica Cloud Extend vs Salesforce Visual Flow
Improving Salesforce Lead Qualification With Informatica Cloud Extend
playIcon
05:10

Improving Salesforce Lead Qualification With Informatica Cloud Extend
How to Define Unit Tests for a Cloud Application Integration Process
playIcon
11:07

How to Define Unit Tests for a Cloud Application Integration Process
Process Designer for Salesforce - Cloud Extend
playIcon
09:06

Process Designer for Salesforce - Cloud Extend
Using a Salesforce Connector to Publish and Subscribe to Salesforce Platform Events
playIcon
08:12

Using a Salesforce Connector to Publish and Subscribe to Salesforce Platform Events
Member Enrollment Service using AllScripts EHR, Salesforce and DocuSign
playIcon
11:47

Member Enrollment Service using AllScripts EHR, Salesforce and DocuSign
Cloud Application Integration: Using Email Connection in a Process
playIcon
07:37

Cloud Application Integration: Using Email Connection in a Process
Using a Kafka Connector to Read and Write Kafka Messages in Application Integration
playIcon
05:43

Using a Kafka Connector to Read and Write Kafka Messages in Application Integration
Demo 1: Informatica iPaas
playIcon
04:32

Demo 1: Informatica iPaas
Streamline Your Meeting Follow Up with Informatica Cloud Extend for Salesforce
playIcon
05:12

Streamline Your Meeting Follow Up with Informatica Cloud Extend for Salesforce
How to Setup Salesforce Platform Events
playIcon
09:44

How to Setup Salesforce Platform Events
Creating a Kafka Connection in Cloud Application Integration
playIcon
09:09

Creating a Kafka Connection in Cloud Application Integration
Fetching HTTP Request Headers in Cloud Application Integration Process
playIcon
07:34

Fetching HTTP Request Headers in Cloud Application Integration Process
Symmetric Key Digital Signature Processing for AWS
playIcon
10:58

Symmetric Key Digital Signature Processing for AWS
How to correlate/call process using Cloud Application Integration
playIcon
02:41

How to correlate/call process using Cloud Application Integration
Using property “Rollback on Error” in Messaging Service
playIcon
11:12

Using property “Rollback on Error” in Messaging Service
API Management and Discovery: Working with API
playIcon
02:57

API Management and Discovery: Working with API
How To: Create a Process for CRUD Operations Using JDBC
playIcon
12:17

How To: Create a Process for CRUD Operations Using JDBC
Composite Vehicle Service: Create Composite Web Service combining Real-time Data
playIcon
41:08

Composite Vehicle Service: Create Composite Web Service combining Real-time Data
How to Create and Run a Simple Guide
playIcon
07:12

How to Create and Run a Simple Guide
How to do errorHandling in Informatica Cloud Real Time
playIcon
24:37

How to do errorHandling in Informatica Cloud Real Time
How to Perform Load Balancing in Cloud Application Integration
playIcon
06:42

How to Perform Load Balancing in Cloud Application Integration
API-driven Order Processing
playIcon
08:46

API-driven Order Processing
Using Informatica Cloud Extend to Work Through a List of Salesforce Leads
playIcon
03:44

Using Informatica Cloud Extend to Work Through a List of Salesforce Leads
Creating a New Salesforce Case With Informatica Cloud Extend
playIcon
02:22

Creating a New Salesforce Case With Informatica Cloud Extend
Validate video title with ellipsis - Generating a Swagger Endpoint URL for an OData-Enabled JDBC Connection in Application Integration
playIcon
06:01

Validate video title with ellipsis - Generating a Swagger Endpoint URL for an OData-Enabled JDBC Connection in Application Integration
ICRT Docusign
playIcon
32:21

ICRT Docusign
OAuth2 Authentication for Cloud Application Integration Processes
playIcon
08:26

OAuth2 Authentication for Cloud Application Integration Processes
How to Automate Image Sensing using Cloud Application Integration
playIcon
12:44

How to Automate Image Sensing using Cloud Application Integration
Asymmetric Key Digital Signature Processing for Google JWT
playIcon
32:57

Asymmetric Key Digital Signature Processing for Google JWT
Introduction to Guides
playIcon
04:47

Introduction to Guides
Advancing Salesforce Opportunities More Efficiently With Informatica Cloud Extend
playIcon
02:43

Advancing Salesforce Opportunities More Efficiently With Informatica Cloud Extend
How to Restart a Cloud Application Integration Process from Process Listing Page
playIcon
05:53

How to Restart a Cloud Application Integration Process from Process Listing Page
Cloud Application Integration Error Handling - Pattern 1
playIcon
01:46

Cloud Application Integration Error Handling - Pattern 1
POC Overview for Cloud Application Integration
playIcon
19:32

POC Overview for Cloud Application Integration
Publishing CAI APIs to Apigee
playIcon
04:24

Publishing CAI APIs to Apigee
Database Table migration from one database to another using Cloud Application Integration
playIcon
16:47

Database Table migration from one database to another using Cloud Application Integration
Cloud Application Integration - Messaging Services [Queueing / De-queueing]
playIcon
04:58

Cloud Application Integration - Messaging Services [Queueing / De-queueing]
How to Execute Custom Java Code in CAI
playIcon
10:31

How to Execute Custom Java Code in CAI
Salesforce Webinar: Mobilizing Salesforce Processes for the Smartphone Generation
playIcon
53:48

Salesforce Webinar: Mobilizing Salesforce Processes for the Smartphone Generation
Building, Exposing and Monitoring Services and Process and Data APIs
playIcon
10:46

Building, Exposing and Monitoring Services and Process and Data APIs
Cloud Application Integration: Process Designer Overview
playIcon
23:20

Cloud Application Integration: Process Designer Overview
Cloud Application Integration - Automotive Services [List Processing]
playIcon
15:09

Cloud Application Integration - Automotive Services [List Processing]
Using API Manager in Informatica Intelligent Cloud Services
playIcon
05:59

Using API Manager in Informatica Intelligent Cloud Services
Creating and Managing APIs with Informatica Intelligent Cloud Services
playIcon
08:15

Creating and Managing APIs with Informatica Intelligent Cloud Services
Suspend on Fault and Process Exception Management
playIcon
21:50

Suspend on Fault and Process Exception Management
What is New in Cloud Application Integration 1H 2020 releases
playIcon
01:00:01

What is New in Cloud Application Integration 1H 2020 releases
Learning Resources for API and Application Integration
playIcon
04:45

Learning Resources for API and Application Integration
Pagination Support in OData enabled JDBC connection in Informatica Cloud Application Integration
playIcon
09:57

Pagination Support in OData enabled JDBC connection in Informatica Cloud Application Integration
Preparing Effective Sales Meetings Using Informatica Cloud Extend
playIcon
07:41

Preparing Effective Sales Meetings Using Informatica Cloud Extend
Introducing the API and Application Integration Capabilities in IICS
playIcon
14:11

Introducing the API and Application Integration Capabilities in IICS
The Future of Salesforce Integration: From OData to OMG
playIcon
40:31

The Future of Salesforce Integration: From OData to OMG
Using a Service Connector to Retrieve Chatter Profile Photo
playIcon
16:55

Using a Service Connector to Retrieve Chatter Profile Photo
Sending HTML Formatted Email From Within Salesforce Using Informatica Cloud Extend
playIcon
04:26

Sending HTML Formatted Email From Within Salesforce Using Informatica Cloud Extend
Cloud Application Integration - Order Processing [Correlation]
playIcon
07:55

Cloud Application Integration - Order Processing [Correlation]
Cloud Application Integration: Handling Credential Failures
playIcon
03:31

Cloud Application Integration: Handling Credential Failures
Intro Video - Cloud Application Integration Guides
playIcon
06:15

Intro Video - Cloud Application Integration Guides
Consuming CAI APIs as Apigee Extensions
playIcon
03:24

Consuming CAI APIs as Apigee Extensions
Enhancements to Service Connector actions
playIcon
08:20

Enhancements to Service Connector actions
Integrating SAP data with Salesforce in Real-time
playIcon
19:43

Integrating SAP data with Salesforce in Real-time
Best Practices for Salesforce Process Automation Webinar
playIcon
55:30

Best Practices for Salesforce Process Automation Webinar
Bi-Directional Real Time Integration between WorkDay and ServiceNow
playIcon
14:38

Bi-Directional Real Time Integration between WorkDay and ServiceNow
JMS Capabilities
playIcon
18:56

JMS Capabilities
How to Create Process Objects by Importing Schema Definition from XSD/WSDL or Swagger
playIcon
10:54

How to Create Process Objects by Importing Schema Definition from XSD/WSDL or Swagger
How to create Service Connectors manually in Cloud Application Integration
playIcon
09:05

How to create Service Connectors manually in Cloud Application Integration
Define expressive and resource-based REST APIs using Cloud Application Integration Processes
playIcon
13:22

Define expressive and resource-based REST APIs using Cloud Application Integration Processes
HOW TO: Install and Configure Cloud Application Integration managed package on Salesforce
playIcon
07:03

HOW TO: Install and Configure Cloud Application Integration managed package on Salesforce
30 Minute API Tutorial : Real Time Data from MS SQL, Salesforce, and a JSON/REST Web Service
playIcon
28:28

30 Minute API Tutorial : Real Time Data from MS SQL, Salesforce, and a JSON/REST Web Service
How to Setup Delimited File Reader/Writer in Cloud Application Integration
playIcon
08:37

How to Setup Delimited File Reader/Writer in Cloud Application Integration
What is new in Informatica Cloud Extend Summer 13 for Salesforce
playIcon
21:22

What is new in Informatica Cloud Extend Summer 13 for Salesforce
SQL Invocation Through Data Access Service
playIcon
12:01

SQL Invocation Through Data Access Service
Introduction to IICS
playIcon
03:59

Introduction to IICS
Informatica Cloud & Salesforce Lightning Connect using OData
playIcon
29:05

Informatica Cloud & Salesforce Lightning Connect using OData
Salesforce Integration Examples - Salesforce to CVENT
playIcon
05:46

Salesforce Integration Examples - Salesforce to CVENT
RabbitMQ Connector Overview
playIcon
12:41

RabbitMQ Connector Overview
Updating a List of Salesforce Objects With Informatica Cloud Extend
playIcon
06:03

Updating a List of Salesforce Objects With Informatica Cloud Extend
Using API Manager in Informatica Intelligent Cloud Services
playIcon
04:51

Using API Manager in Informatica Intelligent Cloud Services
Cloud Application Integration: Using File Connection in a Process
playIcon
08:16

Cloud Application Integration: Using File Connection in a Process
How to Read File as Service using Application Integration
playIcon
06:43

How to Read File as Service using Application Integration
Informatica Cloud Application Integration Cvent Demonstration
playIcon
07:41

Informatica Cloud Application Integration Cvent Demonstration
Capturing real time events from Dynamics 365 using Cloud Application Integration
playIcon
14:52

Capturing real time events from Dynamics 365 using Cloud Application Integration
Cloud Application Integration - Leads Services (Marketo) Sample [Create Service Connector manually]
playIcon
15:55

Cloud Application Integration - Leads Services (Marketo) Sample [Create Service Connector manually]
Support for Salesforce Streaming API in Cloud Application Integration
playIcon
05:23

Support for Salesforce Streaming API in Cloud Application Integration
Creating Mobile Applications for Salesforce Using Informatica Cloud Extend
playIcon
04:17

Creating Mobile Applications for Salesforce Using Informatica Cloud Extend
Automate loan approval process with Application Integration and Human Task leveraging a ML model
playIcon
10:03

Automate loan approval process with Application Integration and Human Task leveraging a ML model
Intro Video - Cloud Application Integration Processes
playIcon
07:45

Intro Video - Cloud Application Integration Processes
Informatica Cloud Dreamforce 2014 Booth Demo - Long
playIcon
16:15

Informatica Cloud Dreamforce 2014 Booth Demo - Long
Overview of Informatica Integration Cloud for Apigee
playIcon
06:00

Overview of Informatica Integration Cloud for Apigee
Implementing Salesforce Call Scripting With Informatica Cloud Extend
playIcon
04:09

Implementing Salesforce Call Scripting With Informatica Cloud Extend
Demo 2: Informatica iPaas
playIcon
04:23

Demo 2: Informatica iPaas
File Listener and Reader/Writer
playIcon
22:47

File Listener and Reader/Writer
POC 1, Part 2: Running The Guide
playIcon
09:20

POC 1, Part 2: Running The Guide
Introduction to Application Integration and API Management Capabilities
playIcon
06:33

Introduction to Application Integration and API Management Capabilities
OData Provider's use with Salesforce Lightning Connect
playIcon
15:21

OData Provider's use with Salesforce Lightning Connect
Cloud Application Integration - Orchestration of ICS Tasks
playIcon
04:54

Cloud Application Integration - Orchestration of ICS Tasks
Cloud Application Integration - Account Invoice Processing [Create Service Connector using swagger]
playIcon
09:29

Cloud Application Integration - Account Invoice Processing [Create Service Connector using swagger]
POC 1, Part 4: Service Connectors
playIcon
23:15

POC 1, Part 4: Service Connectors
How to Create Mapping Tasks Automation in REST-API and CAI
playIcon
23:03

How to Create Mapping Tasks Automation in REST-API and CAI
HOW TO: Execute Java in Informatica Cloud Real Time
playIcon
05:50

HOW TO: Execute Java in Informatica Cloud Real Time
How to Create Process Schedules in CAI
playIcon
06:58

How to Create Process Schedules in CAI
Working with AMQP and Message Events
playIcon
22:59

Working with AMQP and Message Events
How to Configure IBM MQ Queue with Informatica Cloud Application Integration (ICAI)
playIcon
18:38

How to Configure IBM MQ Queue with Informatica Cloud Application Integration (ICAI)
API Center Limited Preview Demonstration
playIcon
27:20

API Center Limited Preview Demonstration
Human Task Usage in Cloud Application Integration
playIcon
09:02

Human Task Usage in Cloud Application Integration
What's New in Cloud Application Integration - April 2024
playIcon
01:28

What's New in Cloud Application Integration - April 2024
Integrating with Messaging Applications in Real Time in Cloud Application Integration
playIcon
04:05

Integrating with Messaging Applications in Real Time in Cloud Application Integration
How to Publish CAI Assets using Rest API
playIcon
05:42

How to Publish CAI Assets using Rest API
Salesforce Quick Start - Part 2: Sample Web Service Process API using your Salesforce App Connection
playIcon
16:08

Salesforce Quick Start - Part 2: Sample Web Service Process API using your Salesforce App Connection
OData Capabilities in Cloud Application Integration
playIcon
06:38

OData Capabilities in Cloud Application Integration
What's New in Cloud Application Integration - October 2023
playIcon
01:56

What's New in Cloud Application Integration - October 2023
What's New in Informatica Cloud Application Integration - October 2022
playIcon
01:00

What's New in Informatica Cloud Application Integration - October 2022
What's New in Informatica Cloud Application Integration - July 2022
playIcon
01:41

What's New in Informatica Cloud Application Integration - July 2022
Process Integration and Automation with Informatica Cloud Application Integration
playIcon
08:34

Process Integration and Automation with Informatica Cloud Application Integration
Real Time API and Event-Based Integration in Cloud Application Integration
playIcon
06:05

Real Time API and Event-Based Integration in Cloud Application Integration
What's New in Cloud Application Integration - April 2022
playIcon
01:08

What's New in Cloud Application Integration - April 2022
What's New in Cloud Application Integration - July 2023
playIcon
02:22

What's New in Cloud Application Integration - July 2023
Back To Top

Success

Link Copied to Clipboard