Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

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
1answer
48 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
1answer
158 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 ...
0
votes
1answer
107 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 ...
0
votes
1answer
77 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. ...
1
vote
0answers
151 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 ...
0
votes
1answer
723 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
1answer
38 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 ...
1
vote
1answer
221 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
1answer
146 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
1answer
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, ...
2
votes
0answers
283 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 ...
1
vote
6answers
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
0answers
728 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
1answer
873 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
67 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
187 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
213 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
2answers
131 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
2answers
938 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
343 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
398 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
70 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.
8
votes
1answer
533 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 ...
3
votes
2answers
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 ...
3
votes
2answers
89 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
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. ...