/
Setup Scm Activity Database
Setup Scm Activity Database
Supported Databases by Active Objects ORM:
- Aurora / MySQL / MariaDB
- PostgreSQL (recommended)
Here for demo we will use MySQL Database commands to setup SCM Activity Database:
STEP-1
Create Scm Activity Database.
CREATE DATABASE IF NOT EXISTS scmactivity character set utf8;
STEP-2
Create Database user credentials with permissions.
CREATE USER 'scmactivity'@'%' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON scmactivity.* TO 'scmactivity'@'%'; FLUSH PRIVILEGES;
STEP-3
Configure SCM Activity JDBC Connection.
AURORA / MYSQL / MARIADB
jdbc:mariadb://localhost/scmactivity //use this for unicode character encoding jdbc:mariadb://localhost/scmactivity?useUnicode=yes&characterEncoding=UTF-8
POSTGRESQL
jdbc:postgresql://localhost:5432/scmactivity
, multiple selections available,
Related content
Setup Scm Activity Database (Legacy)
Setup Scm Activity Database (Legacy)
More like this
Scm Activity SQL Commands or CLI
Scm Activity SQL Commands or CLI
More like this
Scm Activity App Schema Table Definition
Scm Activity App Schema Table Definition
More like this
SCM Activity Context Panel
SCM Activity Context Panel
Read with this
Scm Activity REST API Interface or CLI
Scm Activity REST API Interface or CLI
More like this
Scm Activity REST API Interface or CLI (Legacy)
Scm Activity REST API Interface or CLI (Legacy)
More like this