Welcome to Semarchy.

This tutorial shows you how to set up Semarchy xDM using Semarchy's preconfigured Tomcat xDM installation which will allow you to run the tutorials available on the Semarchy website.

What you'll learn

What you'll need

Before you start

If you have not already done so, you can click on the DOWNLOAD TUTORIAL RESOURCES button to download resources, such as the sample files that you will use to set up xDM in this tutorial.

DOWNLOAD TUTORIAL RESOURCES

Enjoy this tutorial!

xDM high-level architecture

The Semarchy xDM architecture includes the following components:

In the next section, you will set up the database and application server to prepare your environment to set up Semarchy xDM.

A database is required to run xDM. In this step, we will set up a database if you do not already have one to use.

Database architecture

Before installing Semarchy xDM, you must create a database schema for the repository.

Next, you create additional schemas for the data locations. The name and number of schemas depend on the data locations you need.

In this section, you will create 1 repository and 4 data location schemas to allow you to complete all the xDM tutorials. Additionally, you will create another schema that will be used by the Integration tutorials track.

Choose a database

Semarchy xDM supports Oracle Database (Oracle), PostgreSQL (Postgres), and SQL Server. Check the Semarchy xDM documentation's database requirements to find which database versions are supported.

Pick one database to proceed.

Note that xDM features are identical on all databases.

☆ For Advanced Users

If you already have a database set up that follows the system requirements, you can skip the next section to download and install a database and move on to the task to set up Java.

Set up a PostgreSQL database

  1. Download and install PostgreSQL Database. You can download the PostgreSQL database from PostgreSQL's website.

DOWNLOAD POSTGRESQL

  1. Run the PostgreSQL Setup Wizard to install Postgres.
  2. Set a password during the PostgreSQL installation. Note your password. You will need it later.

Create schemas using pgAdmin 4

Now that you have installed PostgreSQL, you also have access to pgAdmin 4. You will use pgAdmin 4 to create the repository and data location schemas.

  1. Connect to the postgres user.
  2. Provide the password created during PostgreSQL installation.
  3. Open the Query Tool.
  4. Execute the user and schema creation scripts.
  5. Execute the grants.

install-on-premises/postgresql/4-setup-1-create-schemas.sql

/*******************************************************************************
** PostgreSQL database create schema scripts
** Semarchy xDM Tutorials
** Copy and paste the SQL DDL scripts and use them in the tutorial.
** Copyright (c) 2021 Semarchy
*******************************************************************************/

/******************************
Configure Database Schemas
******************************/
CREATE SCHEMA extensions;
GRANT USAGE ON SCHEMA extensions TO PUBLIC;
ALTER DEFAULT PRIVILEGES IN SCHEMA extensions GRANT EXECUTE ON FUNCTIONS TO PUBLIC;
ALTER DATABASE postgres SET SEARCH_PATH TO "$user",public,extensions;

CREATE EXTENSION IF NOT EXISTS "uuid-ossp"     with schema extensions;
CREATE EXTENSION IF NOT EXISTS "fuzzystrmatch" with schema extensions;

CREATE USER   semarchy_repository WITH PASSWORD 'semarchy_repository';
CREATE SCHEMA semarchy_repository AUTHORIZATION semarchy_repository;
GRANT USAGE ON SCHEMA semarchy_repository TO public;

/* Create the repository read-only user */
CREATE USER semarchy_repository_ro WITH PASSWORD 'semarchy_repository_ro';
GRANT CONNECT ON DATABASE postgres to semarchy_repository_ro;

CREATE USER   semarchy_product_retail_mdm WITH PASSWORD 'semarchy_product_retail_mdm';
CREATE SCHEMA semarchy_product_retail_mdm AUTHORIZATION semarchy_product_retail_mdm;
GRANT USAGE ON SCHEMA semarchy_product_retail_mdm TO public;

CREATE USER   semarchy_customer_b2c_mdm WITH PASSWORD 'semarchy_customer_b2c_mdm';
CREATE SCHEMA semarchy_customer_b2c_mdm AUTHORIZATION semarchy_customer_b2c_mdm;
GRANT USAGE ON SCHEMA semarchy_customer_b2c_mdm TO public;

