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
0answers
21 views

Error running Salesforce 'Data Assessment' jobs on the Informatica Cloud

I'm using a trial of the Informatica Cloud to run a 'Data Assessment' job on my Salesforce instance. I set up a standard job, but every time I get the following run error: [DTM_10004] The DTM ...
0
votes
0answers
8 views

CRMworkstation (Flat Files) to Salesforce Live to Sandbox. How To?

I've currently been tasked with taking flat files that currently are moved into Salesforce (Live) via Informatica Cloud. I would like to know how to thoroughly take flat files into salesforce live via ...
1
vote
1answer
28 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
47 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 , ...
0
votes
0answers
27 views

delete rows from a non-primary key field table using informatica cloud

I want to delete certain records from a salesforce object and the object doesnot have primary key associated with it. when trying delete operation through informatica cloud I'm getting cannot perform ...
0
votes
0answers
87 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
37 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
93 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 ...
0
votes
0answers
28 views

Informatica on demand loading jpeg in attachment

I have a custom object Call2_vod__c which is detail to Account. It has a Signature_vod__c field that is in encoded base64 format. Now for one Account, I can create an attachment from any of the ...
2
votes
1answer
123 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
87 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
39 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.
6
votes
1answer
259 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
676 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
72 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
950 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. ...