• How to use DB sequence while inserting a record in a Db Table

    We have a very common requirement. Insert a Record in an Oracle DB table. Table primary key is a DB Sequence. We did not find a way in ICRT to set the Primary key value using a DB Sequence.
    last modified by SANDEEP KUMAR
  • Help with reading SQS message body

    Hi, I am trying to implement an SQS Read Process on Cloud Application Integration. I configured the AwsSqsMonitor as the Event Source, and it is monitoring the Queue and successfully triggering my process when message...
    Ilya Soyfer
    last modified by Ilya Soyfer
  • Cannot Stop Informatica from Escaping Special Characters

    I'm attempting to call the MS Azure Cosmos API from Application Integration. I have had success connecting to Azure and querying the database. However, when I'm attempting to insert data into the Azure database, it is...
    Kevin Rexroad
    last modified by Kevin Rexroad
  • Adjust Timezone

    Hi, Can someone help me how to use fn:adjust timezone function.., I'm using as below,, but getting error.   fn:adjust-dateTime-to-timezone(xs:dateTime("$temp.tmpCurrentDate"), xs:dayTimeDuration("PT5H"))  ...
    Uma Maheswar
    last modified by Uma Maheswar
  • CAI - Salesforce to SAP and SAP to Salesforce via CAI-Process-Real time

    Hi Team,   I am new to Appliction Integration, and would like to check the connectivity of IICS-AI (Application Integration) with SAP on Real time basis.   We have a requirement where the Integration happe...
    Vishal Singh
    last modified by Vishal Singh
  • Use Informatica to pass Salesforce data into SQL server

    Hi all,   I'm a newbie to informatica and am familiar with connecting two salesforce orgs but very new to using it to connect Salesforce with SQL server.   The use case here is my company uses SQL server t...
    Jasiel Lora
    last modified by Jasiel Lora
  • Salesforce Outbound Message to IICS Cloud Application Integration not working

    Hi All,          I am triggering one Application Integration Service from Salesforce Outbound Messages this is not working as below. Step 01: I have set up my ICAI assets and publi...
    Umakanta Swain
    last modified by Umakanta Swain
  • Trigger CAI Process via Salesforce OBM

    We are trying to create a ICRT process that would be triggered via Salesforce Outbound Message. We've already set the 'Applies To' property to our Salesforce Connection and the specific Salesforce Object. But it doesn...
    Amiel Dimaculangan
    last modified by Amiel Dimaculangan
  • Recieve Case details in Salesforce

    Hi All,   We are looking for an option in Application Integration in which we can get Case details from Saleforce.   any help would be appreciated.   Thanks Keerthi
    keerthi parvathi
    last modified by keerthi parvathi
  • Salesforce to servicenow integration

    Hi All,   We have a requirement to integrate salesforce to servicenow. We cannot use the Synq connector for service now. Could someone guide me if it is better to develop a process in  Application integrati...
    Ravi Teja Kalaga
    last modified by Ravi Teja Kalaga
  • Real-Time application integration with Cvent

    This video shows a demonstration of two-way real-time application integration between Cvent and Salesforce:  https://youtu.be/XT_a1WVwFwc   The demonstration shows how a change in Location for an event in ...
    Eric Egertson
    last modified by Eric Egertson
  • Salesforce platform events integration with Informatica RealTime

    Hi,   I want to capture the Salesforce Platform Events with the Informatica RealTime Integration. Can anyone help me what is the procedure.     Thanks, Subbu
    Subrahmanya Gupta Yakkala
    last modified by Subrahmanya Gupta Yakkala
  • Salesforce PushTopics Event Triggering Process

    I'm attempting to follow this video, to simulate my own pushtopic event triggered Application Integration job, but nothing seems to kick off the event when I check the processes in Application Integration Console....
    Aaron Mattern
    last modified by Aaron Mattern
  • Move local file through Application Integration Process

    Hello all-   I am working on a complicated task that requires me to perform action once two files enter a folder on our Secure Agent server. One file is a CSV file and another is its associated metadatafile (TXT...
    Thomas Righele
    last modified by Thomas Righele
  • Sample Process: Salesforce Account, Contact, Case to JSON & XML

    Hi Cloud Application Integration Fans and Followers,   I wanted to share a Process Solution that demonstrated a few great techniques for data access and manipulation in a single use case.  This doesn't use ...
    Casey Clayton
    last modified by Casey Clayton
  • Retrieve Request from Salesforce Outbound Message

    Hello-   I have created a process in which we generated for an Informatica Outbound message.   We are looking to obtain the user information that triggered the Outbound message. The only way I believe we c...
    Thomas Righele
    last modified by Thomas Righele
  • Cloud Application Integration and SQS

    I am looking to implement ICRT to trigger based on an incoming Amazon SQS message.   I've been able to add an AwsSqsMonitor to the connection and it triggers when a message is put on the SQS queue however we...
    Kenneth Rice
    last modified by Kenneth Rice
  • How to get connection id using rest api.

    Hi, I'm trying to update the password of data integration using rest api. can some one help me how can i get the id of specific connection by using rest api. i'm using "/api/v2/connection" url for getting the detai...
    pereddy seshaseyanareddy
    last modified by pereddy seshaseyanareddy
  • Process Schedules - not saved

    I created a very basic Process in the Application Integration module, specified it to be available on a single secure agent and now want to get it scheduled. I'm able to select my process and set the schedule, but whe...
    Simon Roggeman
    last modified by Simon Roggeman
  • XSLT transformations on ICRT cloud agent

    Is there a way to run a XSLT against an XML on the ICRT cloud agent?   I have a process object that we created as an output of a process. The process object converts to XML as expected. However, the XML does no...