DataTransformations

Architecture
Pre-Installation Steps
Installing Supplier 360 components
Supplier portal configuration

1. Architecture:The installation of the Supplier 360 Application is required on the Informatica Multi domain MDM, along with Data Director and the embedded Informatica ActiveVOS Server.

The Supplier Relationship Management is depicted at the center of the diagram, while the Supplier Portal is positioned to the right. The MDM Hub receives inputs from both internal and external data sources. It is worth noting that the inclusion of a PIM system is discretionary.

ETL Tools:- Informatica PowerCenter/IDQ, IBM DataStage, Oracle Data Integrator etc

PIM Tools:- Informatica PIM,IBM Product master, Stibo Systems etc.

The Supplier 360 Application is equipped with a pre-set data model, which can be expanded upon if necessary.

2. Pre-Installation Steps:

Ensure that the following tasks have been accomplished prior to the installation of the Supplier 360 Application.

Multidomain MDM***
optionally, a product information management system, such as Product 360.

You receive Supplier 360 as an archive file. The archive contains....
configuration files -- Specify properties that reflect your environment
template files -- Replace template files with customized files, such as replacing the placeholder logo file with a file containing your organization logo
setup script --Then you can run the setup script.

MDM Installation Topology:

Install App server - Jboss
Install Multi Domain MDM - Refer to Installation Steps
*While creating Operational Reference Store, you must use the name "supplier_hub"
Importing the Application Metadata - change list(xml) from <MDM Installation Directory>/app/tsr/hub/change-xml/SUPPLIER_hub.change.xml
Inserting Reference Data - <MDM installation directory>/app/tsr/hub/schema/reference-data For Microsoft SQL Server.
Supplier_lookup_script_MSSQL.sql
3. Installing Supplier 360 Components:**

Create the following directory structure and extract the contents of the Supplier 360 archive file into it: <MDM Installation Directory>/app/tsr:


-rwxrwxrwx. 1 appsvc360mdm appsvc360mdm    229445 Dec 17  2020 Informatica_MDM-Supplier_360-10.4.2-build.zip
drwxr-xr-x. 1 appsvc360mdm appsvc360mdm    31 Dec 17  2020 app

Let's Check if the files available in app/tsr directory:


/informatica/media/app/tsr> ls -ltr
total 383400
-rw-r--r--. 1 appsvc360mdm appsvc360mdm    229445 Dec 17  2020 'Master Data Management Master Notices.docx'
-rw-r--r--. 1 appsvc360mdm appsvc360mdm  93129919 Dec 17  2020  MDMAppsServices.war
-rw-r--r--. 1 appsvc360mdm appsvc360mdm  49360958 Dec 17  2020  uiwebapp-ear.ear
-rw-r--r--. 1 appsvc360mdm appsvc360mdm 114937810 Dec 17  2020  mdmappsview-ear.ear
-rw-r--r--. 1 appsvc360mdm appsvc360mdm 110192354 Dec 17  2020  provisioning-ear.ear
-rw-r--r--. 1 appsvc360mdm appsvc360mdm      6895 Dec 17  2020  bundleLocalization.jar
-rw-r--r--. 1 appsvc360mdm appsvc360mdm      6332 Dec 17  2020  email-config-util.jar
-rw-r--r--. 1 appsvc360mdm appsvc360mdm     17323 Dec 17  2020  productversion.jar
drwxr-xr-x. 5 appsvc360mdm appsvc360mdm        92 Dec 17  2020  upgrade
-rw-r--r--. 1 appsvc360mdm appsvc360mdm  24691255 Dec 17  2020  supplierexternalcall.ear
drwxr-xr-x. 4 appsvc360mdm appsvc360mdm       139 Dec 17  2020  PortalAssociation
drwxr-xr-x. 2 appsvc360mdm appsvc360mdm        66 Dec 17  2020  was
drwxr-xr-x. 3 appsvc360mdm appsvc360mdm        53 Dec 17  2020  SupplierPortalWithProduct360
drwxr-xr-x. 3 appsvc360mdm appsvc360mdm        53 Dec 17  2020  SupplierPortal
drwxr-xr-x. 8 appsvc360mdm appsvc360mdm       114 Dec 17  2020  hub
drwxr-xr-x. 3 appsvc360mdm appsvc360mdm       103 Dec 17  2020  bpm
drwxr-xr-x. 3 appsvc360mdm appsvc360mdm        46 Dec 17  2020  email-config
drwxr-xr-x. 8 appsvc360mdm appsvc360mdm      4096 Dec 17  2020  resources
drwxr-xr-x. 9 appsvc360mdm appsvc360mdm       172 Dec 17  2020  pre_s360_10_4
drwxr-xr-x. 2 appsvc360mdm appsvc360mdm        50 Dec 17  2020  pre-install-config
drwxr-xr-x. 5 appsvc360mdm appsvc360mdm        75 Dec 17  2020  lookuplocalization
drwxr-xr-x. 4 appsvc360mdm appsvc360mdm       115 Dec 17  2020  localizationScript
drwxr-xr-x. 2 appsvc360mdm appsvc360mdm        49 Dec 17  2020  lib
drwxr-xr-x. 2 appsvc360mdm appsvc360mdm        65 Dec 17  2020  images
drwxr-xr-x. 3 appsvc360mdm appsvc360mdm        20 Dec 17  2020  externalcall
drwxr-xr-x. 2 appsvc360mdm appsvc360mdm        47 Dec 17  2020  docs
drwxr-xr-x. 6 appsvc360mdm appsvc360mdm        94 Dec 17  2020  datamart
drwxr-xr-x. 2 appsvc360mdm appsvc360mdm       257 Dec 17  2020  config
drwxr-xr-x. 3 appsvc360mdm appsvc360mdm      4096 Dec 17  2020  bin
drwxr-xr-x. 2 appsvc360mdm appsvc360mdm        28 Dec 17  2020  batchgroup

