Informatica PIM Setup

Install DB

Prerequisites: DB is installed and DBA gave following details

  • SYSTEM password
  • TNS Details
  • Provide path of where the Tablespace is stored on the server
  • Remove Encryption temporarily during DB setup
  1. Install DB using DB Setup
  2. Navigate to Install Directory on Windows Machine
    1. PIM_8.0.6.02.00_Rev-54110_dbSetupClient_win32.full\dbclient
  3. Update server.properties with DB credentials and gain SYSTEM credentials at \PIM_8.0.6.02.00_Rev-54110_dbSetupClient_win32.full\dbclient\configuration
  4. Run DB Setup as Admin

  1. Database setup will show ‘Complete’.

  1. Check logs to ensure no errors

Install Control Center

Prerequisites:

  • Admin access to install the application
  1. Unzip the install files to the server

  1. Unzip PIM_8.0.6.02.00_Rev-54110_clusterix_win64.full to the desired drive

  1. Open the file <PIM ROOT>\clusterix\configuration\clusterix\NetworkConfig.xml in an editor and adjustthe properties as described below.

  1. Install Control Center as service by running the script <PIM ROOT>/clusterix/install.cmd

Make sure you run as administrator

  1. Go to Services and start service Informatica MDM – Product 360 – Control Center v1.0
  2. Go to Installation and upload license in control center web UI
    1. http://hostname:9000/

Application Server

  1. Copy server.properties file from DB Install into following path
    1. /Informatica/clusterix/configuration/HPM
  2. Restart Control Center Service

  1. Navigate to the server.properties in the deployment tab>Configuration in the Control Center

  1. Edit server.properties file
    1. filestorage.dir.shared = /homepath*/Informatica
    2. license.customer.file.local = ${filestorage.dir.shared}/license/Standard_001460_NCR_Corporation.license
    3. license.customer.key = TkNSIENvcnBvcmF0aW9u

  1. Save
  2. Update networkconfig.xml with server name instead of localhost
    1. Save
  3. Create folder in shared directory called ‘License’
  4. Load License file into Control Center

  1. Open Deployment> Installation
  2. In the “Installation Files”, press the upload button and select the application server archive. The archive has to stay zipped. Click on upload to upload the installation file.
  3. After the upload has been completed, select the application server archive in the widget and press the Installbutton.
  4. The installation process will automatically copy the installation archive to all server nodes.
  5. The archive will be extracted to <PIM ROOT>\server.
  6. Configuration files will be copied and adjusted accordingly.
    1. Finally, the Windows/Linux service will be installed on the remote machines.

  1. Go to Monitoring tab and start server

  1. Check logs to ensure server start
    1. PIMHOME/server/logs
  2. You installed Informatica MDM Product 360!

ActiveVOS Server Installation

  1. Load install files to directory
    1. JDK
    2. Tomcat
    3. ActiveVOS Server
  2. Run .sh

  1. Navigate to /opt/Informatica/ActiveVOS/Server/server-enterprise/tomcat_config/bin
  2. Run ./config_deploy.sh console

The configuration wizard can perform the following operations. Please select the operations you would like to perform. Before you proceed please review the Prerequisite section of the documentation.

Configure ActiveVOS Server: [default:true]

Configure ActiveVOS Central: [default:true]

Configure Database: [default:true]

Deploy Applications and Resources: [default:true][1:Next][3.Redisplay]

Configuration Options:

The configuration wizard can perform the following operations. Please select th e operations you would like to perform. Before you proceed please review the Pre requisite section of the documentation.

Configure ActiveVOS Server: [default:true]

Configure ActiveVOS Central: [default:true]

Configure Database: [default:true]

Deploy Applications and Resources: [default:true][1:Next][3.Redisplay]

1

ActiveVOS Server Configuration:

Please provide the information required for ActiveVOS to access your database se rver. Select the Help button to learn more about the parameters on this dialog.

Database:

view available options

1) DB2

2) MySQL [default]

3) Oracle

