Integrate Zuora Data in Your Informatica Cloud Instance

Informatica Cloud allows you to perform extract, transform, and load (ETL) tasks in the cloud. With the Cloud Secure Agent and the CData JDBC Driver for Zuora, you get live access to Zuora data, directly within Informatica Cloud. In this article, we will walk through downloading and registering the Cloud Secure Agent, connecting to Zuora through the JDBC Driver and generating a mapping that can be used in any Informatica Cloud process.

Informatica Cloud Secure Agent

To work with the Zuora data through the JDBC Driver, install the Cloud Secure Agent.

1. Navigate to the Administrator page in Informatica Cloud
2. Select the Runtime Environments tab
3. Click "Download Secure Agent"
4. Make note of the Install Token
5. Run the installer on the client machine and register the Cloud Secure Agent with your username and install token

NOTE: It may take some time for all of the Cloud Secure Agent services to get up and running.

Connecting to the Zuora JDBC Driver

With the Cloud Secure Agent installed and running, you are ready to connect to Zuora through the JDBC Driver. Start by clicking the Connections tab and clicking New Connection. Fill in the following properties for the connection:

• Connection Name: Name your connection (i.e.: CData Zuora Connection)
• Type: Select "JDBC_IC (Informatica Cloud)"
• Runtime Environment: Select the runtime environment where you installed the Cloud Secure Agent
• JDBC Connection URL: Set this to the JDBC URL for Zuora. Your URL will look similar to the following:
  
  jdbc:zuora:OAuthClientID=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;Tenant=USProduction;ZuoraService=DataQuery;InitiateOAuth=GETANDREFRESH;

  Zuora uses the OAuth standard to authenticate users. See the online Help documentation for a full OAuth authentication guide.

  Configuring Tenant property

  In order to create a valid connection with the provider you need to choose one of the Tenant values (USProduction by default) which matches your account configuration. The following is a list with the available options:

  • USProduction: Requests sent to https://rest.zuora.com.
  • USAPISandbox: Requests sent to https://rest.apisandbox.zuora.com"
  • USPerformanceTest: Requests sent to https://rest.pt1.zuora.com"
  • EUProduction: Requests sent to https://rest.eu.zuora.com"
  • EUSandbox: Requests sent to https://rest.sandbox.eu.zuora.com"

  Selecting a Zuora Service

  Two Zuora services are available: Data Query and AQuA API. By default ZuoraService is set to AQuADataExport.

  DataQuery

  The Data Query feature enables you to export data from your Zuora tenant by performing asynchronous, read-only SQL queries. We recommend to use this service for quick lightweight SQL queries.

  Limitations
  • The maximum number of input records per table after filters have been applied: 1,000,000
  • The maximum number of output records: 100,000
  • The maximum number of simultaneous queries submitted for execution per tenant: 5
  • The maximum number of queued queries submitted for execution after reaching the limitation of simultaneous queries per tenant: 10
  • The maximum processing time for each query in hours: 1
  • The maximum size of memory allocated to each query in GB: 2
  • The maximum number of indices when using Index Join, in other words, the maximum number of records being returned by the left table based on the unique value used in the WHERE clause when using Index Join: 20,000

  AQuADataExport

  AQuA API export is designed to export all the records for all the objects ( tables ). AQuA query jobs have the following limitations:

  Limitations
  • If a query in an AQuA job is executed longer than 8 hours, this job will be killed automatically.
  • The killed AQuA job can be retried three times before returned as failed.

  Built-In Connection String Designer

  For assistance in constructing the JDBC URL, use the connection string designer built into the Zuora JDBC Driver. Either double-click the .jar file or execute the .jar file from the command-line.

  java -jar cdata.jdbc.zuora.jar

  Fill in the connection properties and copy the connection string to the clipboard.

• JDBC Jar Directory: Set this to the lib folder in the installation location for the JDBC Driver (on Windows, typically C:\Program Files\CData[product_name]\)
• Driver Class: Set this to cdata.jdbc.zuora.ZuoraDriver
• Username: Set this to a placeholder value (since Zuora does not require a username)
• Password: Set this to a placeholder value (since Zuora does not require a password)

Create a Mapping for Zuora Data

With the connection to Zuora configured, we can now access Zuora data in any Informatica process. The steps below walk through creating a mapping for Zuora to another data target.

1. Navigate to the Data Integration page
2. Click New.. and select Mapping from the Mappings tab
3. Click the Source Object and in the Source tab, select the Connection and set the Source Type
4. Click "Select" to choose the table to map
5. In the Fields tab, select the fields from the Zuora table to map
6. Click the Target object and configure the Target source, table and fields. In the Field Mapping tab, map the source fields to the target fields.

With the mapping configured, you are ready to start integrating live Zuora data with any of the supported connections in Informatica Cloud. Download a free, 30-day trial of the CData JDBC Driver for Zuora and start working with your live Zuora data in Informatica Cloud today.