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.
31
questions
0
votes
1
answer
881
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 (...
- 9
0
votes
1
answer
418
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 ...
- 301
1
vote
1
answer
264
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 ...
- 235
0
votes
1
answer
1k
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:...
- 43
0
votes
1
answer
358
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 ...
- 61
0
votes
1
answer
241
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 ...
-2
votes
1
answer
449
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 ...
- 1
0
votes
1
answer
762
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 ...
- 129
0
votes
1
answer
126
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.
...
- 353
1
vote
0
answers
228
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 ...
- 73
0
votes
1
answer
1k
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 ...
0
votes
1
answer
82
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 ...
- 155
1
vote
1
answer
247
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, ...
0
votes
1
answer
224
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 ...
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, ...
- 161
2
votes
0
answers
783
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 ...
- 95
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:
[...
1
vote
0
answers
988
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 ...
- 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 ...
- 1,762
1
vote
1
answer
74
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 ...
1
vote
1
answer
208
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 ...
- 11
1
vote
4
answers
397
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....
0
votes
2
answers
174
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 ...
0
votes
1
answer
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 ...
2
votes
1
answer
511
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.
...
- 1,762
1
vote
1
answer
547
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 ...
- 2,827
3
votes
1
answer
157
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.
- 10.5k
9
votes
1
answer
597
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 ...
- 835
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 ...
- 767
3
votes
2
answers
101
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 ...
- 825
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. ...
- 5,692