enterprise integration using third party transformation
Skip this Video
Download Presentation
Enterprise Integration Using Third Party Transformation

Loading in 2 Seconds...

play fullscreen
1 / 17

Enterprise Integration Using Third Party Transformation - PowerPoint PPT Presentation

  • Uploaded on

Enterprise Integration Using Third Party Transformation. Session: 101960. Save the Date. APRIL 7-11, 2014 Sands Expo and Convention Center Las Vegas, Nevada. QuestDirect.org/COLLABORATE.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Enterprise Integration Using Third Party Transformation' - marvel

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Save the Date

APRIL 7-11, 2014

Sands Expo and Convention Center

Las Vegas, Nevada


COLLABORATE 14- Quest Forum is THE source for PeopleSoft roadmaps & news. It matters where you register! All PeopleSoft education and events run through Quest

  • Wells Fargo Profile
  • Our issue
  • Alternatives explored
  • IBM DataPower
  • Historical Path/Future Direction
wells fargo company
Wells Fargo & Company
  • Wells Fargo & Company (NYSE: WFC) Wells Fargo & Company is a diversified financial services company providing banking, insurance, investments, mortgage, and consumer and commercial finance through more than 9,000 stores and more than 12,000 ATMs and the Internet (wellsfargo.com) across North America and internationally serving over 70 million customers.
  • We employ over 282,000 team members in more than 35 countries across our 80+ businesses
  • Current US population consists of
      • 265,000 full-time employees
      • 16,000 part-time employees
      • 1800 flexible employees
peoplesoft installations
PeopleSoft Installations
  • MVS/DB2 platform
  • Initially installed PeopleSoft version 2.0 in 1993 (HR/Payroll/Benefits)
  • Multiple upgrades to 4.5, 6.0, 7.5, and 8.3 throughout the years
  • Upgraded to PS version 8.9 in 2007
  • Upgrade to version 9.2 projected go live May 2014
  • Needed to publish an asynchronous message to MQ series for our identity management system (onboarding)
  • Integration with MQ for Asynchronous required large infrastructure support from PS team
    • WebLogic tweaks and MQ agents
  • Wells Fargo specific SOAP message – WFXML
  • PeopleTools doesn’t support external WSDL and XSD not generated by itself if producer of service
  • Create customized method to build WFXML
    • Didn’t allow for other formats
    • Methods created to do this, had to be maintained through tools upgrades
    • Mod to import different WSDL – needed to be maintained with tools upgrades
    • Worked okay with tweaking for each new service
  • Use PS delivered integration with JDeveloper to create XSLT
    • Clunky method, includes running an app engine as part of message
  • 3rd party transformation
    • Software to create XSLT and import
    • SOA device to do transformation
      • Wells Fargo already using DataPower
what is datapower
What is DataPower ?
  • An IBM Integration Appliance that provides security and integration gateway capabilities
  • Optimized High performance hardware, firmware, embedded OS
  • Easier and quicker configuration based development and administration
  • High speed transformation and processing using dedicated, hardware-based accelerators
ps dp integrations in production
PS/DP Integrations in Production
  • NRT(Near Real Time) publishing from PeopleSoft to OUI and IAM Subscribers via MQ
  • PeopleSoft Integration broker connects to DataPower via https and sends PS XML message.
  • DataPower Transforms the message to two WFXML messages and publish to OUI and IAM MQ topics respectively.
ps dp integrations in production1
PS/DP Integrations in Production
  • TurboTax(Intuit) integration with PeopleSoft for real time retrieval of W2
  • TurboTax(Intuit) sends OFX request to DataPower which it transform in to PS XML request and call the PS IB via F5.
  • W2 Response from PS was transformed to OFX and sent back to TurboTax
historical path
Historical Path
  • First project was to implement connection to MQ for Async message
    • Started to install MQ client software
    • Used PS delivered connectors
    • Started to realize ongoing cost of maintenance and special configuration needed
    • Discovered DataPower comes with built in hook to MQ (imagine that)
    • Used DataPower device to connect to MQ not for transformation, only had to change routing definition, no software installation
    • Insulated from changes to MQ
historical path1
Historical Path
  • Fix for PeopleTools8.52 Bug
    • Internal service used WFXML
    • Upgraded to tool 8.52, missed testing service
    • Service started failing, discovered bug that put an extra SOAP envelope around the SOAP envelope
    • Changed to message through DataPower. DataPower stripped the extra wrapper. No code changes on either side. Connected to different end points.
    • First use of transformation capabilities
historical path2
Historical Path
  • W2 OFX message
    • Used existing build of W2 online rowsets
    • Needed specific format for OFX standard
    • Using DataPower, could use existing code and do not have to maintain changes to standard in PS
impacts to future
Impacts to Future
  • DataPower now standard for all our external services.
    • Removing WFXML PS mod
    • Single communication point, allows for easier certificate maintenance etc.
  • All XML based messages will now use part message
    • Strips PSCAMA stuff out
    • Allows for cleaner XML out of PS
    • Can structure more like XML needed
    • rowsetbased – utilize existing skill
  • Experts doing the right work
    • Our DataPower staff is really good at transformation and communication services
    • Our PeopleSoft staff is really good at PeopleSoft
  • Integration with 3rd Party recruiting
    • Moving to a SaaS model for recruiting
    • 30+ integration points, all will use DataPower.
  • CI as a service
    • Anticipate use of this more extensively

Please complete your evaluation: Session 101960

Thank you!