PeopleService Connection via Talend

Owned by Marissa Kitz (Unlicensed)
Last updated: Jan 17, 2017

Talend is an ETL program that can be used to extract the data from the PeopleService web service, load your database tables or application, and can also do transformations.

 

****THIS GUIDE IS IN THE PROCESS OF BEING REVISED, CURRENT JOB WILL NOT WORK WITH NEW SERVICE!*****

 

Here is an example of a basic Talend job for loading a database table:

  1. Request Values: This inserts what values you want to send as parameters
  2. Build Request: Turns your human input values into an XML formatted request message to "POST" to the web service
  3. Log Request: This puts the XML message into your log for debugging
  4. CallPeopleService: This sends the XML message to the web service endpoint and authenticates using your username and password (you will have to add this into the job)
  5. Extract Data: This uses the XSD (see important documents) to pull the data out of the file
  6. Load Table: This loads your database table. (the example uses OracleDB, but other database options are available)

Example Talend Job:

CallPeopleHubService.zip

  1. Download the zip file
  2. Open your Talend Project
  3. Right-click on "Job Designs"
  4. Select "Import Items"
  5. Select "Archive file" and browse for the zip file
  6. Click the checkbox in the main window
  7. Click "Finish"