4) SQLServer

Enter a number

3

[1:Next][2:Previous][3.Redisplay]

1

ActiveVOS Server Configuration:

Please provide the JNDI names for the following resources. Select the Help butto n to learn more about the parameters on this dialog.

Database JNDI: [default:jdbc/ActiveVOS][1:Next][2:Previous][3.Redisplay]

1

Security Configuration:

ActiveVOS can be deployed in a secured manner. Please select the security option s you want to enable. Select the Help button to learn more about the parameters on this dialog.

Administrative functions: [default:false]

Process services: [default:false]

ActiveVOS Identity Service Consumer: [default:false][1:Next][2:Previous][3.Redisplay]

1

Cluster Configuration:

Please configure your cluster options. Select the Help button to learn more abou t the parameters on this dialog.

Enable Clustering: [default:false][1:Next][2:Previous][3.Redisplay]

1

ActiveVOS Central Configuration:

The ActiveVOS Central needs access to services provided by ActiveVOS Server. Pl ease enter the connection information. Select the Help button to learn more abou t the parameters on this dialog.

Session Timeout (Minutes): [default:30]

ActiveVOS Central AeTaskService URL: [default:http://[hostname.domainname]:[po rt]/active-bpel/services/AeB4PTaskClient-taskOperations]

http://RPC1996.daytonoh.ncr.com:8080/active-bpel/services/AeB4PTaskClient-taskOp erations

[1:Next][2:Previous][3.Redisplay]

1

Database Configuration:

Please provide the information that will be used to complete the configuration o f ActiveVOS database datasource. Select the Help button to learn more about the parameters on this dialog.

Driver class: [default:]

oracle.jdbc.OracleDriver

Driver url: [default:]

jdbc:oracle:thin:@rpc1995.daytonoh.ncr.com:1521:PMDMDEV

Database name: [default:ActiveVOS]

PMDMDEV

Driver jar: [default:]

/opt/Informatica/apache-tomcat-8.0.44/lib/ojdbc6.jar

Username: [default:bpeluser]

AVOS_DEV

Password: [default:bpel]

avosdev

Connection Timeout: [default:1000]

Minimum Connections: [default:10]

Maximum Connections: [default:100]

Validate Connection: [default:true][1:Next][2:Previous][3.Redisplay]

1

Database connection successful.

Press enter to continue

Deployment Options:

Please select your deployment options. Select the Help button to learn more abou t the parameters on this dialog.

Install database schema [default:false]

true

Install database descriptor [default:true]

true

Deploy ActiveVOS [default:true]

true

Deploy ActiveVOS Central [default:true][1:Next][2:Previous][3.Redisplay]

1

Application server path:

Please select your application server. Select the Help button to learn more abou t the parameters on this dialog.

Directory: [default:]

/opt/Informatica/apache-tomcat-8.0.44

[1:Next][2:Previous][3.Redisplay]

1

Be sure to configure JVM memory as described in the Installation Checklist. See Help for details.

[1:Next][2:Previous][3.Redisplay]

Incapable to locate tools.jar.

Anticipated to find it in /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.141-1.b16.el7_3.x86_64/lib/tools.jarDisabling cluster Copying 1 file to /opt/Informatica/ActiveVOS/Server/server-enterprise/tomcat_config/b in/.tmp_cpopying 1 file to /opt/Informatica/ActiveVOS/Server/server-enterprise/tomcat_config/bin/.tmp_cp

Finished

You have new mail in /var/spool/mail/root

[root@RPC1996 bin]#

  1. Startup Tomcat
    1. /opt/Informatica/apache-tomcat-8.0.44/bin
    2. ./startup.sh
    3. Check URL to ensure tomcat has started HOST:8080
    4. Check URL to ensure AVOS is started up http://rpc1996.daytonoh.ncr.com:8080/activevos/home.action
Mahesh J

Mahesh J

Author

Hello all! I’m a nature’s child, who loves the wild, bringing technical knowledge to you restyled.