Web Services
Informatica Platform
Single organic product architecture
Provider Informatica Data Integration Platform Shared Services
XML, Messaging, and Web Services
Audit
Access
Third Party INTEROPERABILITY
Integrate Visualize
Repository
Portals, Dashboards, and Reports
Audit
Repository Server Global
XML, Messaging, and Web Services
Third Party EXTENSIONS
Packaged Applications
Local
Packaged Applications
Relational and Flat Files
Web Services Hub PowerCenter Connects PowerExchange
Data Server
Relational and Flat Files
Mainframe and Midrange
Engine
Mainframe and Midrange
Universal Data Services Architecture
Web Services: Extensibility, Interoperability Service oriented architecture for extensibility
10,000 developers Customer extensions
Web Services
(SOAP, WSDL)
(SOAP, WSDL, UDDI)
Web Services
3rd party products
Web Services
(SOAP, WSDL)
Major app vendor OEMs
Web Services Example Usage
1
Call a PowerCenter workflow Order Application
Customer Application
Return info to calling application
Get customer data
Call to D&B for credit rating
D&B
4
DEMO
Using PmCmd
Greg Hanson Principle Consultant
What is PmCmd??
pmcmd is a program that you can use to communicate with the PowerCenter Server. You can perform some of the tasks that you can also perform in the Workflow Manager such as starting and stopping workflows and tasks
PmCmd Modes
Command line mode. The command line syntax allows you to write scripts for scheduling workflows. Each command you write in the command line mode must include connection information to the PowerCenter Server. Interactive mode. You establish and maintain an active connection to the PowerCenter Server. This allows you to issue a series of commands.
N.B Some functionality is dependent upon the mode in which connected
8
So what can I do with PmCmd
Connect/Disconnect to and from the server Get Server Details / Properties and shutdown server Navigate the repository Start/Stop/Abort/Resume Sessions and Workflows Monitor Sessions and Workflows Receive session status messages (using Wait Commands)
Useful Commands
Ping Server
In the command line mode, use the following syntax to ping the PowerCenter Server: pmcmd pingserver <-serveraddr|-s> [host:]portno In the interactive mode, enter the following syntax at the pmcmd prompt to ping the PowerCenter Server: Pingserver
This is Useful to ensure that the server is running prior to carrying out any subsequent commands
10
Useful PmCmd Commands - Cont
Starting a Workflow
pmcmd startworkflow <-serveraddr|-s> [host:]portno <<-user|-u> username|<-uservar|-uv> userEnvVar> <<-password|-p> password|<-passwordvar|-pv> passwordEnvVar> [<-folder|-f> folder] [<-startfrom> taskInstancePath] [-recovery] [-paramfile paramfile] [-wait|-nowait] Workflow PowerCenter Folder in which workflow exists Point Within Workflow you wish to start from Enables recovery flag Workflow parameter file existing on PowerCenter Machine Wait for Job to finish and receive return codes Workflow Name
[<-localparamfile|-lpf> localparamfile] Parameter file existing on Pmcmd Machine
11
External Schedulers
You can use pmcmd commands with operating system scheduling tools like cron Embed pmcmd commands into shell scripts or Perl programs. Each command must include the connection information to the PowerCenter Server and the PowerCenter repository.
12
DEMO
13
Version Control
Greg Hanson Principle Consultant
14
Team-based Development for Transparency of Location
Traditional
New New Approach Approach
Industrys only 3-tier architecture
Metadata Repository Local Repository
Industrys only global and local metadata architecture
Repository Server
Complete version management Automated object migration Fully schedulable deployment
Metadata Repository
15
Version Control Functionality
Object versioning Check-in and -out of versioned objects Compare objects Delete or purge a version Deployment groups Labels Queries Track changes Rollback Command line deployment
16
PMRep Utility Lights Out Deployment
System commands. Repository commands. Security commands. Change management commands.
Add, copy, or delete deployment groups. Check in objects. Add or delete labels. Import or export objects. Execute queries
17
PmRep Commands
AddToDeploymentGroup ApplyLabel Checkin ClearDeploymentGroup CreateDeployment CreateLabel DeleteDeploymentGroup DeleteLabel DeployDeploymentGroup DeployFolder ExecuteQuery FindCheckout UndoCheckout Validate
18
DEMO
19
