Expert Consultancy from Yellow Pelican

Talend Zuora Reference

A site about Talend

Talend Zuora Reference

I've recently started experimenting with Talend and Zuora and will start to document what I've found with a view to turning this in to a series of tutorials at some point.

This page was last updated on 19th March 2014.

I never quite got around to finishing this article and there doesn't seem a whole lot of demand for Talend and Zuora to work together, at the moment. If you're struggling with Zuora & Talend, then drop me a line. You'll also find this article very helpful - Zuora Soap API Basics.

I'll refer to Salesforce quite frequently as this is a good point of reference as a product that is well supported by Talend.

Please feel free to send your contributions as I think this will become a growing subject of interest.

Get a Zuora account

The first thing you'll need to do before you can start writing you Talend Zuora Jobs is to get a Zuora account. Unlike Salesforce, Zuora do not appear to provide a platform for developers to sign-up for, and play around with. If you have Zuora in your Organisation, then get an account from your Zuora Administrator, otherwise you're a bit stuck.

Your account will need to have the API user role.

You will find plenty of useful information on Zuora's Knowledge Centre.

Talend Support for Zuora

Unlike Salesforce, Talend does not have Custom Components to support Zuora, at the current time.

General Approach

General wisdon says that you should import the Zuora WSDL, meaning that you can then use the Talend Routines taht are created Java Classes to log in to and use Zuora.

In principle, this appears to be the best approach; however, in my experience, this is fraught with issues and is poorly documented, Although this was my initial approach (albeit inherited), at least for the Zuora login, I thought it would be helpful to show how you can login in to Zuor using the tSoap component. This should give you a good insight (together with the Zuora documentation) in to how you can use both the Zuora SOAP and REST APIs.

The remainder of this document will, although incomplete, hopefully give you an insight in to importing and using the WSDL, if this is the approach tht you choose.

Like most things, there's more than one way to achive our goal. Here, I'll describe methods for using Talend to both Export data from Data Sources, and Select data using ZOQL statements.

Get the Zuora WSDL

Now that you've got a Zuora account with the API user role, you now need to get the Zuora WSDL. To get this, log in to your Zuora account and follow the menu option : Settings > Z-Billing Settings > Download the Zuora WSDL.

Getting Started with Talend

Now that you've got your Zuora account and you've downloaded the Zuora WSDL, It's time to get started with Talend.

Create a new Job and add a tWebServiceInput Component. Select tWebServiceInput and then select the Component tab.

The Component tWebServiceInput can be used to log in to Zuora and then to request a Session Id.

Set the value of WSDL to the Zuora WISL that has been downloaded, for example, "file://zuora_wsdl.xml".

Expert Consultancy from Yellow Pelican
comments powered by Disqus