How to extract Data from Zuora with Talend ETL ?

Talend Zuora AQUA Template Job

Hi,

Here is an example how to extract data from Zuora using webservices :

STEP 1 : GET THE ID FROM ZUORA

STEP 2 : CREATE THE QUERY

STEP 3 : GET RESULTS AND FORMAT DATA

 

Here are these steps in a real job doing an extract all data of an object from Zuora:

 

 

You need to import the Zuora routine for that before starting.

STEP 1 :  tWebservice :

Here is the content of the first tWebservice
routines.Soap_PortType zuoraSoap = new routines.ZuoraServiceLocator().getSoap();
routines.SoapBindingStub zuoraStub = (routines.SoapBindingStub) zuoraSoap;
routines.LoginResult zuoraLoginResult = zuoraStub.login(context.zuoraUsername, context.zuoraPassword);
context.zuoraSessionId = zuoraLoginResult.getSession();

 

 

Zuora

 

 

 

As zuora can have many warning ( as any webservice ) you need to use the try catch java function , to avoid stopping the queries

 

STEP 2 : CREATE THE QUERY

Post Tagged with ,

Leave a Reply