Sharing Knlowledge With The World…

Category: Talend

Access Apex Rest API Salesforce from TalenD

images

Hello Readers,

This is our follow post on Talend Interview Questions, below are the all required steps to access Salesforce data using your own Talend Instance using APEX REST API.

Step 1

In SF go to Setup, Create, Apps. Scroll to bottom of page where it says Connected apps and click new by visiting the given url

https://www.salesforce.com/us/developer/docs/api_rest/Content/intro_understanding_authentication.htm

Access Apex Rest API Salesforce from TalenD

Access Apex Rest API Salesforce from TalenD

 

Name can be anything as long as you know what it is, callback URL does not really matter, but use same as example. The important thing is selecting the Access and Manage Your data in scopes.

Step  2

After you create it, Consumer Key and Consumer Secret Values are what you use in Call to OAUTH API. Please see the screenshot below.

Access Apex Rest API Salesforce from TalenD

Access Apex Rest API Salesforce from TalenD

 

Step 3

After setting up the Connected App in Salesforce, we need to make a call to OAUth API to get token i.e access token. For making the call we need to have cURL installed. There may be other options but I prefer cURL.

 Step 4

One can download the cURL with SSL for one’s OS  and the required certificate of it from the below link https://support.zendesk.com/hc/en-us/articles/203691436-Installing-and-using-cURL

Step 5

Create a cURL folder on your machine and move the cURL.exe and its certificate to that folder. Setup “Path” environment variable of it so that cURL can be accessed from anywhere in command prompt. Please see the screenshot below.

Access Apex Rest API Salesforce from TalenD

Access Apex Rest API Salesforce from TalenD

 

 

Step 6

Once the cURL is setup, run the below mentioned command in command prompt to get the access token mentioned in Step 3.

curl –data “grant_type=password&client_id=<insert consumer key here>&client_secret=<insert consumer secret here>&username=<insert your username here>&password=<insert your password and token here>” -H “X-PrettyPrint:1” https://test.salesforce.com/services/oauth2/token

Response of this would be something like this

{

  “id” : “https://test.salesforce.com/id/00Dc0000003txdzEAA/005D0000001wi7EIAQ”,

  “issued_at” : “1421777842655”,

  “token_type” : “Bearer”,

  “instance_url” : “https://<instance>.salesforce.com”,

  “signature” : “AJjrVtbIpJkce+T4/1cm/KbUL7d4rqXyjBJBhewq7nI=”,

  “access_token” : “00Dc0000003txdz!ARQAQHJEpvN8IcIYcX8.IfjYi0FJ6_JFICLcMk6gnkcHdzMF1DYd2.ZW9_544ro7CnCpO4zzPmkgQ7bE9oFd8yhBALGiIbx7”

}

Step 7

Use the “access_token” value in tRESTClient in “Bearer Token”. Please see the screenshot below.

Access Apex Rest API Salesforce from TalenD

Access Apex Rest API Salesforce from TalenD

 

 Step 8

Use 2 tLogRow components, one for showing the success result and the other for displaying any error thrown. Please see the screenshot below

Capture

 

Step 9

Execute the job and you see result as below

Capture

 

Thank you very much for reading the article!!!

Please feel free to post your comments.

 

Continue Reading

Cloud Computing Pros and Cons

Cloud Computing Pros and Cons

 

Cloud Computing Pros and ConsCloud Computing has definitely emerged as one of the most upcoming technologies , where organizations are considering to upgrade their infrastructure to support cloud computing.We have put together a list of Cloud Computing Pros and Cons that a company should be aware of in regards to cloud computing.

Cloud Computing Pros

Cost Effective

Cloud Computing is highly cost efficient in terms of maintenance . Traditional desktop software contribute to extra cost when adding multiper user licences which increases the cost to company. While cloud technology is comparatively lot cheaper than maintaining your own hardware.There are many one-time-payment, pay-as-you-go and other scalable options available.

Unlimited  Storage (Almost !!)

You need not worry about running out of storage space , the cloud service provider will take care of all storage concerns.You just need to request for additional space.

Backup Recovery

Backup and high availability is perhaps one of the greatest advantages of computing on cloud. Since all data is available in cloud ,it is much easier to maintain backups rather than having data on a physical device.

Data accessibility

Since data is always available , it can be accessed from any part of the world (as long as you have a internet connection!!) .Time zone difference are taken care of as well.

Environmental Benefits

Cloud computing drastically reduces the carbon emissions for an organization . Studies show that total carbon emission reduces by upto 35%.

Cloud Computing Cons:

Security

This perhaps is the biggest threat when it comes to Cloud computing.All the enterprise data is at the helm of a third party vendor which could pose major threat if the vendor is not reliable.

Compatibility

While moving onto cloud , organizations would have the need to replace their existing IT infrastructure so that it is compatible on cloud.This could prove to be a costly affair.

Standardization

