Prostore

Prostore is an open-source integration system providing a temporal DB unified interface to the heterogenous data store. It’s purposed for a datamart implementation.

Useful links

Documentation (Rus)

Local deployment

The main prerequisites include git, Java and Apache Maven.

The cloning and building of the Prostore repository

# clone
git clone https://repository.datamart.ru/datamarts/prostore
# build without any tests
cd ~/prostore
mvn clean
mvn install -DskipTests=true

The resulting jar file is located in the dtm-query-execution-core/target folder.

App configuration

The Prostore configuration file is located in the dtm-query-execution-core/config folder. The Prostore application looks for the configuration in the same subfolder (target) where dtm-query-execution-core-<version>.jar is executed. So we create the respective symbolic link

sudo ln -s ~/prostore/dtm-query-execution-core/config/application.yml ~/prostore/dtm-query-execution-core/target/application.yml

If no configuration file is located, then the Prostore application uses its internal default configuration.

Run application

Run prerequisite obligatory supporting services

Zookeeper,
Kafka,
set of respective DBMS,
kafka-DBMS connectors (e.g. see kafka-postgres-connector),
Prostore status monitor.

Run main service as a single jar on the default port 8080

cd ~/prostore/dtm-query-execution-core/target
java -jar dtm-query-execution-core-<version>.jar

Change default port to run Prostore

change the value of the key server:port in the configuration file or DTM_METRICS_PORT environment variable

Setup JDBC test client

Use DTM JDBC driver. URL is jdbc:prostore://<host>:<port>/:

host is host of dtm-query-execution-core (localhost)
port is port of dtm-query-execution-core (see actual application.yml for dtm-query-execution-core)