After extract, copy all files present in “app” to <MDM Installation Directory>:


/opt/infamdm> ls -ltr
total 0
drwxrwxr-x. 3 appsvc360mdm appsvc360mdm 20 Nov 22 13:57 avos
drwxrwxr-x. 4 appsvc360mdm appsvc360mdm 35 Nov 22 14:12 hub
drwxr-xr-x. 4 appsvc360mdm appsvc360mdm 31 Nov 23 21:34 app
drwxrwxr-x. 3 appsvc360mdm appsvc360mdm 18 Nov 23 23:06 applog

/opt/infamdm/app> ls -ltr
total 4
drwxr-xr-x. 24 appsvc360mdm appsvc360mdm 4096 Nov 23 23:56 tsr
drwxr-xr-x.  8 appsvc360mdm appsvc360mdm  243 Nov 24 00:37 portal

Please Note:-

Installation might fail if below points(1,2) not taken care.

1. In build.properties file, keep hostname in lower case, in all places.

2. <MDM installation directory>/app/tsr2/application.properties file

activevos.datasource.url=jdbc/ActiveVOS

Go to tsr/bin folder and complete following steps shown below:

/opt/infamdm/app/tsr/bin>./install-tsr.sh
(C) Copyright Informatica LLC 1998, 2020. See patents at https://www.informatica.com/legal/patents.html. All Rights Reserved.

Enter path to HUB Install Directory:/opt/infamdm/hub
Enter path to S360 Install Directory:/opt/infamdm/app/tsr
Enter type of app server (weblogic, jboss, websphere):jboss
Enter avos console username:administrator
Enter avos console password: <give password>
HUB_HOME=/opt/infamdm/hub
APP_HOME=/opt/infamdm/app/tsr
Appserver is jboss
------------------------------------------------------------------

Current folder : /opt/infamdm/app/tsr/bin
Current script : install-tsr.sh
Hub Home : /opt/infamdm/hub
App Home : /opt/infamdm/app/tsr

Parameters :
JBoss Home : /opt/EAP-7.1.0
Siperian Home : /opt/infamdm/hub/server
Java Home : /usr/lib/jvm/zulu-8

Classpath :
/opt/infamdm/hub/server/lib/ojdbc7.jar:/opt/infamdm/hub/server/lib/ant.jar:/opt/infamdm/hub/server/lib/xml-apis.jar:/opt/infamdm/hub/server/lib/xercesImpl.jar:/opt/infamdm/hub/server/lib/log4j-1.2.16.jar:/opt/infamdm/hub/server/lib/siperian-common.jar:/opt/infamdm/hub/server/lib/ant-apache-log4j.jar:/opt/EAP-7.1.0/bin/client/jboss-cli-client.jar:/opt/EAP-7.1.0/bin/client/jboss-client.jar=:/usr/lib/jvm/zulu-8/lib/rt.jar:/opt/infamdm/hub/server/lib/ojdbc7.jar:/usr/lib/jvm/zulu-8/lib/i18n.jar

------------------------------------------------------------------
------------------------------------------------------------------
------------------------------------------------------------------

installmdmapps:

[touch] Creating /opt/infamdm/app/tsr/bin/linux/lastbuild.touch