It could happen that the cloud service vendor does not have proper standard for cloud computing. IEEE has set standards in cloud computing for optimum quality .In order avoid pitfalls due to standardization , the company needs to investigate if the provider uses standard technology.

Conclusions

Yes cloud computing does have certain disadvantages associated with it , but the Pros outweighs the cons . These risks can be easily mitigated if the company involved takes steps to manage these risks. However the immense benefits that cloud computing  offers is over whelming and extremely beneficial . Cloud computing and BI is definitely the way of the future.

 

Continue Reading

Business Intelligence Benefits – Top 10 Reasons your business should go for BI

Business Intelligence Benefits

Business Intelligence BenefitsBusiness Intelligence is on the verge of huge change. For a long time it has been limited to only the larger organizations . With the advent of open-source technologies , BI has become much more accessible . In today’s post we would be discussing some key  Business Intelligence benefits to create awareness of this wonderful concept and as to why one should leverage BI capabilities in their enterprise solutions.

1) Stay ahead of competition

Arm your team with compelling BI reporting and examination so they can stay in front of the pack, and exploit patterns and new open doors as they arrive. Visually intelligent dashboards gives your group access to sales financial and operational parameters of your product/organization as well as your competitor.

2) Foresee and react to patterns

Examine organization and competitor information to set competitive objectives, and track achievements against key performance indicators for the business . Analyze trends and mitigate business risks. Apply hypothetical variables to your information to foresee possible outcomes , historical informational data caters to creation of a predictive model.

3) Empower Decision Making with on-demand data .

Business Intelligence  lets your team, from field reps to top level administration, access dynamic data and empower them with business perspective by offering deep insights into data , enabling better decision making.

4) Visual dashboards and custom-made reports at your fingertips.

Visually stunning and detailed information could be conveyed to the significant individuals via reporting dashdboards with custom reports , with ability to drill down and dissect the information to gain insights. Furthermore BI reports has provisions to customize reports to fit each users needs through simple drag drop functionality.

5) Reduce wastage , efficient manage resources.

BI helps to get rid of  nonaligned data systems and eliminate resource wastage. Eliminates wasting time and resources spent on correcting data errors and manually compiling spreadsheet based reports , so your resources can add maximum value to the organization growth by focusing more on the business growth.

6) Track and monitor Customer behavior

Business Intelligence helps you to identify what customers are buying, what are trends of the buying customers. You can monitor customer behavior and use data insights to drive loyalty and maximize profit by identifying up-sell and cross-sell opportunities. BI also provides opportunities to identify conversions for a potential lead to become a customer

DataWareho

7) Ability to mine data , discover your true manufacturing costs

Business Intelligence software has the ability to create automated alerts to notify managers of incidents that require action. This brings more efficiency in managing procurement , managing inventory , delivery which reduces cost and mitigates risks.

8) Discovering New Questions and Their Answers

Business intelligence is data driven in nature , trending patterns helps us identify and ask new questions leading to a data-driven discovery. Else it could work the other way round where-in you may have certain questions which could be answered using historical data in the warehouse.

9)  Mobile Device Accesibility

BI enables easy integration with various  mobile devices like I-pads,laptops , mobiles. Hence reps/directors can have access to reports on-site on -fields or in office.

10) Efficient Data Management

BI enables integration of enterprise wide  disparate data sources into a single unified data-warehouse,  to ensure consistency and accuracy. This data is cleansed quality data , which makes data management very easy.

These points here just scratch the surface when it comes to Business Intelligence benefits , if you feel strongly feel about other benefits you want to point out please feel free to comment below and let us know.

Check this very awesome video out which outlines BI concepts in a very interesting way.

Continue Reading

Talend Big Data adds SaaS Anlystics to its Arsenal

Talend Blue Yonder parternship

 

Talend, the open source Big Data merchant, has stretched its accomplice biological community through new joint effort with Blue Yonder. Together, the organizations will apply programming as-an administration (Saas)-based prescient examination to Big Data that exists in an assortment of structures.

The association focuses on Blue Yonder’s Forward Demand, a Saas information dissection stage intended to help organizations concentrate esteem from data. The assention between the two organizations will include new “connectors” to the Talend Big Data stage that will make it conceivable to concentrate information from an extent of sources and break down them in Forward Demand.

However that is not all. The organizations are working together in different regions, too, “on undertakings in various areas including retail, saving money, account, utilities and an extent of other vertical markets,” as per an announcement. They will show some of their shared results at approaching occasions and webinars open on the web.

To an extensive degree, the organization is about streamlining Big Data investigation by permitting clients to break down the information they require, regardless of its source or current state, utilizing the apparatuses they need. That result, the organizations trust, will engage clients by sparing cash and time.