CREATE USER   semarchy_emp_tutorial WITH PASSWORD 'semarchy_emp_tutorial';
CREATE SCHEMA semarchy_emp_tutorial AUTHORIZATION semarchy_emp_tutorial;
GRANT USAGE ON SCHEMA semarchy_emp_tutorial TO public;

CREATE USER   semarchy_b2b_tutorial WITH PASSWORD 'semarchy_b2b_tutorial';
CREATE SCHEMA semarchy_b2b_tutorial AUTHORIZATION semarchy_b2b_tutorial;
GRANT USAGE ON SCHEMA semarchy_b2b_tutorial TO public;

CREATE USER   semarchy_stg WITH PASSWORD 'semarchy_stg';
CREATE SCHEMA semarchy_stg AUTHORIZATION semarchy_stg;
GRANT USAGE ON SCHEMA semarchy_stg TO public;

/* Give all users read access to all the tables (and views) in semarchy_repository - NOT SUITABLE FOR A PRODUCTION ENVIRONMENT */
ALTER DEFAULT PRIVILEGES FOR USER semarchy_repository IN SCHEMA semarchy_repository GRANT SELECT ON TABLES TO public;

/* Setting the search path to include the repository */
ALTER ROLE semarchy_repository_ro SET SEARCH_PATH TO "$user", semarchy_repository,public,extensions;

/* Cleanup scripts to start fresh */
/*
  DROP SCHEMA semarchy_repository CASCADE;
  DROP USER   semarchy_repository;
  DROP owned by semarchy_repository_ro;
  DROP user semarchy_repository_ro;
 
  DROP SCHEMA semarchy_product_retail_mdm CASCADE;
  DROP USER   semarchy_product_retail_mdm;
 
  DROP SCHEMA semarchy_customer_b2c_mdm CASCADE;
  DROP USER   semarchy_customer_b2c_mdm;
  
  DROP SCHEMA semarchy_emp_tutorial CASCADE;
  DROP USER   semarchy_emp_tutorial;

  DROP SCHEMA semarchy_b2b_tutorial CASCADE;
  DROP USER   semarchy_b2b_tutorial;

  DROP SCHEMA semarchy_stg CASCADE;
  DROP USER   semarchy_stg;
*/
/******************************************************************************/

You have successfully installed a PostgreSQL database necessary for running xDM. In this part, you learned how to:

Go to 7. Setup Java to download and install Java.

Set up an Oracle database

  1. Download and install Oracle Database. You can download the Oracle database from Oracle's website.
  2. Create an account on Oracle.com.
  3. Download the Oracle database.

DOWNLOAD ORACLE DATABASE

  1. Unzip the Oracle installation files.
  2. Install Oracle database using the Oracle Database Installer.
  3. Set a password during the Oracle installation. Note your dba username, password, and SID. You will need this information later.

SQL Developer

Download and install SQL Developer. It is a free tool from Oracle that allows you to create your repository and data location schemas in the Oracle database.

  1. Download SQL Developer from Oracle's website.

DOWNLOAD SQL DEVELOPER

  1. Unzip the SQL Developer files.
  2. Open the SQL Developer application.
  3. Connect using the SYSTEM credentials within SQL Developer.

Create schemas

Now that you have installed Oracle and SQL Developer, you will create the repository and data location schemas in SQL Developer.

  1. Connect as the SYSTEM user.
  2. Execute the schema creation scripts.
  3. Execute the grants

install-on-premises/oracle/5-setup-1-create-schemas.sql

/*******************************************************************************
** Oracle database create schema scripts
** Semarchy xDM Tutorials
** Copy and paste the SQL DDL scripts and use them in the tutorial.
** Copyright (c) 2021 Semarchy
*******************************************************************************/

/******************************
Configure Database Schemas
******************************/
CREATE USER       SEMARCHY_REPOSITORY
IDENTIFIED BY     SEMARCHY_REPOSITORY
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP;

CREATE USER       SEMARCHY_PRODUCT_RETAIL_MDM
IDENTIFIED BY     SEMARCHY_PRODUCT_RETAIL_MDM
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP;

CREATE USER       SEMARCHY_CUSTOMER_B2C_MDM
IDENTIFIED BY     SEMARCHY_CUSTOMER_B2C_MDM
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP;

CREATE USER       SEMARCHY_EMP_TUTORIAL
IDENTIFIED BY     SEMARCHY_EMP_TUTORIAL
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP;

