Dream Extractor

Outline

Application which extracts transaction from the Mantiki database, processes it and places it in the MantkikiFeed database. This is then accessed by Finance for accounting purposes on transactions.

High Level Structure

/wiki/spaces/ITWEB/pages/520782074

Basic Structure & Logic

Deeper Structure & Logic

Run Dream Extractor

In production there is a Rundeck job for running Dream Extractor. This runs every 5 minutes.

Stop Dream Extractor

To stop production dream extractor, for example if a server update is required:

Login to Rundeck
Open Projects > Virgin Wines
Scroll down and click on 'Production Dream Extractor'
Click on the drop-down menu at the top left of the webpage and tick 'Disable execution'
Scroll down. Under 'Activity for this job', click on 'running' and wait for currently running jobs to complete.
The Dream extractor job is now stopped.
Remember to re-enable the job after the work is complete by reverting the action at step 4 (Tick 'Enable execution').

Accessing Dream Extractor tables

Access Dream Extractor Database

If you don't already have an SQL Server client (eg SQL Server Management Studio) you need one. If you're on Windows install Toad for SQL Server; if you're on Linux install DBeaver; or use another SQL Server client. (toad available here: https://www.toadworld.com/p/downloads - you'll need to create an account with quest and get the freeware of Toad for SQL Server - dbeaver available here: https://dbeaver.jkiss.org/download/)

Connect to dream qa db here:
JDBC URL: jdbc:sqlserver://VWPreSQL01:1433;databaseName=MantikiFeed_QA
Server : VWPreSQL01
Port: 1433
Database: MantikFeed_QA
Username: MantikiFeedQAUserRO
Password:

EG if using DBEAVER

Create new connection

Choose MS SQL Server>Microsoft Driver

Untick Windows Authentication

Host: VWPreSQL01
Database:
Username: MantikiFeedQAUserRO
Password:

(keep database blank)