Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Outline

Child Pages

High Level Structure

Sales

Refunds

Winebank Payment

Winebank Refunds

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

Basic Structure & Logic

Deeper Structure & Logic

Sales

Refunds

WineBank Payment

WineBank Refunds

BeerSave Payment

BeerSave Refunds

SpiritSave Payment

SpiritSave Refunds

Account Adjustments

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:

  1. Login to Rundeck
  2. Open Projects > Virgin Wines
  3. Scroll down and click on 'Production Dream Extractor'
  4. Click on the drop-down menu at the top left of the webpage Image Addedand tick 'Disable execution'
  5. Scroll down. Under 'Activity for this job', click on 'running' and wait for currently running jobs to complete.
  6. The Dream extractor job is now stopped.
  7. 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)