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.
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: MF0910ro8bm
EG if using DBEAVER
Create new connection
Choose MS SQL Server>Microsoft Driver
Untick Windows Authentication
Host: VWPreSQL01
Database:
Username: MantikiFeedQAUserRO
Password: MF0910ro8bm
(keep database blank)