CREATE USER       SEMARCHY_B2B_TUTORIAL
IDENTIFIED BY     SEMARCHY_B2B_TUTORIAL
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP;

CREATE USER       SEMARCHY_STG
IDENTIFIED BY     SEMARCHY_STG
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP;

GRANT CONNECT, RESOURCE TO SEMARCHY_REPOSITORY
, SEMARCHY_PRODUCT_RETAIL_MDM
, SEMARCHY_CUSTOMER_B2C_MDM
, SEMARCHY_EMP_TUTORIAL
, SEMARCHY_B2B_TUTORIAL
, SEMARCHY_STG;


-- The following command should be used for Oracle 12c and above
GRANT UNLIMITED TABLESPACE TO SEMARCHY_REPOSITORY
, SEMARCHY_PRODUCT_RETAIL_MDM
, SEMARCHY_CUSTOMER_B2C_MDM
, SEMARCHY_EMP_TUTORIAL
, SEMARCHY_B2B_TUTORIAL
, SEMARCHY_STG;

-- Create the repository read-only user
CREATE USER SEMARCHY_REPOSITORY_RO
 IDENTIFIED BY SEMARCHY_REPOSITORY_RO
 DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP;

-- Grant minimum access to the user
GRANT CONNECT TO SEMARCHY_REPOSITORY_RO;

/* Cleanup scripts to start fresh */
/*
  DROP USER SEMARCHY_REPOSITORY CASCADE;
  DROP USER SEMARCHY_REPOSITORY_RO CASCADE;
  DROP USER SEMARCHY_PRODUCT_RETAIL_MDM CASCADE;
  DROP USER SEMARCHY_CUSTOMER_B2C_MDM CASCADE;
  DROP USER SEMARCHY_EMP_TUTORIAL CASCADE;
  DROP USER SEMARCHY_B2B_TUTORIAL CASCADE;
  DROP USER SEMARCHY_STG CASCADE;
*/

/******************************************************************************/

You have successfully installed an Oracle database necessary for running xDM. In this part, you learned how to:

Go to 7. Setup Java to download and install Java.

Set up a Microsoft SQL Server database

  1. Download and install SQL Server Database. You can download the SQL Server database from Microsoft's website.

DOWNLOAD SQL SERVER

  1. Run the SQL Server Setup Wizard to install SQL Server.
  2. Set a password during the SQL Server installation. Note your password. You will need it later.

SQL Server Management Studio

Download and install SQL Server Management Studio (SSMS). It is a free tool from Microsoft that allows you to create your repository and data location schemas in the SQL Server database.

  1. Download SSMS. You can use the DOWNLOAD SSMS button.
    DOWNLOAD SQL SERVER MANAGEMENT STUDIO
  2. Unzip the SSMS files.
  3. Open the SSMS application.
  4. Connect using the sa credentials within SSMS.

Disclaimer: the hyperlink from the download button will redirect you to Microsoft's website. This website is governed by the terms of use of Microsoft and *not* by the terms of use of Semarchy.

Create schemas

Now that you have installed SQL Server and SSMS, you will create the repository and data location schemas in SSMS.

  1. Connect as the sa user.
  2. Execute the schema creation scripts.
  3. Execute the grants

install-on-premises/sqlserver/6-setup-1-create-schemas.sql

/*******************************************************************************
** SQL Server database create schema scripts
** Semarchy xDM Tutorials
** Copy and paste the SQL DDL scripts and use them in the tutorial.
** Copyright (c) 2021 Semarchy
*******************************************************************************/

/******************************
Configure Database Schemas
******************************/

-- Repository
CREATE DATABASE SEMARCHY_REPOSITORY
GO
CREATE LOGIN SEMARCHY_REPOSITORY WITH  PASSWORD='SEMARCHY_REPOSITORY'
GO
USE SEMARCHY_REPOSITORY
GO
CREATE USER SEMARCHY_REPOSITORY FOR LOGIN SEMARCHY_REPOSITORY
GO
ALTER ROLE db_owner ADD MEMBER SEMARCHY_REPOSITORY
GO

-- Create the repository read-only user
CREATE LOGIN SEMARCHY_REPOSITORY_RO WITH PASSWORD='SEMARCHY_REPOSITORY_RO', DEFAULT_DATABASE=SEMARCHY_REPOSITORY
GO
USE SEMARCHY_REPOSITORY
GO
CREATE USER SEMARCHY_REPOSITORY_RO FOR LOGIN SEMARCHY_REPOSITORY_RO
GO

