Outline
Child Pages
Account AdjustmentsApplication 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)