How to install Semarchy xDM(MDM) - Installation ( Config + Setup ) Part2

Semarchy xDM(MDM) - Installation ( Config + Setup ) Part2
This video covers installation, configuration and setup of Semarchy xDM(MDM) to have a fully working instance
setenv File
set "CATALINA_OPTS=%CATALINA_OPTS% -server -XX:+UseG1GC"
set "CATALINA_OPTS=%CATALINA_OPTS% -Dorg.apache.cxf.Logger=org.apache.cxf.common.logging.Slf4jLogger -Duser.language=en -Duser.country=US -Djava.awt.headless=true"
rem -----------------------------------------------------------------------------
rem Oracle
rem Uncomment this section to use this technology.
rem -----------------------------------------------------------------------------
rem rem Repository datasource
set XDM_REPOSITORY_DRIVER=oracle.jdbc.OracleDriver
set XDM_REPOSITORY_URL=jdbc:oracle:thin:@localhost:1521:XE
set XDM_REPOSITORY_USERNAME=semarchy_repo
set XDM_REPOSITORY_PASSWORD=semarchy_repo
rem rem Repository read-only datasource credentials
set XDM_REPOSITORY_READONLY_USERNAME=discovery
set XDM_REPOSITORY_READONLY_PASSWORD=discovery
rem rem Set the current schema of the readonly user to the repository
set XDM_REPOSITORY_READONLY_CONNECTIONINITSQL=ALTER SESSION SET CURRENT_SCHEMA = semarchy_repo
rem =============================================================================
rem Setup Token
set SEMARCHY_SETUP_TOKEN=changeit
Schemas File
--Use below alter session command in case create user is not working. I am on oracle 18c express edition where create user was not working so below statement had to be run
alter session set "_oracle_script"=true;
--Create the repository schema - Oracle
CREATE USER semarchy_repo IDENTIFIED BY semarchy_repo
DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP;
GRANT CONNECT, RESOURCE TO semarchy_repo;
-- The following command should be used for Oracle 12c and above
GRANT UNLIMITED TABLESPACE TO semarchy_repo;
--Create the repository read-only user - Oracle
-- Create the repository read-only user
CREATE USER discovery
IDENTIFIED BY discovery
DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP;
-- Grant minimum access to the user
GRANT CONNECT TO discovery;
-- The repository_readonly_user user must use the following statement to default his schema to the repository.
ALTER SESSION SET CURRENT_SCHEMA = semarchy_repo;
Create a data location schema - Oracle
CREATE USER customer_dloc IDENTIFIED BY customer_dloc
DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP;
GRANT CONNECT, RESOURCE, CREATE VIEW TO customer_dloc;
-- The following command should be used for Oracle 12c and above
GRANT UNLIMITED TABLESPACE TO customer_dloc;
Courses:
I have created a complete Semarchy xDM course on udemy. Please have a look at it in case you are interested.
Link - www.udemy.com/...
I have created a complete Customer Master Data Management course which provides step by step guide to implement key capabilities needed in a standard CMDM solution using Semarchy. Please have a look at it in case you are interested.
Link - www.udemy.com/...
I have created a complete product information management (PIM) course which covers all key capabilities standard PIM solution should have. Please have a look at it in case you are interested.
Link - www.udemy.com/...
I have created a complete reference data management (RDM) course which covers all key capabilities standard RDM solution should have. Please have a look at it in case you are interested.
Link - www.udemy.com/...
I have created a complete Informatica upgrade course which covers planning and implementation steps from 9.6.1 to 10.4.1 for both powercenter and data quality. Please have a look at it in case you are interested.
www.udemy.com/...