-- Grant minimum access to the user
GRANT CONNECT TO SEMARCHY_REPOSITORY_RO;


-- Retail MDM Data Location
CREATE DATABASE SEMARCHY_PRODUCT_RETAIL_MDM
GO
CREATE LOGIN SEMARCHY_PRODUCT_RETAIL_MDM WITH PASSWORD='SEMARCHY_PRODUCT_RETAIL_MDM'
GO
USE SEMARCHY_PRODUCT_RETAIL_MDM
GO
CREATE USER SEMARCHY_PRODUCT_RETAIL_MDM FOR LOGIN SEMARCHY_PRODUCT_RETAIL_MDM
GO
ALTER ROLE db_owner ADD MEMBER SEMARCHY_PRODUCT_RETAIL_MDM
GO

-- Customer B2C Data Location
CREATE DATABASE SEMARCHY_CUSTOMER_B2C_MDM
GO
CREATE LOGIN SEMARCHY_CUSTOMER_B2C_MDM WITH PASSWORD='SEMARCHY_CUSTOMER_B2C_MDM'
GO
USE SEMARCHY_CUSTOMER_B2C_MDM
GO
CREATE USER SEMARCHY_CUSTOMER_B2C_MDM FOR LOGIN SEMARCHY_CUSTOMER_B2C_MDM
GO
ALTER ROLE db_owner ADD MEMBER SEMARCHY_CUSTOMER_B2C_MDM
GO

-- Employee HR Tutorial - Track 1 - Data Location
CREATE DATABASE SEMARCHY_EMP_TUTORIAL
GO
CREATE LOGIN SEMARCHY_EMP_TUTORIAL WITH PASSWORD='SEMARCHY_EMP_TUTORIAL'
GO
USE SEMARCHY_EMP_TUTORIAL
GO
CREATE USER SEMARCHY_EMP_TUTORIAL FOR LOGIN SEMARCHY_EMP_TUTORIAL
GO
ALTER ROLE db_owner ADD MEMBER SEMARCHY_EMP_TUTORIAL
GO

-- Customer B2B - Track 2 - Data Location
CREATE DATABASE SEMARCHY_B2B_TUTORIAL
GO
CREATE LOGIN SEMARCHY_B2B_TUTORIAL WITH PASSWORD='SEMARCHY_B2B_TUTORIAL'
GO
USE SEMARCHY_B2B_TUTORIAL
GO
CREATE USER SEMARCHY_B2B_TUTORIAL FOR LOGIN SEMARCHY_B2B_TUTORIAL
GO
ALTER ROLE db_owner ADD MEMBER SEMARCHY_B2B_TUTORIAL
GO

-- Additional Data Location1
CREATE DATABASE SEMARCHY_DLOC1
GO
CREATE LOGIN SEMARCHY_DLOC1 WITH PASSWORD='SEMARCHY_DLOC1'
GO
USE SEMARCHY_DLOC1
GO
CREATE USER SEMARCHY_DLOC1 FOR LOGIN SEMARCHY_DLOC1
GO
ALTER ROLE db_owner ADD MEMBER SEMARCHY_DLOC1
GO

-- Additional Data Location2
CREATE DATABASE SEMARCHY_DLOC2
GO
CREATE LOGIN SEMARCHY_DLOC2 WITH PASSWORD='SEMARCHY_DLOC2'
GO
USE SEMARCHY_DLOC2
GO
CREATE USER SEMARCHY_DLOC2 FOR LOGIN SEMARCHY_DLOC2
GO
ALTER ROLE db_owner ADD MEMBER SEMARCHY_DLOC2
GO

-- Staging Data Location
CREATE DATABASE SEMARCHY_STG
GO
CREATE LOGIN SEMARCHY_STG WITH PASSWORD='SEMARCHY_STG'
GO
USE SEMARCHY_STG
GO
CREATE USER SEMARCHY_STG FOR LOGIN SEMARCHY_STG
GO
ALTER ROLE db_owner ADD MEMBER SEMARCHY_STG
GO

