How to connect to Sales Force (SFDC) From Informatica

In order to connect to Sales Force.com. Power Exchange SFDC  needs to be installed and  sfdc plug-in needs to be registered in Informatica Repository.Below are the steps for the same.


  1. Log on to server as Informatica functional account.
  2. Change directory to Informatica PowerCenter install binaries directory.
  3. Ftp/Sftp sfdc_81102_sol32.tar from either local workstation or Informatica server to server where install is taking place
  4. Decompress install binaries  (tar xvf sfdc_81102_sol32.tar).
  5. At this point, stop integration service and repository service in the environment using admin console.
  6. Execute installSFDCserver.
  7. Enter Informatica home directory absolute path ($INFA_HOME).
  8. Once installation has completed, return to admin console.
  9. Add license key to environment using admin console.
  10. Select the respective Unicode integration service, modify the HTTP Proxy Properties as follows: HttpProxyServer  ,HttpProxyPort , HttpProxyUser, HttpProxyPassword, HttpProxyDomain.










  • Start repository service.
  • Start integration service.
  • Log into repository using Workflow manager.
  • Validate that salesforce.com connection is now an option under application type connections in workflow manager.
  • Log into repository using Designer.
  • Validate that you can import a source from salesforce.com, and that it is now an option in source analyzer.
  • If both workflow manager and designer allow these options, installation is complete.

 Below Is the Installation Output :

$INFA_HOME/server/tomcat/bin/SFDC_81102_Sol32

Stop all the Powercenter processes/Services before running this script ....
Enter absolute path of Powercenter server installation directory{/home/powercenter8.1.1}
$INFA_HOME
server location:$INFA_HOME
backing up $INFA_HOMEserver/bin/native/pmsfdc.xml as $INFA_HOME/server/bin/native/pmsfdc.xml.bak
copying files to $INFA_HOMEserver/bin/native folder
backing up $INFA_HOMEserver/bin/libpmsfdccmn.so as $INFA_HOME/server/bin/libpmsfdccmn.so.bak
backing up $INFA_HOMEserver/bin/libpmsfdclkp.so as $INFA_HOME/server/bin/libpmsfdclkp.so.bak
backing up $INFA_HOMEserver/bin/libpmsfdcrdr.so as $INFA_HOME/server/bin/libpmsfdcrdr.so.bak
backing up $INFA_HOMEserver/bin/libpmsfdcwrt.so as $INFA_HOME/server/bin/libpmsfdcwrt.so.bak
backing up $INFA_HOMEserver/bin/pmsfdc_EN.cat as $INFA_HOME/server/bin/pmsfdc_EN.cat.bak
backing up $INFA_HOMEserver/bin/pmsfdc_JA.cat as $INFA_HOME/server/bin/pmsfdc_JA.cat.bak
copying files to $INFA_HOMEserver/bin folder
cp: server/bin/native: is a directory
Installation completed successfully.
IMPORTANT: If you are upgrading from 8.1.1 please re-register the Salesforce.com plug-in pmsfdc.xml for changes to take effect.
 
 Below are the steps to register the sfdc plugin to Repository :
  • Get the pmsfdc.xml from Informatica Vendor.
  • FTP the pmsfdc.xml file in binary mode and place it to Informatica server $INFA_HOME/server/bin/native/ path. (Make sure to FTP the sfdc plug in binary mode).
  • Bring down the Integration Service.
  • Bring the repository service to Exclusive mode from Normal mode. 
  • Connect to the repository using the pmrep connect command.
              pmrep>connect -r "LAB_INFA_REP" -d "LAB_INFA_DOMAIN" -n Administrator -x password
  • Now register the plugin using the registerplugin command.
             pmrep>registerplugin -i $INFA_HOME\server\bin\native\pmsfdc.xml -e -N 
(Note : Give the fully qualified path otherwise will get the above error Failed to execute registerplugin )

Register Plug-in operation on repository [LAB_INFA_REP] started at 07/10/2011 08:11:14.

