-
Manage your Success Plans and Engagements, gain key insights into your implementation journey, and collaborate with your CSMsSuccessAccelerate your Purchase to Value engaging with Informatica Architects for Customer SuccessAll your Engagements at one place
-
A collaborative platform to connect and grow with like-minded Informaticans across the globeCommunitiesConnect and collaborate with Informatica experts and championsHave a question? Start a Discussion and get immediate answers you are looking forCustomer-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
-
Troubleshooting documents, product guides, how to videos, best practices, and moreKnowledge CenterOne-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and moreVideo channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much moreInformation library of the latest product documentsBest practices and use cases from the Implementation team
-
Rich resources to help you leverage full capabilities of our productsLearnRole-based training programs for the best ROIGet certified on Informatica products. Free, Foundation, or ProfessionalFree and unlimited modules based on your expertise level and journeySelf-guided, intuitive experience platform for outcome-focused product capabilities and use cases
-
Library of content to help you leverage the best of Informatica productsResourcesMost popular webinars on product architecture, best practices, and moreProduct Availability Matrix statements of Informatica productsMonthly support newsletterInformatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description ScheduleEnd of Life statements of Informatica products
How to call stored procedure using Data Access Service Connector in CAI
Share On:
Overview
The Data Access Service (DAS) Connector in Informatica's Cloud Application Integration (CAI) provides a straightforward way to execute stored procedures on databases such as Oracle and SQL Server. It allows users to define actions, set up SQL bindings, and test outputs for processes such as data manipulation and procedure invocation. With the DAS connector, users now have the capability to execute Stored Procedures.
Pre-Requisites
- Knowledge on CAI process design and DAS Connector design
- Knowledge of SQL queries and Stored Procedures
Self-Service Resources
Goals
Create a DAS that can execute stored procedure and return output fields
Executing Stored Procedure from DAS in CAI
Outcome
- Return output fields from Stored Procedure through DAS
- Integrate CAI with databases to execute Stored Procedures
- Architect/Administrator
- Developer
Actions
Add to Favorites
Remove from Favorites
Engagement Details
Catalog Type
Ask An Expert
Engagement Category
Feature Clarity
Products
Cloud Application Integration
Engagement Type
Ask An Expert
Adoption Stage
Implement
Focus Area
Adoption - Technical
Functional
Engagement ID
AAE-CAI-023
Disclaimer
- All the topics covered in the Success Accelerators/Ask An Expert sessions are intended for guidance and advisory only. This is implicit and it will not be called out under the scope of each engagement.
- Customers need to include their relevant technical/business team members highlighted in each engagement topic to derive the best out of each engagement.
- Customers need to perform any hands-on work by themselves leveraging the guidance from these engagements.
- Customers need to work with Informatica Global Customer Support for any product bugs/issues and troubleshooting.