/* Cleanup scripts to start fresh */
/*
  DROP DATABASE SEMARCHY_REPOSITORY
  GO
  DROP LOGIN    SEMARCHY_REPOSITORY
  GO
  DROP LOGIN    SEMARCHY_REPOSITORY_RO
  GO
  DROP DATABASE SEMARCHY_PRODUCT_RETAIL_MDM
  GO
  DROP LOGIN    SEMARCHY_PRODUCT_RETAIL_MDM
  GO
  DROP DATABASE SEMARCHY_CUSTOMER_B2C_MDM
  GO
  DROP LOGIN    SEMARCHY_CUSTOMER_B2C_MDM
  GO
  DROP DATABASE SEMARCHY_EMP_TUTORIAL
  GO
  DROP LOGIN    SEMARCHY_EMP_TUTORIAL
  GO
  DROP DATABASE SEMARCHY_B2B_TUTORIAL
  GO
  DROP LOGIN    SEMARCHY_B2B_TUTORIAL
  GO
  DROP DATABASE SEMARCHY_DLOC1
  GO
  DROP LOGIN    SEMARCHY_DLOC1
  GO
  DROP DATABASE SEMARCHY_DLOC2
  GO
  DROP LOGIN    SEMARCHY_DLOC2
  GO
  DROP DATABASE SEMARCHY_STG
  GO
  DROP LOGIN    SEMARCHY_STG
  GO
*/

/******************************************************************************/

You have successfully installed the SQL Server database necessary for running xDM. In this part, you learned how to:

Go to 7. Setup Java to download and install Java.

xDM requires Java 8 or 11. It also requires an application server that you will configure in the next step.

☆ For Advanced Users

If you already have Java 8 or 11 set up that follows the system requirements AND you have configured your JAVA_HOME environment variable, you can skip this step and move on to 8. Download and configure Semarchy xDM.

Install Java

Download and install Java 11 JDK which is needed for xDM. Download Java installation files from Oracle's website.

DOWNLOAD JAVA 11

  1. Run the Java Setup application to install Java.
  2. In the Programs and Features application in the Control Panel, check that Java was successfully installed.

Great job installing Java! In the next part, you will install and configure xDM.

In this section, you will download and configure xDM for startup. Choose the On-premises version of xDM, which includes a Tomcat application server.

Download Semarchy xDM

  1. Download the On-premises xDM files.

DOWNLOAD SEMARCHY xDM ON-PREMISES

  1. Unzip the xDM files to somewhere reasonable, like the Downloads or Documents folder in a Windows environment.

Prepare the configuration file

You will now create a configuration file that stores all the connection parameters to the xDM repository. The repository includes information like your license key as well as your data model and the business rules and logic that you will apply to your organization's data.

  1. Create a file named config.properties under the <TOMCAT_HOME>/conf folder.
  2. Paste the following content depending on your database:

PostgreSQL: install-on-premises/postgresql/config.properties

# Repository datasource
xdm.repository.driver=org.postgresql.Driver
xdm.repository.url=jdbc:postgresql://localhost:5432/postgres
xdm.repository.username=semarchy_repository
xdm.repository.password=semarchy_repository
# Repository read-only datasource credentials
xdm.repository.readonly.username=semarchy_repository_ro
xdm.repository.readonly.password=semarchy_repository_ro

Oracle: install-on-premises/oracle/config.properties

# Repository datasource
xdm.repository.driver=oracle.jdbc.OracleDriver
xdm.repository.url=jdbc:oracle:thin:@localhost:1521:XE
xdm.repository.username=SEMARCHY_REPOSITORY
xdm.repository.password=SEMARCHY_REPOSITORY
# Repository read-only datasource credentials
xdm.repository.readonly.username=SEMARCHY_REPOSITORY_RO
xdm.repository.readonly.password=SEMARCHY_REPOSITORY_RO
# Set the current schema of the readonly user to the repository
xdm.repository.readonly.connectioninitsql=ALTER SESSION SET CURRENT_SCHEMA = SEMARCHY_REPOSITORY

SQL Server: install-on-premises/sqlserver/config.properties

# Repository datasource
xdm.repository.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
xdm.repository.url=jdbc:sqlserver://localhost:1433;databaseName=SEMARCHY_REPOSITORY
xdm.repository.username=semarchy_repository
xdm.repository.password=semarchy_repository
# Repository read-only datasource credentials
xdm.repository.readonly.username=semarchy_repository_ro
xdm.repository.readonly.password=semarchy_repository_ro

