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.

learn more… | top users | synonyms

0
votes
6answers
98 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
0answers
46 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 ...
0
votes
0answers
63 views

Updated Value from Informatica Cloud Sync Task not available during execution of after update Trigger

I have an "after update" trigger that will look at certain fields in the Contact object and perform some task based on the value of those fields. The trigger fires, but it doesn't perform its task ...
0
votes
1answer
169 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
vote
1answer
40 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
1answer
97 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 ...
1
vote
4answers
105 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
1answer
450 views

Best practices for integrating salesforce with an oracle database using power center

We have a client who uses an oracle database and uses informatica power center. We have to create back end jobs using power center and integrate them with salesforce. 1.Do you guys have any best ...
0
votes
2answers
65 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
1answer
388 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
1answer
220 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
vote
1answer
136 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 ...
3
votes
1answer
49 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.
7
votes
1answer
359 views

Salesforce Informatica Acknowledge

I am new to integration in Salesforce, I am trying to use Informatica Cloud for integration with Salesforce with the help of the outbound messages. How do I get the acknowledgement of the success or ...
3
votes
2answers
852 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 ...
3
votes
2answers
76 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 ...
4
votes
1answer
1k 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. ...