BUILD SUCCESSFUL

Total time: 59 seconds

Supplier 360 is successfully installed.

Validation:Check below ear files deployed properly under deployment folder


-rw-rw-r--. 1 appsvc360mdm appsvc360mdm 16 Nov 23 23:56 uiwebapp-ear.ear.deployed 
-rw-rw-r--. 1 appsvc360mdm appsvc360mdm  24 Nov 23 23:56 supplierexternalcall.ear.deployed
-rw-rw-r--. 1 appsvc360mdm appsvc360mdm 20 Nov 23 23:56 provisioning-ear.ear.deployed 
-rw-rw-r--. 1 appsvc360mdm appsvc360mdm 19 Nov 23 23:56 mdmappsview-ear.ear.deployed 
-rw-rw-r--. 1 appsvc360mdm appsvc360mdm 19 Nov 23 23:56 MDMAppsServices.war.deployed
-rw-rw-r--. 1 appsvc360mdm appsvc360mdm 115025103 Nov 23 23:56 mdmappsview-ear.ear
-rw-rw-r--. 1 appsvc360mdm appsvc360mdm 49360958 Nov 23 23:56 uiwebapp-ear.ear
-rw-rw-r--. 1 appsvc360mdm appsvc360mdm 93130964 Nov 23 23:56 MDMAppsServices.war
-rw-rw-r--. 1 appsvc360mdm appsvc360mdm 110192354 Nov 23 23:56 provisioning-ear.ear
-rw-rw-r--. 1 appsvc360mdm appsvc360mdm 24691743 Nov 23 23:56 supplierexternalcall.ear

4. Supplier portal configuration tool:

/opt/infamdm/app/portal/bin>./install-portal.sh
Enter the path to the MDM Hub installation directory:/opt/infamdm/hub
Enter the location to install the Portal Configuration tool:/opt/infamdm/app/portal
Enter the type of application server (weblogic, jboss, websphere):jboss
Enter the user name with administrative privileges to access the MDM Hub :admin
Enter the url for forgot password link :
Enter the user name with administrative privileges to access the ActiveVOS Console:administrator
Enter the password of the ActiveVOS Console administrative user: <Provide password for above user>
Do you want to deploy Generic Portal with PIM: (yes, no) no
Appserver is jboss
------------------------------------------------------------------
Hub Home : /opt/infamdm/hub
Portal Home : /opt/infamdm/app/portal
Parameters :
------------
JBoss Home : /opt/EAP-7.1.0
Siperian Home : /opt/infamdm/hub/server
Java Home : /usr/lib/jvm/zulu-8
Classpath :
/opt/infamdm/hub/server/lib/ojdbc7.jar:/opt/infamdm/hub/server/lib/ant.jar:/opt/infamdm/hub/server/lib/xml-apis.jar:/opt/infamdm/hub/server/lib/xercesImpl.jar:/opt/infamdm/hub/server/lib/log4j-1.2.16.jar:/opt/infamdm/hub/server/lib/siperian-common.jar:/opt/infamdm/hub/server/lib/ant-apache-log4j.jar:/opt/EAP-7.1.0/bin/client/jboss-cli-client.jar:/opt/EAP-7.1.0/bin/client/jboss-client.jar=:/usr/lib/jvm/zulu-8/lib/rt.jar:/opt/infamdm/hub/server/lib/ojdbc7.jar:/usr/lib/jvm/zulu-8/lib/i18n.jar
------------------------------------------------------------------
OpenJDK 64-Bit Server VM warning:
ignoring option MaxPermSize=256m; support was removed in 8.0 
Buildfile:
/opt/infamdm/app/portal/bin/linux/build_jboss.xml

Validation: Please verify files below are deployed properly.

<Jboss path>/standalone/deployments>
  -rw-rw-r--. 1 appsvc360mdm appsvc360mdm 18 Nov 24 00:38 generic-portal.ear.deployed
  -rw-rw-r--. 1 appsvc360mdm appsvc360mdm 163895013 Nov 24 00:38 generic-portal.ear

Informatica Supplier 360 & Portal installation and configuration

Architecture
Pre-Installation Steps
Installing Supplier 360 components
Supplier portal configuration

Portal URL:- http://<host name>:8080/portal-config/portals

Informatica Supplier 360 & Portal installation and configuration

ArchitecturePre-Installation StepsInstalling Supplier 360 componentsSupplier portal configuration

Portal URL:- http://<host name>:8080/portal-config/portals

Architecture
Pre-Installation Steps
Installing Supplier 360 components
Supplier portal configuration