Create the startup configuration for Windows

Now that your configuration file is ready, you will modify the setenv.bat file to reference this configuration file and set all the environment variables that are required for startup. Edit the setenv.bat in the mdm-server\bin folder.

  1. Reference the configuration file you created earlier: add the following line to the setenv.bat file:
set "CATALINA_OPTS=%CATALINA_OPTS% -Dxdm.config.file=..\conf\config.properties"
  1. Copy the path to your Java installation.
    Example: C:\Program Files\Java\jdk-11.0.5
  2. Add the following line to define the JAVA_HOME variable and set it to the path of your Java installation.
set "JAVA_HOME=C:\Program Files\Java\jdk-11.0.5"
  1. Set the Setup Token: add the following line to your setenv.bat file:
set SEMARCHY_SETUP_TOKEN=mySetupToken
  1. Double check and save the content of your the setenv.bat file, which should now look as follows:

quick-install/install-on-premises/setenv.bat

set "CATALINA_OPTS=%CATALINA_OPTS% -Xmx512M -server -XX:+UseG1GC"
set "CATALINA_OPTS=%CATALINA_OPTS% -Dorg.apache.cxf.Logger=org.apache.cxf.common.logging.Slf4jLogger -Dorg.ops4j.pax.logging.DefaultServiceLog.level=WARN -Duser.language=en -Duser.country=US -Djava.awt.headless=true"

rem Configuration file
set "CATALINA_OPTS=%CATALINA_OPTS% -Dxdm.config.file=..\conf\config.properties"

rem JAVA_HOME
set "JAVA_HOME=C:\Program Files\Java\jdk-11.0.5"

rem Setup Token (initial setup only)
set SEMARCHY_SETUP_TOKEN=mySetupToken

Create the startup configuration (MacOS or Linux)

Now that your configuration file is ready, you will modify the setenv.sh file to reference this configuration file and set all the environment variables that are required for startup.Edit the setenv.sh in the mdm-server/bin folder.

  1. Reference the configuration file: add the following line to your setenv.sh file:
CATALINA_OPTS="$CATALINA_OPTS -Dxdm.config.file=../conf/config.properties"
  1. Copy the path to your Java installation.
    Example: /Library/Java/JavaVirtualMachines/jdk-11.0.5
  2. Add the following line to define the JAVA_HOME variable and set it to the path of your Java installation.
export JAVA_HOME=/Library/Java/JavaVirtualMachines/jdk-11.0.5
  1. Set the Setup Token: add the following line to your setenv.bat file:
export SEMARCHY_SETUP_TOKEN=mySetupToken
  1. Double check and save the content of your the setenv.sh file, which should now look as follows:

quick-install/install-on-premises/setenv.sh

CATALINA_OPTS="$CATALINA_OPTS -Dxdm.show.stacktrace.jsp.error=true -server -XX:+UseG1GC -Dorg.apache.cxf.Logger=org.apache.cxf.common.logging.Slf4jLogger -Duser.language=en -Duser.country=US -Djava.awt.headless=true"

#Configuration file
CATALINA_OPTS="$CATALINA_OPTS -Dxdm.config.file=../conf/config.properties"

#JAVA_HOME
export JAVA_HOME=/Library/Java/JavaVirtualMachines/jdk-11.0.11.jdk/Contents/Home

#Setup Token (initial setup only)
export SEMARCHY_SETUP_TOKEN=mySetupToken

Run xDM

Under Windows

  1. Go to the mdm-server\bin folder.
  2. Open the startup.bat file. You'll see a Terminal window pop up. You should have started Tomcat successfully.

Under MacOS/Linux

  1. Go to the mdm-server/bin folder.
  2. Execute the startup.sh file: ./startup.sh. You should have started Tomcat successfully.

Congratulations

Great job installing Java and xDM ! In this part, you learned how to:

In the next part, you will navigate to http://localhost:8088/semarchy and request a license key.

In this step, you will install your xDM instance.

  1. In your browser, connect to http://localhost:8088/semarchy.
  2. Enter the Setup Token you have set in your setenv file and click LOG IN:

  1. Review the End-User License Agreement (EULA) and select ACCEPT.
  2. Configure the repository and the administrator account and then click INSTALL:

  1. Wait until the repository is installed.

  1. When the instance is ready, click SIGN IN.

  1. Enter the semadmin credentials you defined during the installation, and then click LOG IN.

  1. If you see this page, then you have successfully installed the repository.