“Working with Talend will bring broad profits both to ourselves and to our clients,” said Ralf Werneth, senior director, Alliances at Blue Yonder. “Truly, we associated with our clients’ information sources utilizing custom interfaces. Information Integration was lengthy yet needed to empower access to extra assets of information,” he included. “On account of Talend’s cutting edge joining ability our clients can essentially lessen custom advancement. For the client, this makes an interpretation of straightforwardly into diminished improvement expenses, cohorted support and enhanced time-to-esteem.”

“François Chiche, VP, Alliances at Talend said: “Our association with Blue Yonder highlights by and by the force of Big Data. Talend gathers the information Blue Yonder and its clients need and makes it accessible to them. Blue Yonder’s quality is supporting information driven choice administration and its Saas Solution Forward Demand conveys exact figures from huge volumes of information continuously. It’s an immaculate fit.

 

 

Continue Reading

Talend Netezza Interaction

NET_IBM_RGB

Hello Readers,

Today we will discuss about how  Talend – Netezza interactwith each other , along with a simple demonstration that will use the available Netezza components.

you will find all Netezza related components in Palette available.

STEPS : –

1) Installing NZJDBC,jar :-  Initially when you drag any of Netezza component from the Palette , and if your library does not contain required .jar to support those components then it will throw an error as shown below.

This means your TOS do not have supported .jar

Talend Netezza Interaction

nzjdbc-error-mark

AUTOMATIC SETUP

Immediately a popup will come which will automatically install the required drivers. However if it fails to install the required .jar then you have to manually place that jar file.

MANUAL SETUP

(a)  Download nzjdbc.jar from the internet.

(b) Copy downloaded .jar file into this location  (C:\TOS\TOS_DI-Win32-r101800-V5.3.0\lib\java)

(c) Save your Current Job and Re-Start TOS (Talend Open Studio).

 

 EXAMPLE 

Now you are set to go ,just drag and drop your required components from the palette and connect them as per the business requirement.

This below job will show a simple Talend Netezaa Interaction and will create an excel file from a Netezza Database Table.

 

Talend Netezza Interaction

Talend Netezza Interaction

 

A) Drag tNetezzaConnection from the palette and fill  all required entries like   Host , DB-Name and  Password

B) Now to Read data from a table drag tNetezzaInput and specify attributes such as table Name and write your SQL like

(select emp_id , ename from emp limit 100)    *It will only fetch 100 rows from the employee table

C) At final to populate the row/data to some output( Excel file ) drop this component  to the designer area.

D) Connect All components as shown in figure.

E) Save and Run The Job.

 

Talend Netezza Interaction Successful …

 

 

Check out our other posts on Talend Interview Questions

 Author : – Ankit Kansal & Nayan Naik

 

 

Continue Reading

Call DB Sequence From Talend

Capture
Hello Readers,
Today we will discuss how call db sequence from Talend while loading data. For demo purposes we have taken Oracle as our Database.STEPS:
1) Create a sequence in Database using : –create sequence test_seq start with 1 increment by 1;
The above statement will create a sequence in Oracle Databse.
select test_seq.nextval from dual;
This statement is very important as it will initialize your sequence.2)Take a source file/Databse and connect it to your oracle output component with all schema defined at Target Level.

call db sequence from Talend

call db sequence from Talend


3)Go to Advance Setting Tab of oracle output component and change the settings as defined in the screenshot.

call db sequence from Talend

call db sequence from Talend

seqence_name.nextval is the command which you have to write in SQL Expression. so that for every row this expression will call your Sequence present at Database Level.

Thanks For Reading……

Talend Interview Questions

Author:- Ankit Kansal & Nayan Naik
Continue Reading

User Define Function In Talend

first_func
Hello Readers,
Talend list of unique features also includes writing your own set of functions, which provides you great flexibility in your work , and one of its feature that is widely used is “User Define Function In Talend
STEPS:-
1) In left panel of the environment right click the routines tab and create routine by providing suitable names such as user_sum.
(you can write any routine name as per your requirement but it should make sense for better understandablity)
2) Create a desired function to achieve your desired functionality like f_sum.

User Define Function In Talend

User Define Function In Talend

(you can create any function as per your requirement)

Note : – Use of static keyword while creating function helps in calling a that function without creating a object for that class. If you do not specify static keyword while creating a function then it becomes mandatory for you to call that function by first creating an object for that class.

3)Call to a function

User Define Function In Talend

User Define Function In Talend

In this job our function f_sum takes two numbers and returns the sum for those two numbers. A call is made to function in tMap describing by the image given below.

User Define Function In Talend

User Define Function In Talend

however you can use this function at any place inside the job where talend permits to write your own code or to use methods.
 CALLING A FUNCTION : – user_sum.f_sum(row1.first, row1.second)
 
You can also create/import libraries from outside which contains Classes and functions and after importing those libraries into your job you can use features from those…
So, this how you can create and use “User Define Function In Talend” and use them in different situations.
Thanks For Reading……

Talend Interview Questions
Author:- Ankit Kansal & Nayan Naik
Continue Reading
PageLines