Questions tagged [informatica]

Informatica is a software provider that specializes in integration middle-ware platforms. This tag will generally refer to the integration product that is most frequently used to connect Salesforce to other systems, Informatica-Cloud, a cloud based integration middle-ware software as a service.

Filter by
Sorted by
Tagged with
0 votes
1 answer
33 views

400 Bad request for concurrent 10 sessions hitting REST API from Informatica

I have an Informatica integration workflow processing around 200 or 100 records each session for 10 sessions concurrently to REST API (Salesforce). It first authorizes using connected app details (...
user avatar
  • 9
0 votes
1 answer
159 views

Informatica job failing with UNABLE_TO_LOCK_ROW:unable to obtain exclusive access to this record or 1 records: 001

Our Contact model is Private and there is a relationship with the Account object but it is a Lookup and NOT Master-Detail. We also have a custom setting which makes sure that not Triggers are running ...
user avatar
  • 191
1 vote
1 answer
93 views

not able to migrate knowledge articles

I am trying to migrate Knowledge Article from source salesforce to destination salesforce environment. Source salesforce environment is classic while the destination is lightning. In order to start ...
user avatar
  • 197
0 votes
1 answer
732 views

Running into below at informatica error when running informatica jobs. AT salesforce end login history shows success [closed]

Error - Severity Timestamp Node Thread Message Code Message ERROR 7/1/2020 7:20:23 PM node02_xxxxx READER_2_1_1 JAVA PLUGIN_1762 [ERROR] com.informatica.powercenter.sdk.SDKException:...
user avatar
0 votes
1 answer
141 views

How to run upsert in salesforce using firstname + lastname + email [closed]

I am using salesforce object as target in Informatica. The source is a csv file. I want to run upsert function in salesforce with a matching criteria Firstname + Lastname + Email. Right now I have ...
user avatar
0 votes
1 answer
152 views

Does the Informatica Cloud connector for Marketing Cloud exist?

We have Informatica cloud in our organisation as well as Salesforce Marketing Cloud. I have seen several articles referencing a Marketing Cloud connector in Informatica but cannot find any such ...
user avatar
-2 votes
1 answer
342 views

Informatica data update. Must have Id mapped

So we pull data from SAP quotes/sales and push it into a custom object in SFDC. How we reference the records in SFDC to the ones in SAP is via the SAP sales doc #. In fact when you view this is ...
user avatar
0 votes
1 answer
373 views

Query request size

I have a problem with data extraction with informatica from Salesforce. Sometimes it happens that the record extraction is limited to 2000 even if Query request size is set to higher values. This ...
user avatar
0 votes
1 answer
114 views

SOQL cross object query to call externally

I need some help creating a SOQL query or confirmation that it cannot be done. The requirements are as follows: Custom Object 1 has a relation to Cases. Custom Object 2 has a relation to Cases. ...
user avatar
1 vote
0 answers
209 views

How to grab failed Informatica Cloud Insert/Update into SFDC?

There is a insert/update into SFDC using informatica cloud.Informatica reads a queue and if there is any item in queue it updates/inserts into the SFDC. I have created a Log Object in SFDC to record ...
user avatar
0 votes
1 answer
955 views

Salesforce integration using Informatica [closed]

I want to use a salesforce report as my source and import it into a SQL server database. But I assume, we cant use reports as our source in Informatica cloud. If I use Saved Query as my source, would ...
user avatar
0 votes
1 answer
64 views

How to migrate Opportunity Team Members Records?

I want to migrate Opty team members using Informatica cloud. I did mapping but when i ran the job it is not updating OpportunityAccessLevel accurately. It updates with Read access although from source ...
user avatar
1 vote
1 answer
244 views

How to create datasets in Wave - Need to load datasets from Informatica Cloud

I am new to Wave Analytics. I am trying loading datasets from relational database using Informatica Cloud. Do I need to create datasets in Wave before loading data from Informatica Cloud. If yes, ...
user avatar
0 votes
1 answer
187 views

API setup Considerations with Informatica - Sandbox Refresh

I am trying to set up an API based integration b/w SFDC and Informatica on my Sandbox. What considerations do I have to keep in mind about Sandbox refresh? e.g. If the sandbox gets refreshed, does ...
user avatar
0 votes
1 answer
1k views

Integrating Salesforce with Informatica Cloud

We are working on a POC on Salesforce-Informatica cloud REST API integration. Please let me know the process/step by step information on how to integrate Salesforce with Informatica Cloud REST API, ...
user avatar
  • 151
2 votes
0 answers
704 views

!= Operator Not getting the Data from External System-Teradata Using OData

I have the query on externla objects [select customer_name__c,complete_order_status__c from current_year_order_summary__x where complete_order_status__c != 'C' LIMIT 2000]; I am facing the error ...
user avatar
1 vote
6 answers
2k views

How to fix TLS1.0 issue while connecting from Informatica

We are getting below error while connecting from Informatica. What is the workaround to solve the problem? Did anyone face the issue. Error while calling web service operation: login, error was: [...
user avatar
1 vote
0 answers
858 views

Informatica data filter dealing with dates

I was trying to setup an informatica task which delete records older than 1 year, eventually came up with filter like Date != last_n_days:365 However this filter does not cater the count of extra ...
user avatar
  • 11
0 votes
1 answer
1k views

How to expose a CSV as a Webservice/odata for salesforce to show in lightning connect

We currently have a CSV file that is generated externally and this is is outside of salesforce, this is a master sheet and stored in a FTP and has details for all accounts together. We want to show ...
user avatar
1 vote
1 answer
73 views

Need to Upsert Data Using Tool Batch Wise

I have order and contact object which have lookup from order to contact...I have Excel sheet which has order as well as contact information in it..I need to insert or upsert this excel sheet which ...
user avatar
1 vote
1 answer
203 views

Salesforce and Informatica cloud dala loader not getting connected

I'm using Informatica Cloud data loader to export data from Salesforce to external csv file. I'm trying to make a connection with Salesforce but geting this error: "The login to Salesforce.com ...
user avatar
1 vote
4 answers
320 views

Poor Performing SOQL query

I have the below SOQL query which is performing poorly in my Informatica job: SELECT Job__c.Id , Job__c.Name , Job__c.Case__r.Id , Job__c.Case__r.Account.RecordTypeId , Job__c.Case__r.Account....
user avatar
0 votes
2 answers
153 views

INFORMATICA free version of data loader : Does it support bi-directional sync?

Using a Corporate Enterprise Licence, I don't have access to BULK or SOAP API but only to REST. It seems that the best way to do cost effective interfaces to external tables / files would be to use ...
user avatar
0 votes
2 answers
1k views

Data Replication/Integration for SFDC Formula Fields

Hoping someone can point me in the right direction! We have an integration stack/replication batch (Informatica) that copies all of our data from SFDC. The change data capture process is based off of ...
user avatar
2 votes
1 answer
430 views

how do we load huge attachments to salesforce content

i am looking to load multiple huge video files (100MB x 10) in separate files into the content object in salesforce. I intend to load the files into a particular library which is already existing. ...
user avatar
1 vote
1 answer
483 views

How to user a .CSV column in WHERE CONDITION

Is there any free tool like Informatica cloud or something where I can put a ID column of CSV file in WHERE Condition. Scenario. I have csv file having ID of 10k Accounts. Now, I have to query the ...
user avatar
  • 2,767
3 votes
1 answer
77 views

Permissions for API calls

I need to do regular extractions from a Salesforce org where I'm not an Admin via Informatica. To do those calls, what privilages will I need? Do I don't think they want to make a sys admin.
user avatar
8 votes
1 answer
576 views

Salesforce Informatica Acknowledge

I am trying to use Informatica Cloud's integration with Salesforce with the help of outbound messages. How do I get the acknowledgement of the success or the error from Informatica and use it for ...
user avatar
3 votes
2 answers
1k views

General Questions/Points to be considered during Data Migration Process

With the advent of enterprise level platform that Salesforce now provides, Data Migration and Integration now plays crucial scope role in any of Salesforce implementation. I want to know what are the ...
user avatar
3 votes
2 answers
98 views

Informatica wants me to re-install because of old version, but no newer version available

I opened today the Informatica Data Loader (Free) tab, and wanted to sync some data. But then I got this message: You have an older version of the Informatica Data Loader Service managed ...
user avatar
4 votes
1 answer
2k views

Delay from Salesforce.com in querying records, Informatica

We are trying to insert records into salesforce org through informatica Batch Size = 200 no of records of records inserted 4000 to 50,000 Informatica process shows that insertion is completed. ...
user avatar