xDM is now up and running. You can find more details about system requirements and installing xDM in our documentation.

In the next step, you will finalize the installation by granting access rights for some of the tables of the Semarchy repository you have just created.

Now that the repository has been initialized, you must grant access to some of the tables that have just been created: the repository read-only user needs SELECT privileges on the profiling tables to render the xDM Discovery profiles.

  1. Connect to the database with the same client and credentials as previously.
  2. Depending on your database, run the following script to grant to the repository read-only user select privileges on the profiling tables:

PostgreSQL: install-on-premises/postgresql/10-finalize-1-grant-access.sql

/*******************************************************************************
** Oracle database post-installation scripts
** Semarchy xDM Tutorials
** Copy and paste the SQL DDL scripts and use them in the tutorial.
** Copyright (c) 2021 Semarchy
*******************************************************************************/

/************************************************
Grant select privileges on the profiling tables
************************************************/
GRANT USAGE ON SCHEMA semarchy_repository TO semarchy_repository_ro;
GRANT SELECT ON TABLE
    semarchy_repository.PRF_PROFILING,
    semarchy_repository.PRF_TABLE,
    semarchy_repository.PRF_COLUMN,
    semarchy_repository.PRF_DIST_VALS,
    semarchy_repository.PRF_DIST_PATTERNS
TO semarchy_repository_ro;

Oracle: install-on-premises/oracle/10-finalize-1-grant-access.sql

/*******************************************************************************
** Oracle database post-installation scripts
** Semarchy xDM Tutorials
** Copy and paste the SQL DDL scripts and use them in the tutorial.
** Copyright (c) 2021 Semarchy
*******************************************************************************/

/************************************************
Grant select privileges on the profiling tables
************************************************/
GRANT SELECT ON SEMARCHY_REPOSITORY.PRF_PROFILING TO SEMARCHY_REPOSITORY_RO;
GRANT SELECT ON SEMARCHY_REPOSITORY.PRF_TABLE TO SEMARCHY_REPOSITORY_RO;
GRANT SELECT ON SEMARCHY_REPOSITORY.PRF_COLUMN TO SEMARCHY_REPOSITORY_RO;
GRANT SELECT ON SEMARCHY_REPOSITORY.PRF_DIST_VALS TO SEMARCHY_REPOSITORY_RO;
GRANT SELECT ON SEMARCHY_REPOSITORY.PRF_DIST_PATTERNS TO SEMARCHY_REPOSITORY_RO;

SQL Server: install-on-premises/sqlserver/10-finalize-1-grant-access.sql

/*******************************************************************************
** Oracle database post-installation scripts
** Semarchy xDM Tutorials
** Copy and paste the SQL DDL scripts and use them in the tutorial.
** Copyright (c) 2021 Semarchy
*******************************************************************************/

/************************************************
Grant select privileges on the profiling tables
************************************************/
USE SEMARCHY_REPOSITORY
GO
GRANT SELECT ON PRF_PROFILING TO SEMARCHY_REPOSITORY_RO;
GRANT SELECT ON PRF_TABLE TO SEMARCHY_REPOSITORY_RO;
GRANT SELECT ON PRF_COLUMN TO SEMARCHY_REPOSITORY_RO;
GRANT SELECT ON PRF_DIST_VALS TO SEMARCHY_REPOSITORY_RO;
GRANT SELECT ON PRF_DIST_PATTERNS TO SEMARCHY_REPOSITORY_RO;

You learned how to install xDM on-premises (on your local computer). Let's summarize:

Great job going through this tutorial!

Now that you have set up xDM, you can request a license key.

The next step is to proceed to two different tutorial tracks:

  1. How to use xDM applications as a business user, following the Product Retail Demo and the Customer B2C tutorials.
  2. How to design applications as a developer, following the Data Authoring and Data Consolidation tutorials.

Go back to the main menu to find these tutorials.

GO TO TUTORIALS

Go further with xDM

This tutorial taught you how to install xDM. xDM is capable of addressing all types of data, including customer data, location data, reference data, organization data, supplier data, and other domains.

Visit our website to learn about the different solutions we provide.