Importing plugin: SalesforcePlugin ...
Importing dbtype: Salesforce ...
Importing keytype: SOURCEID ...
Importing keytype: TARGETID ...
Importing keytype: SOURCEREFERENCE ...
Importing keytype: TARGETREFERENCE ...
Importing datatype: id ...
Importing datatype: id ...
Importing datatype: id ...
Importing datatype: id ...
Importing datatype: id ...
Importing datatype: id ...
Importing datatype: id ...

Post validation on imported plug-ins...
The number of plug-ins that registered successfully is 1.
The number of plug-ins that failed to register is 0.
Register Plug-in operation on repository [
LAB_INFA_REP] ended at 07/10/2011 08:11:17. Elapsed time is 0:00:03.
registerplugin completed successfully.
pmrep>exit


Problem Description 1 :

Some time you might encounter the below error :

The following error occurs when creating a Salesforce.com (PowerCenter Connect for Salesforce.com 8.1.1.0.2) Source Definition in the PowerCenter Designer:  Attribute Name, SForceName, can not be found.

Solution :

 To resolve this error delete the Salesforce cache files (.sfdclogin.lck and .sfdclogin.txt) from the following location. 
$INFA_HOME/server/infa_shared/Temp 


Problem Description 2 :

 SFDC_31133 : [ERROR] Reattempt the Salesforce request [querymore] due to the error [EOF was observed that violates the protocol. The client probably provided invalid authentication information.]
 SFDC_31133 : [ERROR] Reattempt the Salesforce request [querymore] due to the error [Connection timed out.]
 SFDC_31133 : [ERROR] Reattempt the Salesforce request [querymore] due to the error [Connection timed out.]
 SFDC_31133 : [ERROR] Reattempt the Salesforce request [querymore] due to the error [Connection timed out.]
 SFDC_31133 : [ERROR] Reattempt the Salesforce request [querymore] due to the error [EOF was observed that violates the protocol. The client probably   provided invalid authentication information.]
 SFDC_31133 : [ERROR] Reattempt the Salesforce request [querymore] due to the error [Connection timed out.]
 SFDC_31133 : [ERROR] Reattempt the Salesforce request [querymore] due to the error [SSL_ERROR_SSL

INFA_Problem_Description

Attempting to import a Salesforce objects in the Designer the following error occurs: Login failed. Error code: [SOAP-ENV : Client] Reason : [No Data]

Cause :

This issue will occur if your network resides in a proxy and proxy information is not configured.

Solution :
         
To resolve this issue create the pmsfdc.ini file with the correct proxy server information. If the network resides in a proxy environment, the proxy information should be configured in pmsfdc.ini. Please follow the below steps: To configure HTTP proxy options for the PowerCenter Client, do the following:

   1. Create the pmsfdc.ini file in the <PowerCenter Client>\bin directory.
   2.  Add the following parameters:
          * ProxyHost
          * ProxyPort
          * ProxyUser
          * ProxyPassword

      Example

          ProxyHost=abc123.informatica.com
          ProxyPort=8082
          ProxyUser=admin
          ProxyPassword=password123

More Information :

To determine the proxy server setting refer to the LAN settings in Internet Explorer (Tools > Internet Options > Connections > LAN Settings > Proxy Server) and use that in the pmsfdc.ini file.
 

Problem Description 3 :


Following error occurred when importing a Salesforce.com object in the Power Center Designer, While user we were successfully able to connect to SFDC URL & able to login through Internet Explorer.

ERROR :

DescribeGlobal failed. Error code: [SOAP-ENV:Server] Reason: [HTTP error]


Solution :


This is due to the mismatch between the entries in pmsfdc.ini file on the client machine, proxy host server from IE should match proxy details in the pmsfdc.ini file. Bex you were able to connect from IE to salesforce, The proxy user & proxy password in pmsfdc.ini file have some vulnerability in connecting to proxy server, hence it’s not routing the request to sfdc server. In that case you need to ask the network access team saying whether the credentials are perfect or not.

68 comments:

  1. Hi Shiva,can you explain how to use tibo system as informatica source and target

    ReplyDelete
    Replies
    1. Great Article Cloud Computing Projects

      Networking Projects

      Final Year Projects for CSE

      JavaScript Training in Chennai

      JavaScript Training in Chennai

      The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

      Delete
  2. Hi Krishna

    I have never worked on tibco as a source and target system, I have worked on Sales Force, SAP, and Greenplum
    I too searching for the same.

    Many Thanks

    Shivakumar

    ReplyDelete
  3. Hi Siva,

    I am trying to connect to SFDC from informatica. I am getting the below error. Can you please help me get the issue.

    Message Code: SFDC_31101
    Message: [FATAL] Login failed. User [XXXsds@ddd.sds]. Fault code [SOAP-ENV:Server]. Reason [HTTP error].

    ReplyDelete
  4. Hi Ravi

    Please add the proxy server details in the pmsfdc.ini file.

    Many Thanks

    Shivakumar

    ReplyDelete
  5. hi shiva ,
    what is the below error, can you provide solution ?
    Message Code: SFDC_31103
    Message: [FATAL] Query More failed. User [xxxxxxx@xxx.com.test]. SOSQL

    Query Batch Index [2218]. Fault code [5]. Reason [SOAP Error : [Syntax Error]. Please Contact Informatica Customer support.].

    ReplyDelete
  6. Please re-import the sales force table, Suspecting the columns have exceeded the maximum number of columns that needs to be imported.

    Shiva

    ReplyDelete
  7. Hi Shivakamur,

    I am new to Informatica..

    Salesforce plugin was already registered and installed n the INFA admin console. Upon opening the designer and importing targets to Salesforce.com I cannot log in. The error says: Login failed. Error code: [SOAP-ENVI:client] Reason [Host not found].

    Can you help me fix this?
    Many thanks.

    ReplyDelete
  8. Dear one

    This is a known issue, I've already discussed about this issue above along with the solution, Plz change the proxy settings in your client machine as discussed above in my post.

    Thanks

    Shiv

    ReplyDelete
  9. Hi Shiva,

    When i am trying to import Salesforce objects from Designer tool i am getting below error.

    DescribeGlobal failed.Errorcode:[Soap-ENV:Client] Reason:[Timeout]

    I am getting time out error.

    I have already placed pmsfdc.ini file in the bin folder.

    Can you please tell what will be the solution.

    Thanks

    ReplyDelete
    Replies
    1. This is due to the mismatch between the entries in pmsfdc.ini file on the client machine, proxy host server from IE should match proxy details in the pmsfdc.ini file. Bex you were able to connect from IE to salesforce, The proxy user & proxy password in pmsfdc.ini file have some vulnerability in connecting to proxy server, hence it’s not routing the request to sfdc server. In that case you need to ask the network access team saying whether the credentials are perfect or not.

      Delete
  10. I am a Salesforce Admin trying to help a client who is changing some processes to use Salesforce's Bulk API.

    They received this error from IPC -

    [ERROR] Bulk API cURL error received. Error message [unknown version: 14.0].

    Are they using an invalid Service URL?

    ReplyDelete
    Replies
    1. My question is where they are using the sales force URL ? on the internet explorer if that is the case they'll have to use the right version of IE

      Delete
    2. Informatica Power Center is the ETL tool

      Delete
  11. Hi Shiva,

    I am getting below error while trying to import (in informatica -> Sources -> Import from Salesforce.com) objects -

    Login failed. Error code: [SOAP-ENV:Client] Reason: [SSL_ERROR_SSL error:1408F10B:SSL routines:SSL3_GET_RECORD:wrong version number]

    Please help me to solve this out.

    Thanks.

    ReplyDelete
  12. Hi Shiva,

    Are the above steps are used to connect salesforce using an adaptor/connector with Informatica power center?

    ReplyDelete
  13. Hi Shiva,
    How to avoid connection Time out while passing wsdl url in webservices Infomatica cloud,Is it possible to extend the connection time.

    Thanx

    ReplyDelete
  14. Hi Shiva,
    I need your help for a consulting opportunity for couple of hours to help with my client who is trying to push data from external database to salesforce using informatica powercenter. Could you let me know your rate and best time to talk to you further today on this? Please feel free to email me at buyan@eigenx.com or call me at 302-438-4097.
    Thanks
    Buyan

    ReplyDelete
  15. Thank you because you have been willing to share information with us. we will always appreciate all you have done here because I know you are very concerned with our. יחסי ציבור

    ReplyDelete
  16. סדנת מכירות קורס המכירות וסדנת המכירות הכי טובים בעולם

    ReplyDelete
  17. Hello I am so delighted I located your blog, I really located you by mistake, while I was watching on google for something else, Anyways I am here now and could just like to say thank for a tremendous post and a all round entertaining website. Please do keep up the great work. קורס מכירות

    ReplyDelete
  18. Hello,I just want to thank you for providing this post as I needed some information related to Informatica to complete my project on this topic.I was equally supported by this and Informatica Read Soap API.

    ReplyDelete
  19. She shudders with dissatisfaction when she discovers the greater part of the sales group is by one way or another unconscious of the vast majority of the substance she has made. By what means would this be able to be conceivable?cold call tips

    ReplyDelete
  20. As of late an entrepreneur disclosed to me that his sales were dropping and he asked me what he could do to make something happen.Cardone Cold Calling Script

    ReplyDelete
  21. The information which you have provided is very good. It is very useful who is looking for salesforce certification

    ReplyDelete
  22. When salespeople are measured against the 6 competency levels their true competency level can be identified. For the sales person to progress to a higher level the sales manager needs to use every teaching method available from seeing, hearing and demonstration to clarifying what to do and why.social proof tools

    ReplyDelete
  23. So if you want to thrive in difficult economic times, start by focusing your resources on building a strong foundation for your sales organization. B2B Database

    ReplyDelete
  24. As you search those yachts for sale, you might get confused because they are available in different features and style. It is always important to determine ahead of time what you want and needs so that you can be sure of what you are buying.

    ReplyDelete
  25. Training over time - research shows that two weeks after training, people typically retain 2-4% of what they learned... unless they've been actually using what they learned; Salesforce training in Chennai

    ReplyDelete
  26. Individuals never tell their PCP's and circuit testers how they have to take care of their responsibilities. Webdesignlab.be

    ReplyDelete
  27. Today, joins must be worked through connecting with connections. Taking our Plumber again, a connection back from the 'Gas Safe register', a nearby pipes place or washroom showroom, and a couple of neighborhood websites that like his data would be sufficient. Webdesign

    ReplyDelete
  28. It is close to difficult to assemble an anticipated, bankable pipeline dependent on the individual capacity of individuals in your sales group. Seoleadgeneration.be

    ReplyDelete
  29. You might need to request proof that their designs are cross-program viable and will show well on the whole significant programs, as well. Webdesign bureau

    ReplyDelete
  30. Whichever way you select your trial group, it is important to choose the people who already embody that high-achieving spirit, and who will achieve even greater results if they are given additional training, focus and direction. Salesforce training in Hyderabad

    ReplyDelete
  31. On the off chance that you accept that the sales individual isn't the best individual to conclude who to call, at that point it likewise makes sense that the sales individual may not be the best individual to choose what to say, when they do call a possibility.agent and dealer resources in Missouri & Kansas

    ReplyDelete
  32. Really awesome blog!!! I finally found great post here.I really enjoyed reading this article. Thanks for sharing your innovative ideas to our vision. your writing style is simply awesome with useful information. Very informative, Excellent work! I will get back here. . AWS Course in Chennai

    ReplyDelete
  33. With special privileges and services, UEFA BET offers opportunities for small capitalists. Together ufa with the best websites that collect the most games With a minimum deposit starting from just 100 baht, you are ready to enjoy the fun with a complete range of betting that is available within the website

    ufabet , our one another option We are a direct website, not through an agent, where customers can have great confidence without deception The best of online betting sites is that our Ufa will give you the best price

    ReplyDelete
  34. Online slots (Slot Online) is actually the introduction of a gambling machine. Slot machine As said before above Used to make electronic games referred to as web-based slots, due to the development era, people have turned to gamble with one another by computers. Will provide slot games to make internet gambling games Via the internet network process Which players are able to play through the slot program or will play Slots with the service provider's site Which internet slots games are obtainable in the form of participating in rules. It is similar to playing on a slot machine. Both practical images and sounds are at the same time thrilling as they go to lounge in the casino ever.

    ReplyDelete
  35. you could construct a contact plan upheld by pre supported promoting pieces and on the off chance that you do that you could most likely lessen your sales head check by up to half.iso merchant acquirer

    ReplyDelete
  36. ได้โดยที่จะทำให้คุณนั้นสามารถสร้างกำไรจากการเล่นเกมส์เดิมพันออนไลน์ได้เราแนะนำเกมส์ชนิดนี้ให้คุณได้รู้จักก็เพราะว่าเชื่อว่าทุกคนนั้นจะต้องรู้วิธีการเล่นและวิธีการเอาชนะเกมม สล็อต าแทบทุกคนเพราะเราเคยเล่นกันมาตั้งแต่เด็กเด็กหาคุณได้เล่นเกมส์คาสิโนออนไลน์ที่คุณนั้นคุ้นเคยหรือจะเป็นสิ่งที่จะทำให้คุณสามารถที่จะได้กำไรจากการเล่นเกมได้มากกว่าที่คุณไปเล่นเกมส์คาสิโนออนไลน์ที่คุณนั้นไม่เคยเล่นมาก่อนและไม่คุ้นเคย เราจึงคิดว่าเกมส์ชนิดนี้เป็นเกมส์ที่น่าสนใจมากๆที่เราอยากจะมาแนะนำให้ทุกคนได้รู้จักและได้ใช้บริการ

    ReplyDelete
  37. Allowed that is as yet imperative to do yet you should have the option to distinguish the significant errands or activities that lead up to an arrangement. North American Bancard Agent Program

    ReplyDelete
  38. Preferably you ought to furnish them with a possibility list, which has been investigated and gives them a rundown of organizations who have a requirement for your item and get some opportunity of consenting to see the sales individual, and afterward purchase your item. Top 10 Reasons Why You Should Get Salesforce Certified

    ReplyDelete
  39. Truth be told they will let you know the amount they love settling on chilly decisions and being in the field thumping on entryways, does this sound recognizable. posicionamiento web

    ReplyDelete
  40. The most strong of sales associations are those that utilization a half and half procedure, utilizing a blend of both direct sales staff and producers' agents. Sales groups made altogether out of every single direct individual or completely of producers' delegates are by and large not great. backlinks

    ReplyDelete
  41. Finally, ask yourself if you have the time and energy to promote yourself. If you want to be hired by a web design firm, in addition to learning skills and possibly obtaining certifications, you've also got to be ready to pound the pavement with your resume and portfolio.Digital Marketing Agency

    ReplyDelete
  42. There is no utilization in acquiring a meeting with a possibility that can't or won't get; it is a misuse of their time and your costly sales asset.túlméretes szállítás Europa-Road Kft.

    ReplyDelete
  43. I am thankful for the blog post. Really looking forward to read more. Great.
    upload reels to instagram from pc

    ReplyDelete
  44. How long does a Yorkie live? 13 – 16 years
    Are Yorkies cuddlers?
    A lover of all things comfortable, the Yorkshire terrier enjoys cuddling with loved ones and snuggling into everything soft and fluffy. And for you, their silky coat isn't too bad for petting. https://www.newdaypuppies.com/

    Adorable Teacup and Toy AKC Yorkie Puppies
    We have adorable Yorkshire Terrier puppies male and female (she is pictured with the bow).The little girl was born on and the male was born on. yorkie teacup for sale Both puppies have started potty training and have had all sets of puppy shots and deworming. They both come with AKC papers.The girl is very petite and has an adorable baby doll face. yorkies for sale near me She is a teacup and will mature to be around just lbs. She is very gentle and easy going She is the princess in our home and loves to be held.The male is full of spunk and is super playful He will mature to be lbs and would make an awesome family dog. He has a gorgeous silky coat and adorable teddy bear face.Both puppies are AKC registered and will come with a health guarantee shot record and sample puppy food. teacup yorkies for sale, teacup yorkie puppies for sale

    Adorable Teacup and Toy AKC Yorkie Puppies is a Female, Male Yorkshire Terrier Puppy for sale in US. Adorable Teacup and Toy AKC Yorkie Puppies by newdaypuppies for Female, Male Yorkshire Terrier Puppies. yorkshire terrier for sale

    ReplyDelete
  45. Is a Yorkie a good family dog?
    yorkie puppies for sale
    Yorkies, like many other Toy breeds, make good pets for people; they're especially good for senior citizens, people with medical issues, and those who may worry about the size and strength of a larger dog. ... They're loving, devoted, and very affectionate: This makes them great personal companions and good family pets.

    Do Yorkshire terriers bark a lot?
    teacup yorkie for sale
    Yorkshire Terriers are little dogs with huge personalities. yorkies for sale With those huge personalities come a fierce territorial bark. Any time your phone rings, someone speaks or knocks on your door, or your doorbell chimes, your Yorkshire Terrier will likely bark. Outside noises aren't even required for barking for some Yorkies. yorkie for sale near me

    How much do Yorkshire terriers cost?
    yorkies puppy for sale
    Typical Yorkie prices range from $1,500 to $3,000, but the cost can fall far below or above that range. Prices will vary based on the puppy's lineage, appearance, health, and the breeder. It's also possible to adopt an older Yorkie for significantly less through a rescue shelter.

    ReplyDelete
  46. Are Chihuahua puppies hard to train?
    chihuahua puppies for sale
    Chihuahuas are intelligent, strong-minded dogs that like to do their own thing. This can make them stubborn, earning them a reputation for being hard to train. However, reward-based training methods do appeal to a Chihuahua and there's no reason why they can't be trained to be obedient, just as with any dog

    Chihuahuas Have Fun, Playful Personalities
    teacup chihuahuas for sale
    Though chihuahuas are loyal and affectionate with their owners, they are anything but dull and love to play! However, no two chihuahuas are the same, so if you have a friend with a chihuahua, your pet is likely to be quite different and unique

    What food is bad for Chihuahua?
    teacup chihuahua for sale
    Foods Your Chihuahua Shouldn't Eat
    Alcohol. Alcohol (ethanol) is highly toxic to dogs. ...
    Caffeine. Coffee is one of the world's most popular beverages, with roughly 83% of the United States adult population consuming it on a daily basis. ...
    Chocolate. ...
    Some Fruit Seeds, Pits and Cores. ...
    Garlic. ...
    Grapes and Raisins. ...
    Hops. ...
    Onions.
    chihuahua puppy for sale

    The easiest way to adopt a Chihuahua would be through a rescue that specializes in Chihuahuas. A great place to start would be by starting a breed search on https://www.chihuahuapuppiesforsale1.com/chihuahua-puppies-for-sale-near-me/. The search will show you all the available Chihuahuas in your area.
    chihuahua puppies for sale near me

    ReplyDelete

  47. https://www.chihuahuapuppiesforsale1.com/
    http://www.myppuphouse.com/
    https://www.yorkiespuppiessale.com/

    ReplyDelete
  48. Thank you for the knowledge, much appreciated. I run an affiliate website in Norway within the personal finance niche. Do you think online content marketing would be a good strategy for us to implement? For instance, I found an article on Oblad done for Lånesiden. We're considering doing something similar to this, but I'm not sure what to expect when it comes to the ROI.

    ReplyDelete
  49. I appreciate you taking the time and effort to share your knowledge. This material proved to be really efficient and beneficial to me. Thank you very much for providing this information. Continue to write your blog.

    Data Engineering Services 

    Artificial Intelligence Services

    Data Analytics Services

    Data Modernization Services

    ReplyDelete

Featured Post

Cloud : A Trendsetter Technology