Expert Consultancy from Yellow Pelican


A site about Talend

tSalesforceConnection Component

The tSalesforceConnection component is part of the Salesforce family of components. tSalesforceConnection allows you to establish a connection with Salesforce, which can then be used by other components within the Salesforce family.

For general information on connecting to Salesforce, read out article on Salesforce Basics. You may also find it useful to read the article on Repository Metadata.

Repository Connection

If you you've already followed the tutotial on Repository Metadata, you'll have created a Salesforce connection within the Talend Repository. In this tutorial, we created a connection to a free Developer Force account. We then imported the Account object. I would always recommend creating a repository connection to your development sandbox. If you have not already done this, I would recommend doing this now.

A Simple Connection Job

Now that we have a repository connection, we could simply drag a Salesforce object, for example Account, from the repository connection to the design canvas of a new Talend Job. Talend would then allow us to choose the type of component that we would like to create.

Although this is a convenient way to design your Job, I do not recommend this as it becomes troublesome when you want to change connection parameters, for example, when you promote your Job through Test and Production. As discussed in Salesforce Basics, I always create a Context Group and then externalise the connection parameters.

For now, let's create a simple Talend Job, and drag our Account object from the repository. When asked to Choose one component to create, select tSalesforceConnection as shown in the screenshot below.

Image 1

Locate a Salesforce object with in the repository and then drag it to the design canvas. In this example, we are using Account.

You can now choose the component that you'd like to add to your Job. The default component is tSalesforceInputtSalesforceConnection.

Your Job should now look something like the screenshot below.

Note. Depending on the version of Talend that you are using, you may need to install some additional external libraries. Install these as needed, by following the on-screen instructions.

Expert Consultancy from Yellow Pelican
comments powered by Disqus